Re: Exception in this method

[David E Jones]

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

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)

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

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)

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: java.sql.SQLException

org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:152)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:203)

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:191:WARN ]

Exception: java.sql.SQLException


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


please include the full stack trace.

Jose Diaz wrote:

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)) 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) ---- 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.util.EntityListIterator.close(EntityListIterator.java: 138) org .ofbiz .entity.util.EntityListIterator.finalize(EntityListIterator.java:495) ---- exception report ---------------------------------------------------------- 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.util.EntityListIterator.close(EntityListIterator.java: 138) org .ofbiz .entity.util.EntityListIterator.finalize(EntityListIterator.java:495) 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) ---- exception report ---------------------------------------------------------- Message: Cannot rollback a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25) You will need to provide more information. What were you doing when this exception occurred? Also,

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())

try {
con.commit();
} catch (SQLException e) {
setError(e);
throw e;
}
}

Please, let me know if someone can help with it issue.

Regards

Jose.

throw new SQLException("Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25)");

smime.p7s
Description: S/MIME cryptographic signature