This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC 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
Bookmark "getting re-read error" Watch "getting re-read error" New topic
Author

getting re-read error

sabu ekm
Greenhorn

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
Greenhorn

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.

thanx
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30580
    
154

Sabu,
Thanks for posting the solution.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
GeeCON Prague 2014
 
subject: getting re-read error