[
http://mifosforge.jira.com/browse/MIFOS-4370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Udai Gupta updated MIFOS-4370:
------------------------------
Attachment: dbcp.patch
I have even tried dbcp (replacing c3p0) for this issue, the problem still
stand, hence it's not specific to c3p0.
Patch attached
> 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: Udai Gupta
> Fix For: Elsie F - Iteration 9, Elsie F
>
> Attachments: dbcp.patch
>
>
> 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
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
