Re: Closing Statements and ResultSets - Mailing list pgsql-jdbc

From Daniel Serodio
Subject Re: Closing Statements and ResultSets
Date
Msg-id 1031678395.10862.43.camel@kelly
Whole thread Raw
In response to Re: Closing Statements and ResultSets  (Barry Lind <barry@xythos.com>)
List pgsql-jdbc
Barry,

Thanks for the reply. But i'm thinking, since the Connection holds
references to it's Statements, it could close the Statements before
returning the Connection to the pool, couldn't it?

On Mon, 2002-09-09 at 18:11, Barry Lind wrote:
> Daniel,
>
> If you are using virtually any connection pool closing the connection
> alone will not be enough.  Because in a connection pool environment
> closing a connection doesn't really close the connection, it just
> returns it to the pool, thus any resources you haven't closed explicitly
> will remain open and allocated.
>
> --Barry
>
> Daniel Serodio wrote:
> >     Hi! I usually close just the Connection object, understanding that it's
> > associated Statement's, PreparedStatement's and ResultSet's will be
> > automatically closed.
> >
> >     I'm trying to setup Protomatter JDBC Connection Pool with PostgreSQL,
> > and Protomatter's documentation state that "It's also important to make
> > sure you close all Statement, PreparedStatement and ResultSet objects
> > associated with a connection before you close the connection itself.".
> >
> >     I emailed Protomatter's author, and he said that "specifically Oracle
> > is not good about doing that.  If you don't close the statements you'll
> > eventually get an error like "can't open any more cursors" or something
> > like that..."
> >
> >     My question is: do I need to close the Statements or is closing the
> > Connection enough?
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
[]'s
Daniel Serodio


pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: [HACKERS] problem with new autocommit config parameter
Next
From: Barry Lind
Date:
Subject: Re: Closing Statements and ResultSets