2015-06-15 16:35 GMT+02:00 Daniel Mikusa <dmik...@pivotal.io>: > On Mon, Jun 15, 2015 at 4:42 AM, Jose María Zaragoza <demablo...@gmail.com> > wrote: > >> Hello: >> >> >> I'm using Tomcat 7.0.59 and PostgreSQL JDBC driver 9.4-1201-jdbc4 >> >> The context.xml settings are >> >> >> <Resource auth="Container" type="javax.sql.DataSource" >> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > > driverClassName="org.postgresql.Driver" >> initialSize="0" maxActive="100" maxIdle="20" >> maxWait="10000" mindIdle="0" >> name="datasource/bbdd" password="fake" >> removeAbandoned="true" >> >> >> url="jdbc:postgresql://localhost:9999,localhost:5432,localhost:5433/bbdd?LoginTimeout=3&loadBalanceHosts=false" >> username="foo" validationQuery="SELECT 1" >> testOnBorrow="true" timeBetweenEvictionRunsMillis="0"/> >> >> >> 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 I'm getting this error >> message: >> >> >> org.apache.ibatis.exceptions.PersistenceException: >> ### Error querying database. Cause: >> org.postgresql.util.PSQLException: This connection has been closed. >> >> How is it possible if testOnBorrow="true" and validationQuery="SELECT 1" ? >> > > Try setting validationInterval to a lower value. It defaults to 30s, which > means it will only run the query once per 30s. > > http://tomcat.apache.org/tomcat-8.0-doc/jdbc-pool.html#Tomcat_JDBC_Enhanced_Attributes
You got it ! Thanks Now I need to understand which is the best value ( in performance terms ) Regards > > >> How I can debug if validationQuery is working as I want ? >> > > 1.) Start Tomcat, make sure the app is working. > 2.) Stop the DB. > 3.) Your app should stop working, since it can't get a connection. Also, > any pooled connections will now be bad. > 4.) Start the DB. > 5.) Your app should be working again. If the pool is configured properly > as your app requests connections, it should remove the bad connections and > replace them with new ones. > > Dan > > > >> >> >> Thanks and regards >> >> --------------------------------------------------------------------- >> 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
