Could you have line 403 of EntitySaxReader.java
include what the timeout is set to when it finishes
the 1000 records and run it again?
ie
Debug.logImportant("Another " + valuesPerMessage + "
values imported: now up to " + numberRead, module);
to
Debug.logImportant("Another " + valuesPerMessage + "
values imported: now up to " + numberRead +
"transaction timeout set to: " + transactionTimeout,
module);
--- Si Chen <[EMAIL PROTECTED]> 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
>
