[jboss-user] [Installation, Configuration & Deployment] - Postgres SQL 8.1.4, JBoss 4.0.3SP1 - No ManagedConnections I

Configuration: Postgres SQL 8.1.4 JBoss 4.0.3SP1 postgresql-8.1-405.jdbc3.jar pg-ds.xml: <local-tx-datasource> ... <min-pool-size>10</min-pool-size> <max-pool-size>100</max-pool-size> <idle-timeout-minutes>0</idle-timeout-minutes> </local-tx-datasource> We have the db set to 512 max_connections We continue to see the No ManagedConnections being thrown every couple of days. blocking-timeout-millis = 30000 Our code is closing all Connection objects in our finally {} blocks. 1) Are there other parameters we need to set in order to guard against this error? 2) Do others recommend we increase the <idle-timeout-minutes> value? 3) Is it necessary to close all ResultSet and PreparedStatement statements as well in our finally {} blocks of code? Any help or other insight into this is greatly appreciated. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3983991#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...