This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes ][SQLServer 2000 Driver for JDBC]ResultSet can not re-read Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "][SQLServer 2000 Driver for JDBC]ResultSet can not re-read" Watch "][SQLServer 2000 Driver for JDBC]ResultSet can not re-read" New topic
Author

][SQLServer 2000 Driver for JDBC]ResultSet can not re-read

Pourang Emami
Ranch Hand

Joined: Sep 21, 2002
Posts: 127
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


Best Regards,<br />Pourang Emami
Wayne L Johnson
Ranch Hand

Joined: Sep 03, 2003
Posts: 399
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.
Mathias Nilsson
Ranch Hand

Joined: Oct 13, 2003
Posts: 107
Wayne L Johnson is right. I have the same problem with my sun.jdbc.odbc.JdbcOdbcDriver. ( Access 2000 database )

generates this error: No data found
While this code

runs fine.


SCJP2 , MCP( 70-229 ) , Preparing For SCWDC
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ][SQLServer 2000 Driver for JDBC]ResultSet can not re-read