reuse the ResultSet object in java

Question

I am working on a swing project. In which i am using jdbc odbc Connection bridge to access the data from SQL database. I am using the following code

 try
  {
     Class.forName("sun.jdbc.odbc.JdbcodbcDriver");
     Connection con=DriverManager.getConnection("Jdbc:Odbc:dsn");
     Statement st=con.createStatement();
     ResultSet rs=st.executeQuery("select * from temp");
     int count c=0;
     while(rs.next())
     {
      c++;
     }

   }
  catch(Exception ex)        
   {
    ex.printStackTrace();
    }

In the above code after while loop, if i use again the result set object then it throws the exception as result set is closed . Is there any other object instead of result set to fetch the data from database in disconnected mode.

Do you mean you want to collect what is in the result set into another structure? — fge
– fge, Commented Jan 9, 2013 at 7:40
Why you want to use the result set after the while loop?Within the while loop itself, you can collect all the data. — Renjith
– Renjith, Commented Jan 9, 2013 at 7:41
"to fetch the data from database in disconnected mode" Yes, that would be a challenge. — Paul Bellora
– Paul Bellora, Commented Jan 9, 2013 at 7:42

Denys Séguret · Accepted Answer · 2013-01-09 07:51:46Z

9

The result set doesn't contain the results, it's a kind of iterator over the results that still are in the database (or in a cache in the driver).

So that's totally normal.

If you want to keep a list of the results after you disconnected, just copy them to a concrete list before, for example an ArrayList. This means you'll have to do the interpretation of the columns (i.e. using getInt or getString or getBinaryStream and fetching the content, etc.) at the time of this copy.

edited Jan 9, 2013 at 7:51

answered Jan 9, 2013 at 7:41

Denys Séguret

384k90 gold badges813 silver badges780 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

adesh singh Over a year ago

Is it possible to store a result set to another result set for further use

Denys Séguret Over a year ago

You mean without disconnecting ?

adesh singh Over a year ago

yes i want to store result set in another before disconnecting first

Denys Séguret Over a year ago

If you disconnect, no result set can be usable. Copy the data into an arrayList or don't disconnect.

Azodious · Accepted Answer · 2013-01-09 07:42:32Z

4

Is there any other object instead of result set to fetch the data from database in disconnected mode.

ResultSet gets the data after the connections has been established. And there is no other object to perform this task.

You should store the data in some list ( or other data structure) and within while loop fill that list from ResultSet

answered Jan 9, 2013 at 7:42

Azodious

13.9k1 gold badge41 silver badges75 bronze badges

2 Comments

adesh singh Over a year ago

Is it possible to store the resultset in another resultset for further use

Mark Rotteveel Over a year ago

@user1960524 Yes, with a CachedRowSet (or one of the other RowSet implementations)

Collectives™ on Stack Overflow

reuse the ResultSet object in java

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related