tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Hartner <a...@j2anywhere.com>
Subject Active DataSource Connection count never decreasing with PostgreSQL
Date Tue, 02 Feb 2010 19:44:47 GMT
I have developed an application which accesses a database via Hibernate as well as directly
via JDBC (datasource). The datasource is defined in the server.xml file as follows:

    <Context path="" docBase="AddressBookServer.war"> 

          <Environment name="LicenseFile" value="Licensekey.license" type="java.lang.String"
override="true"/>         
          <Environment name="BackupsFolder" value="../backups" type="java.lang.String"
override="true"/>       
 
          <Resource name="jdbc/AddressBookDB" auth="Container" type="javax.sql.DataSource"
             maxActive="25" maxIdle="5" maxWait="-1" removeAbandoned="true" removeAbandonedTimeout="60"
logAbandoned="true"
             username="sa" password="" driverClassName="org.h2.Driver"
             url="jdbc:h2:tcp://localhost:28081/../db/AddressBookDB;LOCK_TIMEOUT=60000"/>

          <Realm className="org.apache.catalina.realm.JDBCRealm"
            driverName="org.h2.Driver"
            connectionURL="jdbc:h2:tcp://localhost:28081/../db/AddressBookDB;LOCK_TIMEOUT=60000"
            connectionName="sa" connectionPassword=""
            userTable="WEBUSERS" userNameCol="USERID" userCredCol="PASSWORD"
            userRoleTable="WEBROLES" roleNameCol="ACCESSROLE"/>

        </Context>

By default I use an embedded H2 database and everything works great. The numActive count goes
up during activity and decreases to 0 when there is no activity. Also the count generally
matches the actual connections to the database as one would expect. If I use the same application
with PostgreSQL 8.4 however, the numActive count goes up and up, and only sometimes down.
Generally sitting around 25 even though PostgreSQL only reports 4 idle connection. 

I already tried adding the following to my datasource configuration, however this did not
make any difference so far.
removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"

I am using Tomcat 6.0.18 on OS X 10.6.2 with Java 1.6.

Any suggestion on how I can debug this further why Tomcat reports an incorrect numActive count
and eventually runs out of possible connections. Currently it has to be restarted several
times a day with PostgreSQL.

Thanks in advance
Alex


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message