I'm not really sure which revision of OFBiz that is, ie which revision from the OFBiz SVN that Open Source Strategies originally used for their branch of OFBiz.
This is an older version either way, I think it was a while back that OSS did their version 1.0 of opentaps.
The reason I asked was because that is an error from quite a while back that has been significantly improved in more recent code. And yes, it may be related to a transaction timeout, or a setRollbackOnly.
-David On Oct 30, 2007, at 6:40 PM, Jose Diaz wrote:
I am using opentaps-0.9.4 Jose. ----- Original Message ----- From: David E Jones <[EMAIL PROTECTED]> Sent: Tue, 10/30/2007 7:38pm To: [email protected] Subject: Re: Exception in this method Which version/revision of OFBiz are you using? -David On Oct 30, 2007, at 6:11 PM, Jose Diaz wrote:I am executing a service (generating aging report) in the job list. I have big data (2 months of balance) When i execute my service with few data, i don't have error. It is timeout problem?? Specifications: MySQL 5.0 mysql-connector-java-3.0.17-ga-bin.jar Log: Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25)) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25)) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:161) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:203) org.ofbiz.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:803) java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83) java.lang.ref.Finalizer.access$100(Finalizer.java:14) java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160) java.sql.SQLException: Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25) org .ofbiz .minerva .pool .jdbc.xa.wrapper.XAClientConnection.commit(XAClientConnection.java: 250) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:152) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:203) org.ofbiz.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:803) java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83) java.lang.ref.Finalizer.access$100(Finalizer.java:14) java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160) ------------------------------------------------------------------ ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Cannot rollback a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25) org .ofbiz .minerva .pool .jdbc.xa.wrapper.XAClientConnection.rollback(XAClientConnection.java: 262) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:178) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:157) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:203) org .ofbiz.entity.util.EntityListIterator.close(EntityListIterator.java: 138) org .ofbiz .entity.util.EntityListIterator.finalize(EntityListIterator.java:495) java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83) java.lang.ref.Finalizer.access$100(Finalizer.java:14) java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160) -------------- 2007-10-30 18:52:24,500 (Finalizer) [ SQLProcessor.java:155:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25) ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25) org .ofbiz .minerva .pool .jdbc.xa.wrapper.XAClientConnection.commit(XAClientConnection.java: 250) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:152) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:203) org .ofbiz.entity.util.EntityListIterator.close(EntityListIterator.java: 138) org .ofbiz .entity.util.EntityListIterator.finalize(EntityListIterator.java:495) java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83) java.lang.ref.Finalizer.access$100(Finalizer.java:14) java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160) -------------------------------------------------------------------------------- 2007-10-30 18:52:24,500 (Finalizer) [ SQLProcessor.java:190:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Cannot rollback a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25) 2007-10-30 18:52:24,500 (Finalizer) [ SQLProcessor.java:191:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Cannot rollback a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25) I hope it help for identify the error or your suggestions. Jose. - Original Message ----- From: Adrian Crum <[EMAIL PROTECTED]> Sent: Tue, 10/30/2007 7:02pm To: [email protected] Subject: Re: Exception in this method You will need to provide more information. What were you doing when this exception occurred? Also, please include the full stack trace. Jose Diaz wrote:I am getting it error and no idea about the solution. This is the method: public void commit() throws SQLException { if (con == null) throw new SQLException(CLOSED); if (((XAResourceImpl) xaCon.getXAResource()).isTransaction()) throw new SQLException("Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25)"); try { con.commit(); } catch (SQLException e) { setError(e); throw e; } } Please, let me know if someone can help with it issue. Regards Jose.
smime.p7s
Description: S/MIME cryptographic signature
