I am having problems with rs.getObject. I have a program which cycles theough a series of tables on SQLServer 2000 and uses getObject to retrieve information. The problem that I have is that, whilst the program goes through over 2million records without problem, on one particular table there is a hang at the getObject() stage (that is to say, the program stops without giving an exception, as though it is waiting for something to happen). This happens randomly on this table, not usually hanging on the same record twice (i.e. comaring primary keys during test runs shows the records to be distinct). There are times when this table can have 800000 records ectracted before hang and other times the hang occurs after a mere 250 records extracted.
Would anyone have any idea why getObject is hanging?