Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

getting re-read error

 
sabu ekm
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hai all,
iam using jboss as the application server, and ms-sql as back end.
while trying to get data from a resultset using jdbc, iam getting an SQL exception like this.

*************

"10:21:07,328 INFO [STDOUT] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 8."

*************


but iam sure that i am not re-reading the data any where in my code.
but in some other programs iam re-reading the data, then also iam not getting the error, but here iam not re-reading the data . but getting the error.

if u have any idea regarding this error pls help me.
thanx in advance.
 
sabu ekm
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hai all, i got the solution.
so no need to post to this silly thread,

For any row in the ResultSet, you can read any column from left to right, and each column should be read only one time. If you try to read columns out of order, or if you re-read a column from the ResultSet, you may receive the error message that the "Symptoms" section describes.
To prevent the problem, read the ResultSet columns in order.

thanx
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34672
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sabu,
Thanks for posting the solution.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic