Si,
I've seen this before.
Maybe the comments attached to this issue will help you:
http://issues.apache.org/jira/browse/OFBIZ-37
Jacopo
Si Chen wrote:
Hi everybody -
I'm also getting problems importing data in web tools even when the data
set is not too large. I am using PostgreSQL 8.0 and trying to import
about 13000 records using entity engine xml in webtools, and I get this:
2006-08-18 11:22:28,193 (http-0.0.0.0-8443-Processor8) [
EntitySaxReader.java:242:INFO ] Transaction Timeout set to 2 hours (7200
seconds)
2006-08-18 11:22:39,437 (http-0.0.0.0-8443-Processor8) [
EntitySaxReader.java:403:INFO ] Another 1000 values imported: now up to
1000
2006-08-18 11:22:49,361 (http-0.0.0.0-8443-Processor8) [
EntitySaxReader.java:403:INFO ] Another 1000 values imported: now up to
2000
2006-08-18 11:22:59,914 (http-0.0.0.0-8443-Processor8) [
EntitySaxReader.java:403:INFO ] Another 1000 values imported: now up to
3000
2006-08-18 11:23:15,004 (http-0.0.0.0-8443-Processor8) [
EntitySaxReader.java:403:INFO ] Another 1000 values imported: now up to
4000
2006-08-18 11:23:27,941 (JotmBatch) [ TransactionImpl.java:765:INFO ]
set rollback only (tx=bb14:38:0:017630033c06f82b4a...3d0497:)
2006-08-18 11:23:27,942 (JotmBatch) [ TransactionImpl.java:765:INFO ]
set rollback only (tx=bb14:38:0:017630033c06f82b4a...3d3098:)
2006-08-18 11:23:27,951 (http-0.0.0.0-8443-Processor8) [
SQLProcessor.java:155:ERROR]
---- exception report
----------------------------------------------------------
Exception: java.sql.SQLException
Message: Cannot commit a transactional connection: See JDBC 2.0 Optional
Package Specification section 7.1 (p25)
---- stack trace
---------------------------------------------------------------
java.sql.SQLException: Cannot commit a transactional connection: See
JDBC 2.0 Optional Package Specification section 7.1 (p25)
org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.commit(XAClientConnection.java:250)
org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:152)
org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:203)
org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:568)
org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:520)
org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:90)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1099)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:266)
It seems to be a 1 minute transactino roll back, even though the timeout
is set to 2 hours above.
Interestingly enough, $ ant run-install will install this file correctly.
Si
