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" ?
How I can debug if validationQuery is working as I want ?
Thanks and regards
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
