PRB: "ResultSet Can Not Re-Read Row Data"' Error When Reading Data from a JDBC ResultSet Object

Steps to Reproduce the Behavior

Create the Test Table

1. Start Microsoft SQL Query Analyzer.
2. Paste the following SQL queries in Query Editor:

   use pubs;
   create table myTable (fld1 int, fld2 varchar(20), remark text);
   insert into myTable values (1, 'Joseph', 'Text for Joseph');
   insert into myTable values (2, 'Michael', 'Text for Michael');
   insert into myTable values (3, 'Thomas', 'Text for Thomas');
   

3. On the Query menu, click Execute.
4. Quit Microsoft SQL Query Analyzer.

Create and Test the Java Application

1. Paste the following code in Notepad, or a t ext editor of your choice:

   import java.sql.*;
   import java.io.*;
   
   public class Class1
   {
   	public static void main (String[] args)
   	{
   		try
   		{
   			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" );
   			Connection connection = DriverManager.getConnection("jdbc:microsoft:sqlserver://server:1433;databasename=pubs;SelectMethod=direct", "<UserId>","<PassWd>");
   			Statement stmt = connection.createStatement();
   			String s = "SELECT fld1, fld2, remark FROM myTable";
   			ResultSet rs = null;
   			rs = stmt.executeQuery(s);
   			System.out.println("Success! The following are the rows in this query:");
   			int fld1;
   			String fld2;
   			String remark;
   			while (rs.next())
   			{
   				remark = rs.getString("remark"); //fails if in this order
   				fld1 = rs.getInt("fld1");
   				fld2 = rs.getString("fld2");
   				//remark = rs.getString("remark"); //works fine if in this order
   				System.out.println(fld1 + ", " + fld2 + ", " + remark);
   			}
   			rs.close();
   			stmt.close();
   			connection.close();
   		}
   
   		catch(Exception e)
   		{
   			System.out.println(" Exception = " + e );
   		}
   		try
   		{
   			System.out.println("Press any key to quit...");
   			System.in.read();
   		}
   		catch (Exception e)
   		{
   
   		}
   	}
   }

2. Replace the server, <UserId> and <PassWd> in this code with the name of the computer that is running SQL Server, your user id, and your password.
3. Save this Java code as Class1.java.
4. Compile the Java source file that you created in Step 4, and then run the application. You receive the error message that the "Symptoms" section describes when the first getString call is made.

Back to the top