1 Reply Latest reply on Aug 14, 2003 3:21 PM by Roger Tan

    Growing number of DB connections, overtime

    akwt2 Newbie

      I'm using JBoss 3.2.1 + PostgreSQL 7.3.

      Since upgrading from JBoss 3.0.0 to 3.2.1, although I see a marked increase in stability, I also see that overtime, the number of DB connections that JBoss makes to postgres DB seems to grow ...

      Here's a snapshot of the curent opened connections for an application that I'm running on JBoss .. at the time of writing, the date is Aug 13, and my JBoss App Server has been running since Aug 04 (as shown) ...

      root 15993 15977 1 Aug04 pts/13 02:21:32 /usr/java/j2sdk/bin/java -server -Dprogram.name=run.sh -classpath /usr/java/jboss/bin/run.jar:/usr/java/j2sdk/lib/tools.jar org.jboss.Main
      alex 10715 4068 0 Aug11 pts/15 00:00:00 psql jboss
      postgres 10716 3384 0 Aug11 ? 00:00:00 postgres: alex jboss [local] idle
      postgres 20411 3384 0 23:10 ? 00:00:00 postgres: jboss jboss 127.0.0.1 idle
      postgres 20412 3384 0 23:10 ? 00:00:00 postgres: jboss jboss 127.0.0.1 idle
      postgres 20413 3384 0 23:10 ? 00:00:00 postgres: jboss jboss 127.0.0.1 idle
      postgres 20414 3384 0 23:10 ? 00:00:00 postgres: jboss jboss 127.0.0.1 idle
      postgres 20415 3384 0 23:10 ? 00:00:00 postgres: jboss jboss 127.0.0.1 idle
      postgres 20416 3384 0 23:10 ? 00:00:00 postgres: jboss jboss 127.0.0.1 idle
      postgres 20417 3384 0 23:10 ? 00:00:00 postgres: jboss jboss 127.0.0.1 idle
      alex 20444 20442 50 23:27 pts/6 00:00:07 /usr/java/j2sdk/bin/java -classpath /usr/java/jakarta-ant/lib/xml-apis.jar:/usr/java/jakarta-ant/lib/xercesImpl.jar:/usr/java/jakarta-ant/lib/optional.jar:/usr/java/jakarta-ant/lib/ant.jar::/usr/java/j2sdkee/lib/j2ee.jar:/usr/java/j2sdkee/lib/locale/:/usr/java/jboss/serve
      alex 20456 19069 0 23:27 pts/12 00:00:00 grep jboss

      Is there a problem in the way I have coded my application ? or have I left out any setup procedures?

      Please advise.

      regards,
      Alex Tan
      Senior Software Engineer,
      VLEE Enterprise.