Re: validationQuery doesn't work (DBCP 7.0.59)

2015-06-23 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Jose, On 6/23/15 6:46 AM, Jose María Zaragoza wrote: > 2015-06-15 17:59 GMT+02:00 Christopher Schultz > : Jose, > > It looks like your issue is mostly solved... > > On 6/15/15 4:42 AM, Jose María Zaragoza wrote: I'm using Tomcat 7.0.59 and Po

Re: validationQuery doesn't work (DBCP 7.0.59)

2015-06-23 Thread Jose María Zaragoza
2015-06-15 17:59 GMT+02:00 Christopher Schultz : > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Jose, > > It looks like your issue is mostly solved... > > On 6/15/15 4:42 AM, Jose María Zaragoza wrote: >> I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 >> >> The context.x

Re: validationQuery doesn't work (DBCP 7.0.59)

2015-06-15 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Jose, It looks like your issue is mostly solved... On 6/15/15 4:42 AM, Jose María Zaragoza wrote: > I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 > > The context.xml settings are > > > timeBetweenEvictionRunsMillis="0"/> Ar

Re: validationQuery doesn't work (DBCP 7.0.59)

2015-06-15 Thread Jose María Zaragoza
2015-06-15 16:35 GMT+02:00 Daniel Mikusa : > On Mon, Jun 15, 2015 at 4:42 AM, Jose María Zaragoza > wrote: > >> Hello: >> >> >> I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 >> >> The context.xml settings are >> >> >> > factory="org.apache.tomcat.jdbc.pool.Dat

Re: validationQuery doesn't work (DBCP 7.0.59)

2015-06-15 Thread Mark Thomas
On 15/06/2015 15:35, Daniel Mikusa wrote: > On Mon, Jun 15, 2015 at 4:42 AM, Jose María Zaragoza > wrote: > >> Hello: >> >> >> I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 >> >> The context.xml settings are >> >> >> > factory="org.apache.tomcat.jdbc.pool.Dat

Re: validationQuery doesn't work (DBCP 7.0.59)

2015-06-15 Thread Daniel Mikusa
On Mon, Jun 15, 2015 at 4:42 AM, Jose María Zaragoza wrote: > Hello: > > > I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 > > The context.xml settings are > > >factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" driverClassName="org.po

Re: validationQuery doesn't work (DBCP 7.0.59)

2015-06-15 Thread Jose María Zaragoza
2015-06-15 13:09 GMT+02:00 Mark Thomas : > On 15/06/2015 11:39, Jose María Zaragoza wrote: >> 2015-06-15 11:39 GMT+02:00 Mark Thomas : >>> On 15/06/2015 09:42, Jose María Zaragoza wrote: Hello: I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 The conte

Re: validationQuery doesn't work (DBCP 7.0.59)

2015-06-15 Thread Mark Thomas
On 15/06/2015 11:39, Jose María Zaragoza wrote: > 2015-06-15 11:39 GMT+02:00 Mark Thomas : >> On 15/06/2015 09:42, Jose María Zaragoza wrote: >>> Hello: >>> >>> >>> I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 >>> >>> The context.xml settings are >>> >>> >>> >>

Re: validationQuery doesn't work (DBCP 7.0.59)

2015-06-15 Thread Jose María Zaragoza
2015-06-15 11:39 GMT+02:00 Mark Thomas : > On 15/06/2015 09:42, Jose María Zaragoza wrote: >> Hello: >> >> >> I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 >> >> The context.xml settings are >> >> >> > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" >>

Re: validationQuery doesn't work (DBCP 7.0.59)

2015-06-15 Thread Mark Thomas
On 15/06/2015 09:42, Jose María Zaragoza wrote: > Hello: > > > I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 > > The context.xml settings are > > >factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > driverClassName="org.postgresql

Re: validationQuery doesn't work (DBCP 7.0.59)

2015-06-15 Thread Dhaval Jaiswal
You can change the DB log parameter "log_statement" setting to ALL for the time being and ensure the query execution. On Mon, Jun 15, 2015 at 2:12 PM, Jose María Zaragoza wrote: > Hello: > > > I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 > > The context.xml settings are >

validationQuery doesn't work (DBCP 7.0.59)

2015-06-15 Thread Jose María Zaragoza
Hello: I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 The context.xml settings are I've configured JDBC driver in failover mode ( as you can see in URL definition ) When I test this configuration ( I stop/start databases but , at least, there is one running ) , sometimes