getting re-read error

[sabu ekm]

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]

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]

Sabu,
Thanks for posting the solution.