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