Re: behavior at the end of a transaction

From: Radosław Smogura <rsmogura(at)softperience(dot)eu>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Jean-Max Reymond <jmreymond(at)gmail(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: behavior at the end of a transaction
Date: 2011-09-20 09:36:01
Message-ID: e6183bea6ede88fc21eb7639f83adfc4@mail.softperience.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Mon, 19 Sep 2011 15:34:19 -0500, Kevin Grittner wrote:
> Jean-Max Reymond <jmreymond(at)gmail(dot)com> wrote:
>
>> On commit or rollback statement, I expect that all the cursors
>> are closed (all my Resultset not closed) in the postgres database.
>> is it correct ?
>
> No.
>
> http://www.postgresql.org/docs/9.1/interactive/sql-declare.html
>
> In particular, see the WITH/WITHOUT HOLD section.
>
> -Kevin

Don't worry, If you "forget" result sets, when those will be GCed then
cursors will be closed soon, too.

Regards,
Radosław Smogura

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mikko Tiihonen 2011-09-20 14:00:41 Re: binary patch problems
Previous Message Guillaume 2011-09-20 09:18:40 Re: jdbc and automagic casting