Article ID: 824106 - View products that this article applies to.
You have a Java application that uses JDBC to retrieve a ResultSet object by using the Microsoft SQL Server 2000 Driver for JDBC. When you try to read a column in the ResultSet, you may receive the following error message:
Note In this error message, the words "can not" are a misspelling for the word "cannot."
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
The column number that the error message refers to is dependent on the schema of your ResultSet object.
This error occurs with ResultSet objects that contain a BLOB column (for example, text, ntext, or image data types). The driver cannot return a BLOB column out of order because it does not cache all the content of BLOB data types because of size limitations.
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.
Steps to Reproduce the Behavior
Create the Test Table
Create and Test the Java Application
For additional information about Microsoft JDBC, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/313100/ )HOW TO: Get Started with Microsoft JDBC
Article ID: 824106 - Last Review: September 23, 2003 - Revision: 1.1