I bet I know what the problem is - the services in webtools
<service name="entityImport" engine="java"
location="org.ofbiz.webtools.WebToolsServices"
invoke="entityImport" auth="true">
do not set their own transaction timeout, so they probably default to
60 seconds. The timeout of 2 hours is set inside EntitySaxReader. I
bet in some databases like PostgreSQL that I'm using, it's not going
to use the EntitySaxReader's timeout if the outer timeout in the
service is not set.
So--should we set a timeout in the services xml or just set them not
to use transaction, since the EntitySaxReader is already wrapping
them in a transaction?
Si
On Aug 18, 2006, at 4:16 PM, Si Chen wrote:
I'm actually running a pre-geronimo version (opentaps 0.9.1) so it
couldn't be due to ofbiz-37. Strange...maybe I'll have a closer
look when I have some time.
Si
On Aug 18, 2006, at 12:35 PM, Jacopo Cappellato wrote:
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
