开发者

PostgreSQL doesn't close connections

We are using Liferay Portal 5.2.3 (with Hibernate and C3P0) on Tomcat 5.5.27, PostgreSQL 8.3. Normally, c3p0 pools connections and return it for reusing. But sometimes we need a lot of updates in time and postgreSQL doesn't release connection after closing (we can see 100 IDLE connections). Also, that problem reproduces only on Linux (Debian 5.0). Connections are establing by independent threads开发者_如何学C, and in the finally block of run() method we're always close it. I've tried do not use pool and wrote simple DBConnection manager (getConnection() -> runQuery() -> closeConnection()), but PostgreSQL didn't release it.


huh... It was problem in code (one bad guy didn't close connections)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜