[OFBiz] Users - Transaction timeout

Posted by Christopher Farley on Nov 13, 2005; 7:54am
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Transaction-timeout-tp136461.html

I've been having problems with transactions timing out. I first noticed
this when trying to import large XML files. I am now trying to create a
screen widget that calls a script that can take a while to execute. I am
getting what I believe to be transaction timeout errors.

The not-too-helpful error message returned to the UI is: [problem creating the newEntity value: SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25))]

This happens after about 65-70 seconds consistently. If I break the task
down to smaller data sets that execute faster than this, everything works
as expected, so I'm pretty sure I am not feeding corrupt data.

To set the TRANSACTION_TIMEOUT in a screen, I have been doing something
like this:

<screen name="Whatever">
    <actions>
        <set field="parameters.TRANSACTION_TIMEOUT" value="7200"/>
    </actions>

    ....

</screen>


This seems to have no effect. I added a debug statement to the
TransactionUtil class, and the begin() method is always being called
with a value of "0".

Is this the proper way to change the transaction timeout? Is there something
else that might be timing out? Thanks for any help you can give...

--
Christopher Farley
www.northernbrewer.com
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users