Users - Import Data from Service : transaction timeout

[Zaoui Bruno]

Hello,

 

I’m trying to import a lot of data (9Mo) in my database from a service scheduled using the EntitySaxReader class and an entity xml data file.

After about one minute, I have the famous message: Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25).

 

Could you please tell me how to extend delay of transaction?

 

reader.setTransactionTimeout(12000); doesn’t work.

 

Thanks

 

 

     [java] 242414 (invoker-Thread-9) [  ServiceDispatcher.java:447:DEBUG] [[Sync service finished- total:0.843,since last(Begin):0.843]] - 'entity-default / indexProductKeywords'

     [java] 242430 (invoker-Thread-9) [      EntityEcaRule.java:122:INFO ] Running Entity ECA Service: indexProductKeywords, triggered by rule on Entity: ProductAttribute

     [java] 242883 (invoker-Thread-9) [  ServiceDispatcher.java:447:DEBUG] [[Sync service finished- total:0.453,since last(Begin):0.453]] - 'entity-default / indexProductKeywords'

     [java] 242883 (invoker-Thread-9) [      EntityEcaRule.java:122:INFO ] Running Entity ECA Service: indexProductKeywords, triggered by rule on Entity: ProductAttribute

     [java] 243742 (invoker-Thread-9) [  ServiceDispatcher.java:447:DEBUG] [[Sync service finished- total:0.859,since last(Begin):0.859]] - 'entity-default / indexProductKeywords'

     [java] 243742 (invoker-Thread-9) [      EntityEcaRule.java:122:INFO ] Running Entity ECA Service: indexProductKeywords, triggered by rule on Entity: ProductAttribute

     [java] 244211 (invoker-Thread-9) [            UtilXml.java:242:DEBUG] XML Read 0.453s: file:/D:/DEV/sequoiaerp/applications/product/script/org/ofbiz/product/product/ProductServices.xml

     [java] 245101 (invoker-Thread-9) [  ServiceDispatcher.java:447:DEBUG] [[Sync service finished- total:1.359,since last(Begin):1.359]] - 'entity-default / indexProductKeywords'

     [java] 245101 (invoker-Thread-9) [      EntityEcaRule.java:122:INFO ] Running Entity ECA Service: indexProductKeywords, triggered by rule on Entity: ProductFeatureAppl

     [java] 245976 (invoker-Thread-9) [  ServiceDispatcher.java:447:DEBUG] [[Sync service finished- total:0.875,since last(Begin):0.875]] - 'entity-default / indexProductKeywords'

     [java] 245976 (invoker-Thread-9) [      EntityEcaRule.java:122:INFO ] Running Entity ECA Service: indexProductKeywords, triggered by rule on Entity: ProductFeatureAppl

     [java] 246570 (invoker-Thread-9) [  ServiceDispatcher.java:447:DEBUG] [[Sync service finished- total:0.594,since last(Begin):0.594]] - 'entity-default / indexProductKeywords'

     [java] 246570 (invoker-Thread-9) [      EntityEcaRule.java:122:INFO ] Running Entity ECA Service: indexProductKeywords, triggered by rule on Entity: ProductFeatureAppl

     [java] 247429 (invoker-Thread-9) [  ServiceDispatcher.java:447:DEBUG] [[Sync service finished- total:0.859,since last(Begin):0.859]] - 'entity-default / indexProductKeywords'

     [java] 247445 (JotmBatch) [    TransactionImpl.java:765:INFO ] set rollback only (tx=bb14:38:0:01ff0250fd435c09bb...197456:)

     [java] 247867 (invoker-Thread-9) [       SQLProcessor.java:154:ERROR]

     [java] ---- exception report ----------------------------------------------------------

     [java] Exception: java.sql.SQLException

     [java] Message: Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25)

     [java] ---- stack trace ---------------------------------------------------------------

     [java] java.sql.SQLException: Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25)

     [java] org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.commit(XAClientConnection.java:250)

 

 

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users