Re: Unable to commit: transaction marked for rollback - Mailing list pgsql-jdbc

From David Kerr
Subject Re: Unable to commit: transaction marked for rollback
Date
Msg-id 20100706161630.GC42694@mr-paradox.net
Whole thread Raw
In response to Unable to commit: transaction marked for rollback  (David Kerr <dmk@mr-paradox.net>)
List pgsql-jdbc
I wanted to follow up on this with what we think is the solution.

we increased the value in this Geronimo config.xml

<module name="org.apache.geronimo.configs/transaction/2.1.4/car">
  <gbean name="TransactionManager">
               <attribute name="defaultTransactionTimeoutSeconds">3600</attribute>
  </gbean>
</module>


If we decrease that to like 15 seconds, we can reproduce the problem every time.

So, as a fix, we've increased it to a high enough value. Now, of course, the key
is to remember this so that if it happens again we'll know that we hit the new
max timeout.

Thanks!

Dave

pgsql-jdbc by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Interpretability with xDBC specification
Next
From: Lew
Date:
Subject: Re: Interpretability with xDBC specification