File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes getting re-read error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "getting re-read error" Watch "getting re-read error" New topic

getting re-read error

sabu ekm

Joined: Jan 15, 2005
Posts: 19
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

Joined: Jan 15, 2005
Posts: 19
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.

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33102

Thanks for posting the solution.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: getting re-read error
It's not a secret anymore!