Re: Tomcat JDBC with PostgreSQL

[Lutischán Ferenc]

Thanks Dan,
I would like to test it more, but I think it works.

2013.05.08. 15:01 keltezéssel, Daniel Mikusa írta:

On May 8, 2013, at 8:54 AM, Lutischán Ferenc wrote:

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

Try setting testOnBorrow to "true".  With the Tomcat JDBC connection pool the 
testOn* properties default to false, which is different than the defaults for DBCP.

Dan

How to fix it?

Regards,
         Ferenc

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

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

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