tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lutischán Ferenc <lutisch...@gmail.com>
Subject Tomcat JDBC with PostgreSQL
Date Wed, 08 May 2013 12:54:50 GMT
Dear Users,

Tomcat 7.0.39.

I have the following configuration in META-INF/context.xml:
<?xml version="1.0" encoding="UTF-8"?>
<Context cookies="false" path="/xxxx" reloadable="true">
     <Resource name="jdbc/template" auth="Container" 
driverClassName="org.postgresql.Driver" 
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="2" 
maxIdle="20" maxActive="20" maxWait="5000" password="xxxx" 
type="javax.sql.DataSource" url="jdbc:postgresql://x.x.x.x/x" 
username="template" validationQuery="select 1" 
jdbcInterceptors="ConnectionState;SlowQueryReportJmx(threshold=1000)"/>
</Context>

The situation:
- The database side the connection closed
- The tomcat pool don't renew the connection

How to fix it?

Regards,
          Ferenc

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


Mime
View raw message