Re: postgres, idle in transaction

2007-04-27 Thread Tore Halset
Betreff: Re: AW: AW: postgres, idle in transaction 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

AW: postgres, idle in transaction

2007-04-27 Thread Peter Schröder
hi tore, thank you for the hint, we are thankfull for all the help. kind regards peter -Ursprüngliche Nachricht- Von: Tore Halset [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 27. April 2007 08:52 An: user@cayenne.apache.org Betreff: Re: postgres, idle in transaction Hello. Creating

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,

Re: AW: postgres, idle in transaction

2007-04-25 Thread Tore Halset
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 do not see the postgres, idle in transaction problem. - Tore. On Apr 25

Re: AW: postgres, idle in transaction

2007-04-24 Thread Andrus Adamchik
@cayenne.apache.org Betreff: Re: postgres, idle in transaction On Apr 24, 2007, at 12:58 PM, Oilid Adsi wrote: Normally I thought we can do the workaround with committing every query (method commitChanges in the DataContext) or setting the JDBC- parameter defaultAutoCommit=true. But both

Re: AW: postgres, idle in transaction

2007-04-24 Thread Andrus Adamchik
On Apr 24, 2007, at 5:17 PM, Andrus Adamchik wrote: Interesting... Looking at your log I see this: 15:33:08.267 (2) FE= Parse(stmt=S_1,query=BEGIN,oids={}) . 15:33:08.268 (2) FE= Parse(stmt=null,query=SELECT 15:33:28.461 (2) FE= Parse(stmt=S_2,query=COMMIT,oids={}) So

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

Re: postgres, idle in transaction

2007-04-24 Thread Andrus Adamchik
much hope this will fix it... but still worth a try. Andrus On Apr 24, 2007, at 5:28 PM, Oilid Adsi wrote: -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

postgres, idle in transaction

2007-04-03 Thread Peter Schröder
hi there, we have some trouble with our postgres database using cayenne. our application is not writing any data to the db, there is only read-statements. nevertheless we have some connections in idle in transaction state, wich indicates some transactions not beeing properly closed. i found a