3 Replies Latest reply on Nov 9, 2006 12:47 AM by jaikiran pai

    Postgres SQL 8.1.4, JBoss 4.0.3SP1 - No ManagedConnections I

    Tim Armandpour Newbie

      Postgres SQL 8.1.4
      JBoss 4.0.3SP1



      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.