Error While accessing ofbiz

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Error While accessing ofbiz

Abhijeet Pandey
Hi All,

I am getting following error while accessing ofbiz. The deployment is fine
and it is not giving any error while starting the server but while accessing
it is giving following Error.

Please help.

Unable to enlist XAResource
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@19c741b,
errorCode: 0
javax.transaction.xa.XAException: Count not turn off auto commit for a XA
transaction

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
occurred during the DBComms.receive method. Operation:Connection reset.
Context:(5) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
IO:04fe1, Dbc:cfdd0]. PktNum:0. TotalReceived:0. PktSize:4,096.

Below is the Detailed Log --------------------------->

Httpd started on port: 9989
Sessiond started on port: 9990
2009-12-21 15:55:03,023 (main) [ BeanShellContainer.java:100:INFO ] Started
BeanShell telnet service on 9989, 9990
2009-12-21 15:55:03,023 (main) [ BeanShellContainer.java:101:INFO ] NOTICE:
BeanShell service ports are not secure. Please protect the ports
2009-12-21 15:55:05,037 (org.ofbiz.service.jms.JmsListenerFactory@17eeb7e) [
JmsListenerFactory.java:75 :INFO ] JMS Listener Factory Thread Finished; All
listeners connected.
2009-12-21 15:55:15,055 (org.ofbiz.service.job.JobPoller@223279) [
GenericDispatcher.java:61 :INFO ] Creating new dispatcher [JobDispatcher]
(org.ofbiz.service.job.JobPoller@223279)
2009-12-21 15:55:15,747 (default-invoker-Thread-11) [
JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-11] received job
[Auto-create Fixed Asset Maintenances] from poller
[org.ofbiz.service.job.JobPoller@223279]
2009-12-21 15:55:15,747 (default-invoker-Thread-9) [
JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-9] received job
[Send Email] from poller [org.ofbiz.service.job.JobPoller@223279]
2009-12-21 15:55:15,749 (default-invoker-Thread-7) [
JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-7] received job
[Send Email] from poller [org.ofbiz.service.job.JobPoller@223279]
2009-12-21 15:55:15,750 (default-invoker-Thread-10) [
JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-10] received job
[Send Email] from poller [org.ofbiz.service.job.JobPoller@223279]
2009-12-21 15:55:15,750 (default-invoker-Thread-8) [
JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-8] received job
[Send Email] from poller [org.ofbiz.service.job.JobPoller@223279]
2009-12-21 15:55:16,171 (default-invoker-Thread-9) [
SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [JobSandbox];
curSeqId=65900, maxSeqId=66000, bankSize=100
2009-12-21 15:55:16,219 (default-invoker-Thread-7)
[PersistedServiceJob.java:178:INFO ]
org.ofbiz.service.job.PersistedServiceJob@e1b74e[65803] -- Next runtime: Mon
Dec 21 16:10:15 IST 2009
2009-12-21 15:55:16,219 (default-invoker-Thread-11)
[PersistedServiceJob.java:178:INFO ]
org.ofbiz.service.job.PersistedServiceJob@b65057[65825] -- Next runtime: Mon
Dec 21 16:00:15 IST 2009
2009-12-21 15:55:16,220 (default-invoker-Thread-8)
[PersistedServiceJob.java:178:INFO ]
org.ofbiz.service.job.PersistedServiceJob@165520d[65801] -- Next runtime:
Mon Dec 21 16:10:15 IST 2009
2009-12-21 15:55:16,220 (default-invoker-Thread-9)
[PersistedServiceJob.java:178:INFO ]
org.ofbiz.service.job.PersistedServiceJob@ee0989[65800] -- Next runtime: Mon
Dec 21 16:10:15 IST 2009
2009-12-21 15:55:16,222 (default-invoker-Thread-10)
[PersistedServiceJob.java:178:INFO ]
org.ofbiz.service.job.PersistedServiceJob@f183bd[65804] -- Next runtime: Mon
Dec 21 16:10:15 IST 2009
2009-12-21 15:55:16,305 (default-invoker-Thread-8) [
AbstractEngine.java:73 :INFO ] Loaded Service Locations :
[main-rmi=rmi://localhost:1099/RMIDispatcher, main-http=
http://localhost:80/webtools/control/httpService,
entity-sync-rmi=rmi://localhost:1099/RMIDispatcher, entity-sync-http=
http://localhost:8080/webtools/control/httpService,
rita-rmi=rmi://localhost:1099/RMIDispatcher, eedcc-test=
http://localhost:8080/webtools/control/httpService]
2009-12-21 15:55:17,299 (default-invoker-Thread-8) [
ServiceDispatcher.java:586:INFO ] Sync service
[JobDispatcher/sendEmailDated] finished in [1032] milliseconds
2009-12-21 15:55:17,303 (default-invoker-Thread-10) [
ServiceDispatcher.java:586:INFO ] Sync service
[JobDispatcher/sendEmailDated] finished in [1027] milliseconds
2009-12-21 15:55:17,308 (default-invoker-Thread-9) [
ServiceDispatcher.java:586:INFO ] Sync service
[JobDispatcher/sendEmailDated] finished in [1038] milliseconds
2009-12-21 15:55:17,364 (default-invoker-Thread-11) [
Log.java:111:INFO ]
[CommonPermissionServices.xml#genericBasePermissionCheck] Checking for
primary permission ACCOUNTING_CREATE
2009-12-21 15:55:17,389 (default-invoker-Thread-11) [
ServiceEcaRule.java:134:INFO ] For Service ECA [fixedAssetPermissionCheck]
on [return] got false for condition:
[hasPermission][equals][false][true][Boolean]
2009-12-21 15:55:17,389 (default-invoker-Thread-11) [
ServiceDispatcher.java:586:INFO ] Sync service
[JobDispatcher/fixedAssetPermissionCheck] finished in [1060] milliseconds
2009-12-21 15:55:17,403 (default-invoker-Thread-7) [
ServiceDispatcher.java:586:INFO ] Sync service
[JobDispatcher/sendEmailDated] finished in [1133] milliseconds
2009-12-21 15:55:17,511 (default-invoker-Thread-11) [
ServiceDispatcher.java:586:INFO ] Sync service
[JobDispatcher/createMaintsFromTimeInterval] finished in [1241] milliseconds
2009-12-21 15:56:35,573 (org.ofbiz.service.job.JobPoller@223279) [
TransactionImpl.java:212:WARN ] Unable to enlist XAResource
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@19c741b,
errorCode: 0
javax.transaction.xa.XAException: Count not turn off auto commit for a XA
transaction
    at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134)
    at
org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208)
    at
org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89)
    at
org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131)
    at
org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
    at
org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
    at
org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
    at
org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
    at
org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
    at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
    at
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
    at
org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240)
    at
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
    at
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317)
    at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
    at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
    at
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
    at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
    at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
    at org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
    at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
    at java.lang.Thread.run(Thread.java:619)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
occurred during the DBComms.receive method. Operation:Connection reset.
Context:(5) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
IO:04fe1, Dbc:cfdd0]. PktNum:0. TotalReceived:0. PktSize:4,096.
    at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
    at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown
Source)
    at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132)
    ... 21 more
2009-12-21 15:56:35,604 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:138:ERROR]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,604 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,624 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,624 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:138:ERROR]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,626 (org.ofbiz.service.job.JobPoller@223279) [
GenericDelegator.java:1290:ERROR]
---- exception report
----------------------------------------------------------
Failure in storeByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
commit (Commit can not be set while enrolled in a transaction). Rolling back
transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception occurred on commit (Commit can not be set while
enrolled in a transaction)
---- cause
---------------------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,627 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:322:WARN ]
---- exception report
----------------------------------------------------------
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
stack trace shows where this is happening:
Exception: java.lang.Exception
Message: Failure in storeByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
commit (Commit can not be set while enrolled in a transaction). Rolling back
transaction.
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Failure in storeByCondition operation for entity
[JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception
occurred on commit (Commit can not be set while enrolled in a transaction).
Rolling back transaction.
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,628 (org.ofbiz.service.job.JobPoller@223279) [
JobManager.java:187:ERROR]
---- exception report
----------------------------------------------------------
Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException:
SQL Exception occurred on commit (Commit can not be set while enrolled in a
transaction)]. Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception occurred on commit (Commit can not be set while
enrolled in a transaction)
---- cause
---------------------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,630 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:286:ERROR]
---- exception report
----------------------------------------------------------
[TransactionUtil.rollback]
Exception: java.lang.Exception
Message: Stack Trace
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Stack Trace
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267)
org.ofbiz.service.job.JobManager.poll(JobManager.java:190)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,631 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction
rolled back
2009-12-21 15:56:35,631 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing
transaction, status is No Transaction (6)
2009-12-21 15:56:35,632 (org.ofbiz.service.job.JobPoller@223279) [
TransactionImpl.java:212:WARN ] Unable to enlist XAResource
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@1d69f44,
errorCode: 0
javax.transaction.xa.XAException: Count not turn off auto commit for a XA
transaction
    at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134)
    at
org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208)
    at
org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89)
    at
org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131)
    at
org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
    at
org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
    at
org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
    at
org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
    at
org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
    at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
    at
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
    at
org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240)
    at
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
    at
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317)
    at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
    at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
    at
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
    at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
    at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
    at org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
    at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
    at java.lang.Thread.run(Thread.java:619)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
occurred during the DBComms.receive method. Operation:Connection reset.
Context:(1) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
IO:80c2b, Dbc:29dc5]. PktNum:0. TotalReceived:0. PktSize:4,096.
    at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
    at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown
Source)
    at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132)
    ... 21 more
2009-12-21 15:56:35,654 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:138:ERROR]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:138:ERROR]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [
GenericDelegator.java:1290:ERROR]
---- exception report
----------------------------------------------------------
Failure in storeByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
commit (Commit can not be set while enrolled in a transaction). Rolling back
transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception occurred on commit (Commit can not be set while
enrolled in a transaction)
---- cause
---------------------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:322:WARN ]
---- exception report
----------------------------------------------------------
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
stack trace shows where this is happening:
Exception: java.lang.Exception
Message: Failure in storeByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
commit (Commit can not be set while enrolled in a transaction). Rolling back
transaction.
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Failure in storeByCondition operation for entity
[JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception
occurred on commit (Commit can not be set while enrolled in a transaction).
Rolling back transaction.
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [
JobManager.java:187:ERROR]
---- exception report
----------------------------------------------------------
Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException:
SQL Exception occurred on commit (Commit can not be set while enrolled in a
transaction)]. Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception occurred on commit (Commit can not be set while
enrolled in a transaction)
---- cause
---------------------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:286:ERROR]
---- exception report
----------------------------------------------------------
[TransactionUtil.rollback]
Exception: java.lang.Exception
Message: Stack Trace
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Stack Trace
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267)
org.ofbiz.service.job.JobManager.poll(JobManager.java:190)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction
rolled back
2009-12-21 15:56:35,658 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing
transaction, status is No Transaction (6)
2009-12-21 15:56:35,659 (org.ofbiz.service.job.JobPoller@223279) [
TransactionImpl.java:212:WARN ] Unable to enlist XAResource
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@532d42,
errorCode: 0
javax.transaction.xa.XAException: Count not turn off auto commit for a XA
transaction
    at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134)
    at
org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208)
    at
org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89)
    at
org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131)
    at
org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
    at
org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
    at
org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
    at
org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
    at
org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
    at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
    at
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
    at
org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240)
    at
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
    at
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317)
    at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
    at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
    at
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
    at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
    at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
    at org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
    at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
    at java.lang.Thread.run(Thread.java:619)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
occurred during the DBComms.receive method. Operation:Connection reset.
Context:(3) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
IO:e3a05, Dbc:4611a]. PktNum:0. TotalReceived:0. PktSize:4,096.
    at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
    at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown
Source)
    at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132)
    ... 21 more
2009-12-21 15:56:35,663 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:138:ERROR]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:138:ERROR]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [
GenericDelegator.java:1290:ERROR]
---- exception report
----------------------------------------------------------
Failure in storeByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
commit (Commit can not be set while enrolled in a transaction). Rolling back
transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception occurred on commit (Commit can not be set while
enrolled in a transaction)
---- cause
---------------------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,666 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:322:WARN ]
---- exception report
----------------------------------------------------------
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
stack trace shows where this is happening:
Exception: java.lang.Exception
Message: Failure in storeByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
commit (Commit can not be set while enrolled in a transaction). Rolling back
transaction.
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Failure in storeByCondition operation for entity
[JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception
occurred on commit (Commit can not be set while enrolled in a transaction).
Rolling back transaction.
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [
JobManager.java:187:ERROR]
---- exception report
----------------------------------------------------------
Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException:
SQL Exception occurred on commit (Commit can not be set while enrolled in a
transaction)]. Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception occurred on commit (Commit can not be set while
enrolled in a transaction)
---- cause
---------------------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:286:ERROR]
---- exception report
----------------------------------------------------------
[TransactionUtil.rollback]
Exception: java.lang.Exception
Message: Stack Trace
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Stack Trace
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267)
org.ofbiz.service.job.JobManager.poll(JobManager.java:190)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction
rolled back
2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing
transaction, status is No Transaction (6)
2009-12-21 15:56:35,687 (org.ofbiz.service.job.JobPoller@223279) [
TransactionImpl.java:212:WARN ] Unable to enlist XAResource
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@662c35,
errorCode: 0
javax.transaction.xa.XAException: Count not turn off auto commit for a XA
transaction
    at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134)
    at
org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208)
    at
org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89)
    at
org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131)
    at
org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
    at
org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
    at
org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
    at
org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
    at
org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
    at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
    at
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
    at
org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240)
    at
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
    at
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317)
    at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
    at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
    at
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
    at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
    at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
    at org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
    at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
    at java.lang.Thread.run(Thread.java:619)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
occurred during the DBComms.receive method. Operation:Connection reset.
Context:(4) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
IO:07975, Dbc:305e8]. PktNum:0. TotalReceived:0. PktSize:4,096.
    at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
    at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown
Source)
    at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132)
    ... 21 more
2009-12-21 15:56:35,692 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:138:ERROR]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,692 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:138:ERROR]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [
GenericDelegator.java:1290:ERROR]
---- exception report
----------------------------------------------------------
Failure in storeByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
commit (Commit can not be set while enrolled in a transaction). Rolling back
transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception occurred on commit (Commit can not be set while
enrolled in a transaction)
---- cause
---------------------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:322:WARN ]
---- exception report
----------------------------------------------------------
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
stack trace shows where this is happening:
Exception: java.lang.Exception
Message: Failure in storeByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
commit (Commit can not be set while enrolled in a transaction). Rolling back
transaction.
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Failure in storeByCondition operation for entity
[JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception
occurred on commit (Commit can not be set while enrolled in a transaction).
Rolling back transaction.
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [
JobManager.java:187:ERROR]
---- exception report
----------------------------------------------------------
Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException:
SQL Exception occurred on commit (Commit can not be set while enrolled in a
transaction)]. Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception occurred on commit (Commit can not be set while
enrolled in a transaction)
---- cause
---------------------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:286:ERROR]
---- exception report
----------------------------------------------------------
[TransactionUtil.rollback]
Exception: java.lang.Exception
Message: Stack Trace
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Stack Trace
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267)
org.ofbiz.service.job.JobManager.poll(JobManager.java:190)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction
rolled back
2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing
transaction, status is No Transaction (6)
2009-12-21 15:56:35,716 (org.ofbiz.service.job.JobPoller@223279) [
TransactionImpl.java:212:WARN ] Unable to enlist XAResource
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@390d8f,
errorCode: 0
javax.transaction.xa.XAException: Count not turn off auto commit for a XA
transaction
    at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134)
    at
org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208)
    at
org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89)
    at
org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131)
    at
org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
    at
org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
    at
org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
    at
org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
    at
org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
    at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
    at
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
    at
org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240)
    at
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
    at
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317)
    at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
    at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
    at
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
    at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
    at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
    at org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
    at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
    at java.lang.Thread.run(Thread.java:619)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
occurred during the DBComms.receive method. Operation:Connection reset.
Context:(2) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
IO:e05f4, Dbc:a98bf]. PktNum:0. TotalReceived:0. PktSize:4,096.
    at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
    at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown
Source)
    at
org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132)
    ... 21 more
2009-12-21 15:56:35,718 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:138:ERROR]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,718 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:138:ERROR]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
rolling back insert. Error was:java.sql.SQLException: Commit can not be set
while enrolled in a transaction
2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [
SQLProcessor.java:174:WARN ]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [
GenericDelegator.java:1290:ERROR]
---- exception report
----------------------------------------------------------
Failure in storeByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
commit (Commit can not be set while enrolled in a transaction). Rolling back
transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception occurred on commit (Commit can not be set while
enrolled in a transaction)
---- cause
---------------------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:322:WARN ]
---- exception report
----------------------------------------------------------
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
stack trace shows where this is happening:
Exception: java.lang.Exception
Message: Failure in storeByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
commit (Commit can not be set while enrolled in a transaction). Rolling back
transaction.
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Failure in storeByCondition operation for entity
[JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception
occurred on commit (Commit can not be set while enrolled in a transaction).
Rolling back transaction.
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [
JobManager.java:187:ERROR]
---- exception report
----------------------------------------------------------
Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException:
SQL Exception occurred on commit (Commit can not be set while enrolled in a
transaction)]. Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception occurred on commit (Commit can not be set while
enrolled in a transaction)
---- cause
---------------------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Commit can not be set while enrolled in a transaction
org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:286:ERROR]
---- exception report
----------------------------------------------------------
[TransactionUtil.rollback]
Exception: java.lang.Exception
Message: Stack Trace
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Stack Trace
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267)
org.ofbiz.service.job.JobManager.poll(JobManager.java:190)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction
rolled back
2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [
TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing
transaction, status is No Transaction (6)


--
Abhijeet Pandey
Reply | Threaded
Open this post in threaded view
|

Re: Error While accessing ofbiz

Chris Snow-3
Abhijeet,

What version MS JDBC driver are you using?  Did you follow the detailed
instructions with the driver for setting up XA Transactions?

What ofbiz version are you using?

Have you ever managed to get access to the system without an error?

Cheers,

Chris

Abhijeet Pandey wrote:

> Hi All,
>
> I am getting following error while accessing ofbiz. The deployment is fine
> and it is not giving any error while starting the server but while accessing
> it is giving following Error.
>
> Please help.
>
> Unable to enlist XAResource
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@19c741b,
> errorCode: 0
> javax.transaction.xa.XAException: Count not turn off auto commit for a XA
> transaction
>
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
> occurred during the DBComms.receive method. Operation:Connection reset.
> Context:(5) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
> IO:04fe1, Dbc:cfdd0]. PktNum:0. TotalReceived:0. PktSize:4,096.
>
> Below is the Detailed Log --------------------------->
>
> Httpd started on port: 9989
> Sessiond started on port: 9990
> 2009-12-21 15:55:03,023 (main) [ BeanShellContainer.java:100:INFO ] Started
> BeanShell telnet service on 9989, 9990
> 2009-12-21 15:55:03,023 (main) [ BeanShellContainer.java:101:INFO ] NOTICE:
> BeanShell service ports are not secure. Please protect the ports
> 2009-12-21 15:55:05,037 (org.ofbiz.service.jms.JmsListenerFactory@17eeb7e) [
> JmsListenerFactory.java:75 :INFO ] JMS Listener Factory Thread Finished; All
> listeners connected.
> 2009-12-21 15:55:15,055 (org.ofbiz.service.job.JobPoller@223279) [
> GenericDispatcher.java:61 :INFO ] Creating new dispatcher [JobDispatcher]
> (org.ofbiz.service.job.JobPoller@223279)
> 2009-12-21 15:55:15,747 (default-invoker-Thread-11) [
> JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-11] received job
> [Auto-create Fixed Asset Maintenances] from poller
> [org.ofbiz.service.job.JobPoller@223279]
> 2009-12-21 15:55:15,747 (default-invoker-Thread-9) [
> JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-9] received job
> [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279]
> 2009-12-21 15:55:15,749 (default-invoker-Thread-7) [
> JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-7] received job
> [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279]
> 2009-12-21 15:55:15,750 (default-invoker-Thread-10) [
> JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-10] received job
> [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279]
> 2009-12-21 15:55:15,750 (default-invoker-Thread-8) [
> JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-8] received job
> [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279]
> 2009-12-21 15:55:16,171 (default-invoker-Thread-9) [
> SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [JobSandbox];
> curSeqId=65900, maxSeqId=66000, bankSize=100
> 2009-12-21 15:55:16,219 (default-invoker-Thread-7)
> [PersistedServiceJob.java:178:INFO ]
> org.ofbiz.service.job.PersistedServiceJob@e1b74e[65803] -- Next runtime: Mon
> Dec 21 16:10:15 IST 2009
> 2009-12-21 15:55:16,219 (default-invoker-Thread-11)
> [PersistedServiceJob.java:178:INFO ]
> org.ofbiz.service.job.PersistedServiceJob@b65057[65825] -- Next runtime: Mon
> Dec 21 16:00:15 IST 2009
> 2009-12-21 15:55:16,220 (default-invoker-Thread-8)
> [PersistedServiceJob.java:178:INFO ]
> org.ofbiz.service.job.PersistedServiceJob@165520d[65801] -- Next runtime:
> Mon Dec 21 16:10:15 IST 2009
> 2009-12-21 15:55:16,220 (default-invoker-Thread-9)
> [PersistedServiceJob.java:178:INFO ]
> org.ofbiz.service.job.PersistedServiceJob@ee0989[65800] -- Next runtime: Mon
> Dec 21 16:10:15 IST 2009
> 2009-12-21 15:55:16,222 (default-invoker-Thread-10)
> [PersistedServiceJob.java:178:INFO ]
> org.ofbiz.service.job.PersistedServiceJob@f183bd[65804] -- Next runtime: Mon
> Dec 21 16:10:15 IST 2009
> 2009-12-21 15:55:16,305 (default-invoker-Thread-8) [
> AbstractEngine.java:73 :INFO ] Loaded Service Locations :
> [main-rmi=rmi://localhost:1099/RMIDispatcher, main-http=
> http://localhost:80/webtools/control/httpService,
> entity-sync-rmi=rmi://localhost:1099/RMIDispatcher, entity-sync-http=
> http://localhost:8080/webtools/control/httpService,
> rita-rmi=rmi://localhost:1099/RMIDispatcher, eedcc-test=
> http://localhost:8080/webtools/control/httpService]
> 2009-12-21 15:55:17,299 (default-invoker-Thread-8) [
> ServiceDispatcher.java:586:INFO ] Sync service
> [JobDispatcher/sendEmailDated] finished in [1032] milliseconds
> 2009-12-21 15:55:17,303 (default-invoker-Thread-10) [
> ServiceDispatcher.java:586:INFO ] Sync service
> [JobDispatcher/sendEmailDated] finished in [1027] milliseconds
> 2009-12-21 15:55:17,308 (default-invoker-Thread-9) [
> ServiceDispatcher.java:586:INFO ] Sync service
> [JobDispatcher/sendEmailDated] finished in [1038] milliseconds
> 2009-12-21 15:55:17,364 (default-invoker-Thread-11) [
> Log.java:111:INFO ]
> [CommonPermissionServices.xml#genericBasePermissionCheck] Checking for
> primary permission ACCOUNTING_CREATE
> 2009-12-21 15:55:17,389 (default-invoker-Thread-11) [
> ServiceEcaRule.java:134:INFO ] For Service ECA [fixedAssetPermissionCheck]
> on [return] got false for condition:
> [hasPermission][equals][false][true][Boolean]
> 2009-12-21 15:55:17,389 (default-invoker-Thread-11) [
> ServiceDispatcher.java:586:INFO ] Sync service
> [JobDispatcher/fixedAssetPermissionCheck] finished in [1060] milliseconds
> 2009-12-21 15:55:17,403 (default-invoker-Thread-7) [
> ServiceDispatcher.java:586:INFO ] Sync service
> [JobDispatcher/sendEmailDated] finished in [1133] milliseconds
> 2009-12-21 15:55:17,511 (default-invoker-Thread-11) [
> ServiceDispatcher.java:586:INFO ] Sync service
> [JobDispatcher/createMaintsFromTimeInterval] finished in [1241] milliseconds
> 2009-12-21 15:56:35,573 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionImpl.java:212:WARN ] Unable to enlist XAResource
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@19c741b,
> errorCode: 0
> javax.transaction.xa.XAException: Count not turn off auto commit for a XA
> transaction
>     at
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134)
>     at
> org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208)
>     at
> org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89)
>     at
> org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131)
>     at
> org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
>     at
> org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
>     at
> org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
>     at
> org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
>     at
> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
>     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
>     at
> org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317)
>     at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
>     at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
>     at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>     at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
>     at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
>     at org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
>     at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
>     at java.lang.Thread.run(Thread.java:619)
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
> occurred during the DBComms.receive method. Operation:Connection reset.
> Context:(5) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
> IO:04fe1, Dbc:cfdd0]. PktNum:0. TotalReceived:0. PktSize:4,096.
>     at
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
> Source)
>     at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
>     at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown
> Source)
>     at
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132)
>     ... 21 more
> 2009-12-21 15:56:35,604 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:138:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,604 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,624 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,624 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:138:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,626 (org.ofbiz.service.job.JobPoller@223279) [
> GenericDelegator.java:1290:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Failure in storeByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
> commit (Commit can not be set while enrolled in a transaction). Rolling back
> transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,627 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:322:WARN ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> Exception: java.lang.Exception
> Message: Failure in storeByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
> commit (Commit can not be set while enrolled in a transaction). Rolling back
> transaction.
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Failure in storeByCondition operation for entity
> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception
> occurred on commit (Commit can not be set while enrolled in a transaction).
> Rolling back transaction.
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,628 (org.ofbiz.service.job.JobPoller@223279) [
> JobManager.java:187:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException:
> SQL Exception occurred on commit (Commit can not be set while enrolled in a
> transaction)]. Rolling back transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,630 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:286:ERROR]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.rollback]
> Exception: java.lang.Exception
> Message: Stack Trace
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Stack Trace
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:190)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,631 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction
> rolled back
> 2009-12-21 15:56:35,631 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing
> transaction, status is No Transaction (6)
> 2009-12-21 15:56:35,632 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionImpl.java:212:WARN ] Unable to enlist XAResource
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@1d69f44,
> errorCode: 0
> javax.transaction.xa.XAException: Count not turn off auto commit for a XA
> transaction
>     at
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134)
>     at
> org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208)
>     at
> org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89)
>     at
> org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131)
>     at
> org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
>     at
> org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
>     at
> org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
>     at
> org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
>     at
> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
>     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
>     at
> org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317)
>     at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
>     at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
>     at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>     at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
>     at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
>     at org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
>     at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
>     at java.lang.Thread.run(Thread.java:619)
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
> occurred during the DBComms.receive method. Operation:Connection reset.
> Context:(1) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
> IO:80c2b, Dbc:29dc5]. PktNum:0. TotalReceived:0. PktSize:4,096.
>     at
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
> Source)
>     at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
>     at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown
> Source)
>     at
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132)
>     ... 21 more
> 2009-12-21 15:56:35,654 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:138:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:138:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [
> GenericDelegator.java:1290:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Failure in storeByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
> commit (Commit can not be set while enrolled in a transaction). Rolling back
> transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:322:WARN ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> Exception: java.lang.Exception
> Message: Failure in storeByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
> commit (Commit can not be set while enrolled in a transaction). Rolling back
> transaction.
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Failure in storeByCondition operation for entity
> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception
> occurred on commit (Commit can not be set while enrolled in a transaction).
> Rolling back transaction.
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [
> JobManager.java:187:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException:
> SQL Exception occurred on commit (Commit can not be set while enrolled in a
> transaction)]. Rolling back transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:286:ERROR]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.rollback]
> Exception: java.lang.Exception
> Message: Stack Trace
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Stack Trace
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:190)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction
> rolled back
> 2009-12-21 15:56:35,658 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing
> transaction, status is No Transaction (6)
> 2009-12-21 15:56:35,659 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionImpl.java:212:WARN ] Unable to enlist XAResource
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@532d42,
> errorCode: 0
> javax.transaction.xa.XAException: Count not turn off auto commit for a XA
> transaction
>     at
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134)
>     at
> org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208)
>     at
> org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89)
>     at
> org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131)
>     at
> org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
>     at
> org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
>     at
> org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
>     at
> org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
>     at
> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
>     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
>     at
> org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317)
>     at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
>     at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
>     at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>     at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
>     at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
>     at org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
>     at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
>     at java.lang.Thread.run(Thread.java:619)
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
> occurred during the DBComms.receive method. Operation:Connection reset.
> Context:(3) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
> IO:e3a05, Dbc:4611a]. PktNum:0. TotalReceived:0. PktSize:4,096.
>     at
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
> Source)
>     at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
>     at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown
> Source)
>     at
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132)
>     ... 21 more
> 2009-12-21 15:56:35,663 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:138:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:138:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [
> GenericDelegator.java:1290:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Failure in storeByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
> commit (Commit can not be set while enrolled in a transaction). Rolling back
> transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,666 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:322:WARN ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> Exception: java.lang.Exception
> Message: Failure in storeByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
> commit (Commit can not be set while enrolled in a transaction). Rolling back
> transaction.
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Failure in storeByCondition operation for entity
> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception
> occurred on commit (Commit can not be set while enrolled in a transaction).
> Rolling back transaction.
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [
> JobManager.java:187:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException:
> SQL Exception occurred on commit (Commit can not be set while enrolled in a
> transaction)]. Rolling back transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:286:ERROR]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.rollback]
> Exception: java.lang.Exception
> Message: Stack Trace
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Stack Trace
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:190)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction
> rolled back
> 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing
> transaction, status is No Transaction (6)
> 2009-12-21 15:56:35,687 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionImpl.java:212:WARN ] Unable to enlist XAResource
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@662c35,
> errorCode: 0
> javax.transaction.xa.XAException: Count not turn off auto commit for a XA
> transaction
>     at
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134)
>     at
> org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208)
>     at
> org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89)
>     at
> org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131)
>     at
> org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
>     at
> org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
>     at
> org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
>     at
> org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
>     at
> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
>     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
>     at
> org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317)
>     at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
>     at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
>     at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>     at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
>     at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
>     at org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
>     at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
>     at java.lang.Thread.run(Thread.java:619)
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
> occurred during the DBComms.receive method. Operation:Connection reset.
> Context:(4) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
> IO:07975, Dbc:305e8]. PktNum:0. TotalReceived:0. PktSize:4,096.
>     at
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
> Source)
>     at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
>     at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown
> Source)
>     at
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132)
>     ... 21 more
> 2009-12-21 15:56:35,692 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:138:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,692 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:138:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [
> GenericDelegator.java:1290:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Failure in storeByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
> commit (Commit can not be set while enrolled in a transaction). Rolling back
> transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:322:WARN ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> Exception: java.lang.Exception
> Message: Failure in storeByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
> commit (Commit can not be set while enrolled in a transaction). Rolling back
> transaction.
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Failure in storeByCondition operation for entity
> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception
> occurred on commit (Commit can not be set while enrolled in a transaction).
> Rolling back transaction.
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [
> JobManager.java:187:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException:
> SQL Exception occurred on commit (Commit can not be set while enrolled in a
> transaction)]. Rolling back transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:286:ERROR]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.rollback]
> Exception: java.lang.Exception
> Message: Stack Trace
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Stack Trace
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:190)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction
> rolled back
> 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing
> transaction, status is No Transaction (6)
> 2009-12-21 15:56:35,716 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionImpl.java:212:WARN ] Unable to enlist XAResource
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@390d8f,
> errorCode: 0
> javax.transaction.xa.XAException: Count not turn off auto commit for a XA
> transaction
>     at
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134)
>     at
> org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208)
>     at
> org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89)
>     at
> org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131)
>     at
> org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
>     at
> org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
>     at
> org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
>     at
> org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
>     at
> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
>     at
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
>     at
> org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346)
>     at
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317)
>     at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
>     at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
>     at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>     at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
>     at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
>     at org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
>     at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
>     at java.lang.Thread.run(Thread.java:619)
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
> occurred during the DBComms.receive method. Operation:Connection reset.
> Context:(2) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main],
> IO:e05f4, Dbc:a98bf]. PktNum:0. TotalReceived:0. PktSize:4,096.
>     at
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
> Source)
>     at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
>     at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown
> Source)
>     at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown
> Source)
>     at
> org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132)
>     ... 21 more
> 2009-12-21 15:56:35,718 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:138:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,718 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:138:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while
> rolling back insert. Error was:java.sql.SQLException: Commit can not be set
> while enrolled in a transaction
> 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [
> SQLProcessor.java:174:WARN ]
> ---- exception report
> ----------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217)
> org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [
> GenericDelegator.java:1290:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Failure in storeByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
> commit (Commit can not be set while enrolled in a transaction). Rolling back
> transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:322:WARN ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> Exception: java.lang.Exception
> Message: Failure in storeByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on
> commit (Commit can not be set while enrolled in a transaction). Rolling back
> transaction.
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Failure in storeByCondition operation for entity
> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception
> occurred on commit (Commit can not be set while enrolled in a transaction).
> Rolling back transaction.
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [
> JobManager.java:187:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException:
> SQL Exception occurred on commit (Commit can not be set while enrolled in a
> transaction)]. Rolling back transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Commit can not be set while enrolled in a transaction
> org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210)
> org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135)
> org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:286:ERROR]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.rollback]
> Exception: java.lang.Exception
> Message: Stack Trace
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Stack Trace
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:190)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction
> rolled back
> 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [
> TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing
> transaction, status is No Transaction (6)
>
>
>  


--
Chris Snow - CEng MBCS CITP MBA (Tech Mgmt) (Open) CISSP

Tel: 01453 890660
Mob: 07944 880950
Www: www.snowconsulting.co.uk