then your surely have something wrongly configured or you call close on the datasource yourself but it would need a sample to reproduce to digg into it.
BTW don't set defaultAutoCommit if you use a JTA datasource Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn: http://fr.linkedin.com/in/rmannibucau Github: https://github.com/rmannibucau 2014-05-21 9:02 GMT+02:00 Chris Rohr <[email protected]>: > Now, I get the following Exceptions: > > 1. > > May 21, 2014 8:11:34 AM > org.apache.openejb.core.transaction.EjbTransactionUtil > handleSystemException > SEVERE: EjbTransactionUtil.handleSystemException: Failed to execute query > "SELECT Count(u) FROM User u WHERE Upper(u.nick) = :Nickname". Check the > query syntax for correctness. See nested exception for deta$ > <openjpa-2.3.0-nonfinal-1540826-r422266:1542644 nonfatal user error> > org.apache.openjpa.persistence.ArgumentException: Failed to execute query > "SELECT Count(u) FROM User u WHERE Upper(u.nick) = :Nickname". $ > > ... > > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: No operations > allowed after connection closed. {SELECT COUNT(t0.id) FROM User t0 WHERE > (UPPER(t0.nick) = ?)} [code=0, state=08003] > > > 2. > > > May 21, 2014 8:11:52 AM > org.apache.geronimo.transaction.manager.TransactionImpl enlistResource > WARNING: Unable to enlist XAResource > org.apache.openejb.resource.jdbc.managed.local.LocalXAResource@62a52a84, > errorCode: 0 > javax.transaction.xa.XAException: Count not turn off auto commit for a XA > transaction > > ... > > Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No > operations allowed after connection closed. > > > Thank you :-) > > > > > -- > View this message in context: > http://openejb.979440.n4.nabble.com/Transaction-Manager-Failure-tp4669403p4669476.html > Sent from the OpenEJB User mailing list archive at Nabble.com. >
