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
