OFBiz › OFBiz - User

Offline payment applied to billing account

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

12 messages Options

Rashko Rejmer

Offline payment applied to billing account

I wanted to ask about the snippet of code in InvoiceServices.createInvoiceForOrder(lines 760-791) method that creates payment applications for payments, received before creation of invoice.

Parameter billingAccountId is passed to the service createPaymentApplication. So every payment that was received before creation of invoice is applied to the created invoice and billing account(if the invoice was paid with BA and another payment method E.g offline payment).

I will give example:
1. Create invoice for 100 $;
2. Pay the invoice with billing account(40$) and with offline payment method(the rest - 60$);
3. Receive Offline payment for 40$ before creation of invoice(orderview screen);
4. Quick ship entire order;

Now received offline payment is applied to invoice and billing account.
I know that this situation doesn't affect billing account available balance but I was curious if this is right or not.

Thanks,
Rashko Rejmer

Jose Diaz-3

Exception in this method

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.

Adrian Crum

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

Jose Diaz-3

RE: Exception in this method

In reply to this post by Jose Diaz-3

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 <[hidden email]>
Sent: Tue, 10/30/2007 7:02pm
To: [hidden email]
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:

David E Jones

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 <[hidden email]>
> Sent: Tue, 10/30/2007 7:02pm
> To: [hidden email]
> 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.
>>

smime.p7s (3K) Download Attachment

Jose Diaz-3

RE: Exception in this method

I am using opentaps-0.9.4

Jose.

----- Original Message -----
From: David E Jones <[hidden email]>
Sent: Tue, 10/30/2007 7:38pm
To: [hidden email]
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:

David E Jones

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 <[hidden email]>
> Sent: Tue, 10/30/2007 7:38pm
> To: [hidden email]
> 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 <[hidden email]>
>> Sent: Tue, 10/30/2007 7:02pm
>> To: [hidden email]
>> 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.
>>>

smime.p7s (3K) Download Attachment

Scott Gray

Re: Exception in this method

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 <[hidden email]> 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 <[hidden email]>
> > Sent: Tue, 10/30/2007 7:38pm
> > To: [hidden email]
> > 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 <[hidden email]>
> >> Sent: Tue, 10/30/2007 7:02pm
> >> To: [hidden email]
> >> 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.
> >>>
>
>
>

David E Jones

Re: Exception in this method

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 <[hidden email]> 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 <[hidden email]>
>>> Sent: Tue, 10/30/2007 7:38pm
>>> To: [hidden email]
>>> 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 <[hidden email]>
>>>> Sent: Tue, 10/30/2007 7:02pm
>>>> To: [hidden email]
>>>> 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.
>>>>>
>>
>>
>>

smime.p7s (3K) Download Attachment

Scott Gray

Re: Exception in this method

Oh ok i see, we're all good then :-)

Scott

On 31/10/2007, David E Jones <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
> >>> Sent: Tue, 10/30/2007 7:38pm
> >>> To: [hidden email]
> >>> 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 <[hidden email]>
> >>>> Sent: Tue, 10/30/2007 7:02pm
> >>>> To: [hidden email]
> >>>> 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.
> >>>>>
> >>
> >>
> >>
>
>
>

Jose Diaz-3

RE: Exception in this method

In reply to this post by David E Jones

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 <[hidden email]>
Sent: Tue, 10/30/2007 7:51pm
To: [hidden email]
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:

BJ Freeman

Re: Exception in this method

In reply to this post by Jose Diaz-3

my guess is that you have not connected to your DB at startup.
if (con == null) throw new SQLException(CLOSED)

this may be your entityengine.xml setup
or the DB, may not be running
or the DB is not accessible from this server.

please explain you specific setup. relative to the DB and ofbiz.

Jose Diaz sent the following on 10/30/2007 3:50 PM: