OK i solved it problem in it version doing less
findByAnd(), findBycondition, etc etc
inside for or while sentences.
Jose.
----- Original Message -----
From: David E Jones <[EMAIL PROTECTED]>
Sent: Tue, 10/30/2007 7:51pm
To: user@ofbiz.apache.org
Subject: Re: Exception in this method
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: user@ofbiz.apache.org
> 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: user@ofbiz.apache.org
>> 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.
>>>
