[ 
http://mifosforge.jira.com/browse/MIFOS-4370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=68991#comment-68991
 ] 

Michael Vorburger commented on MIFOS-4370:
------------------------------------------

MIFOS-5098 has something similar...

> 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 10, Release 2.1
>
>         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.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Storage Efficiency Calculator
This modeling tool is based on patent-pending intellectual property that
has been used successfully in hundreds of IBM storage optimization engage-
ments, worldwide.  Store less, Store more with what you own, Move data to 
the right place. Try It Now! http://www.accelacomm.com/jaw/sfnl/114/51427378/
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to