Oh ok i see, we're all good then :-) Scott
On 31/10/2007, David E Jones <[EMAIL PROTECTED]> wrote: > > He is actually using "opentaps-0.9.4", I just mentioned 1.0 because I > know it's been a while since that, and I'm guessing 0.9.4 was from a > while before that. > > I don't remember exactly when this was fixed, but I think it was > before the release branch was done. > > -David > > > On Oct 30, 2007, at 8:29 PM, Scott Gray wrote: > > > 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. > >>>>> > >> > >> > >> > > >
