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
