AW: AW: postgres, idle in transaction

2007-04-26 Thread Oilid Adsi
An: user@cayenne.apache.org Betreff: Re: AW: postgres, idle in transaction Hello. I am reading this thread and just want to say that I am using cayenne 2.0.2, postgresql-8.2-504.jdbc3.jar and postgresql-8.2.3. Cayenne uses jndi to get connections from a jboss-4.0.3 connection pooling. I

Re: AW: AW: postgres, idle in transaction

2007-04-26 Thread Andrus Adamchik
On Apr 26, 2007, at 1:14 PM, Oilid Adsi wrote: Or maybe by adding an explicit COMMIT after every SELECT- Statement when the connection will be returned to the pool? Can this implemented as an optional function to the Cayenne framework? Per your comment the patch doing rollback didn't help,

AW: AW: postgres, idle in transaction

2007-04-24 Thread Oilid Adsi
-Ursprüngliche Nachricht- Von: Andrus Adamchik [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 24. April 2007 16:21 An: user@cayenne.apache.org Betreff: Re: AW: postgres, idle in transaction On Apr 24, 2007, at 5:17 PM, Andrus Adamchik wrote: Interesting... Looking at your log