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. >
