Re: exception while upgrading driver - Mailing list pgsql-jdbc

From Sathyajith G
Subject Re: exception while upgrading driver
Date
Msg-id 970549EC73A.000005A3sathyajith@inbox.com
Whole thread Raw
In response to Re: exception while upgrading driver  (Kris Jurka <books@ejurka.com>)
Responses Re: exception while upgrading driver
List pgsql-jdbc
>>
>
> On Tue, 7 Jun 2005, Sathyajith G wrote:
>
> >    i have the following code running without any errors with postgres
> 7.4.2.
> > driver.
> >
> > String qry="select ...;
> >
> > try{
> >   ResultSet rs=Data.getResultSet(qry);
> >   while(rs.next())
> >
> > I changed the driver to postgres 8.0.1.  Strangely now, the above code
> gives
> > the exception "The resultset is closed". Please help.
> >
>
> I suspect your Data.getResultSet() method looks something like this:
>
>
> Statement stmt = conn.createStatement();
> ResultSet rs = stmt.executeQuery(sql);
> stmt.close();
> return rs;
>
> This is not a legal thing to do, closing the Statement also closes the
> ResultSet that was created by it.  The 7.4 driver did not correctly check
> this, but the 8.0 version does.  You most postpone the Statement close
> until you are done with the ResultSet.
>
> Kris Jurka
>

-------------------------------------------------------------------

i am not closing the statement anywhere. this is how Data.getResultSet()
looks like:

public static  ResultSet getResultSet(String sql)
     {
       ResultSet rs;
        try{
             rs=stmt.executeQuery(sql);
            }catch(Exception e)
                   {System.err.println("error");
                    rs=null;
                    }
            return rs;
     }


Sathyajith Gopi

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: exception while upgrading driver
Next
From: Oliver Jowett
Date:
Subject: Re: DatabaseMetaData and Transactions