Re: closing statements when connection is closed

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: closing statements when connection is closed
Дата
Msg-id 4028DBFB.6010701@opencloud.com
обсуждение исходный текст
Ответ на Re: closing statements when connection is closed  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: closing statements when connection is closed
Re: closing statements when connection is closed
Список pgsql-jdbc
Dave Cramer wrote:
> In the JDBC API Tutorial and Reference, it suggests that driver
> implementors assume the worst, so I think that we should attempt to
> clean up our clients connections as best we can.

Sure. It just seems like a fair amount of work to support a case where
we will leak memory regardless of what the driver does. The client is
keeping the Statement/ResultSet alive, there's nothing the driver can do
to cause GC of that object, at best all we can do is reduce the
footprint of the leaked objects. Is doing this worth the extra
complexity in the driver? It doesn't look like a common error to me..

> On Mon, 2004-02-09 at 23:33, Oliver Jowett wrote:
>>As far as I can see the only additional thing we'd be able to clean up
>>is clearing the reference to row data held by open ResultSet objects.
>>This is only going to have an effect if something outside the driver is
>>holding references to the ResultSet or Statement after closing the
>>connection -- which seems like an application bug to me.

-O

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Pl/Java 1.0.0.b now avaiable on Linux 386 and Cygwin
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: closing statements when connection is closed