Batch Job thread holds connection (HibernateSession) even after completion,
resulting in timeout of connection
--------------------------------------------------------------------------------------------------------------
Key: MIFOS-4370
URL: http://mifosforge.jira.com/browse/MIFOS-4370
Project: mifos
Issue Type: Bug
Components: Batch jobs
Reporter: Udai Gupta
Assignee: mifosdeveloperqueue
The batch jobs fails due to connection timeout as it holds the connection in
batch job thread,
Solution:
Make sure the session is committed(closed or null) in HibernateUtil
(ThreadLocal) after the work
OR
There should be handing connection timeout in dataSourcce using autoReconnect
(and validation query).
Validate query is used for validating the connection which always fail if the
connection has timeout.
Read autoReconnect here
http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
