Re: Mutiple ResultSet objects with same Statement object

From:

"teser3@hotmail.com" <teser3@hotmail.com>

Newsgroups:

comp.lang.java.programmer

Date:

Thu, 27 Sep 2007 16:42:18 -0700

Message-ID:

<1190936538.400603.325810@o80g2000hse.googlegroups.com>

On Sep 27, 6:29 pm, Arne Vajh=F8j <a...@vajhoej.dk> wrote:

tes...@hotmail.com wrote:

Is it okay to create 3 different ResultSets with the same Statement
object? Here is what I am currently using in my Database statements
with Oracle and everything works great. But I am wondering if this
will create Database resource leakages or other issues:

It is OK, but I think you should close the previous result set before
opening a new one.

Arne

You mean like this?

try {
results1 = statement.executeQuery("select name from
tableone");
        if(results1.next())
        {
             int myvar = ....
        }
        ....
        finally {
        //close results1 object only here

     try {
results2 = statement.executeQuery("select name from
tableone");
        if(results2.next())
        {
             int myvar = ....
        }
        ....
        finally {
        //close results2 object only here

try {
results3 = statement.executeQuery("select name from
tableone");
        if(results3.next())
        {
             int myvar = ....
        }
        ....
        finally {
        //close results3 object only here

        ...

        //Finally block here that closes results3,
statement and connection object references