opentaps 1.0 was based on our release branch, so it's possible the problem still exists there.
Regards Scott On 31/10/2007, David E Jones <[EMAIL PROTECTED]> wrote: > > 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. > >>> > > >
