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.
Did you close your connections ?
Particularly if you are doing
DataSource.getConnection
do something
without doing a connection.close()