Hi all, I've spent some time looking into issues 1533, 1514 & 1515 which are all the same issue really: database connection leaks and lack of connection management. I've added some comments (see below) to the issue tracker for 1533.
Given the problems I've encountered, it seems that the introduction of a connection pool solution cannot be implemented without also upgrading hibernate to the latest version. There has already been some investigation done into the hibernate upgrade, and it seems a big enough task. So I suppose the question is whether the hibernate upgrade and connection pooling should be postponed until after the 1.1 release? Or is anybody actively pursuing this already? - Steve ---------- Forwarded message ---------- From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: 21 Feb 2008 10:23:41 -0000 Subject: [Issue 1533] Lack of jdbc connection management (finally blocks, connection pooling) To: [EMAIL PROTECTED] https://mifos.dev.java.net/issues/show_bug.cgi?id=1533 ------- Additional comments from [EMAIL PROTECTED] Thu Feb 21 10:23:34 +0000 2008 ------- Some further findings regarding hibernate session management within mifos: Van pointed out ( http://article.gmane.org/gmane.comp.finance.mifos.devel/3821 ) that session.close() is called at the end of each request. Of course, in the event of an error, this may not get called and could lead to connection leaks. Connection pooling would allow idle connections to be returned to the pool after a specified timeout. Connection pooling is not yet implemented, and the introduction of pooling would most likely help the connection problems that GK are having. I have attempted to introduce connection pooling using c3p0 and proxool and neither work with the current implementation of mifos. They cause hibernate errors in the unit tests as described above by Sam. These unit test errors could be caused by bugs in the beta version of hibernate that mifos uses, or could point to inappropriate use of hibernate in mifos itself.
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
