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
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
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
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,
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
@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
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
-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
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
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
10 matches
Mail list logo