Java- creating multiple ResultSets out of same Statement object- will it have any effects?

Question

I have a 2 ResultSet's generated from the same Statement object.

Code Sample follows:

Connection con            = null;
Statement  stmt           = null;
ResultSet rs = null;

con = DBAccess.getConnection();
stmt = con.createStatement();

rs = stmt.executeQuery(Query1);
// operate on the resultset

rs = stmt.executeQuery(Query2);   // Is it legal and do not have side-effects?
// operate on the resultset

// close everythings (Resultset, Statement, Connection)

I checked it to work well. My doubt is will it have any side effects ?

Denys Séguret · Accepted Answer · 2012-07-18 18:12:21Z

10

From the javadoc :

By default, only one ResultSet object per Statement object can be open at the same time. Therefore, if the reading of one ResultSet object is interleaved with the reading of another, each must have been generated by different Statement objects. All execution methods in the Statement interface implicitly close a statment's current ResultSet object if an open one exists.

So yes, you can do it safely. You just can't use your first resultset after you have executed the second query.

answered Jul 18, 2012 at 18:12

Denys Séguret

384k90 gold badges813 silver badges780 bronze badges

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

Comments

Sankar · Accepted Answer · 2012-09-22 09:47:33Z

2

There will be only one Resultset object for each and every statement object. So, When you execute another query, internally it will close the existing resultset object and opens a new resultset object. But you cannot access the previous resultset obejct.

There will be no side effects. you can use it as you wish.

answered Sep 22, 2012 at 9:47

Sankar

1722 silver badges13 bronze badges

Comments

Sowmya · Accepted Answer · 2012-09-11 21:17:01Z

0

Remember to close the first resultset before using the same variable to reference the second resultset. If you close the resultset only after the execution of the second statement, the second resultset is closed and the first resultset is not closed.

answered Sep 11, 2012 at 21:17

Sowmya

1

1 Comment

Arun Over a year ago

But in above answer dystroy quotes from Javadoc that "All execution methods in the Statement interface implicitly close a statment's current ResultSet object if an open one exists." So it should be auto closed Right ?

Collectives™ on Stack Overflow

Java- creating multiple ResultSets out of same Statement object- will it have any effects?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related