Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Pourang Emami
Ranch Hand
Posts: 127
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Wayne L Johnson
Ranch Hand
Posts: 399
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 107
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic