Hi friends I have a simple query from my db and then trying to read the contents of the ResulSet. I use the 'uniqueIdentifier' data type as my Primary Key here(but not the 3d collumn, as it mentioned in the message), I don't know whether it is related to the problem or not? Any help on getting rid of the following error would be highly appreciated: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 3 Best Regards, Pourang
A stab in the dark, but some JDBC drivers only allow you to read a column value once. If those cases you can't do the following:
The last statement would fail: you'd have to replace it with: String full = first + " " + last; It's hard to know if this is your problem w/out seeing the code, but I have run into this same problem in the past with some drivers.