With testOnBorrow="true" ( I think that is the default value in Tomcat 6 ) + validationQuery="SELECT 1 FROM DUAL" , that should work
I've never used maxOpenPreparedStatements="0" accessToUnderlyingConnectionAllowed="false" what are they for ? 2013/12/13 Dames, Kristopher J <kristopher.da...@mercy.net>: > Daniel, > > I use tomcat 6.0.32. Here is an example Resource tag: > > <Resource > accessToUnderlyingConnectionAllowed="false" > auth="Container" > defaultAutoCommit="true" > defaultReadOnly="false" > defaultSchema="xxxxx" > driverClassName="oracle.jdbc.driver.OracleDriver" > factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" > initialSize="0" > logAbandoned="false" > maxActive="20" > maxIdle="8" > maxOpenPreparedStatements="0" > maxWait="5000" > minEvictableIdleTimeMillis="1800000" > minIdle="5" > name="jdbc/xxxxx" > numTestsPerEvictionRun="3" > password="xxxxx" > poolPreparedStatements="false" > removeAbandoned="true" > removeAbandonedTimeout="300" > testOnBorrow="true" > testOnReturn="false" > testWhileIdle="true" > timeBetweenEvictionRunsMillis="1800000" > type="javax.sql.DataSource" > url="jdbc:oracle:thin:@xxxxx.yyyyy.com:1521:xxxxx" > username="xxxxx" > validationQuery="SELECT 1 FROM DUAL" > /> > > This email contains information which may be PROPRIETARY IN NATURE OR > OTHERWISE PROTECTED BY LAW FROM DISCLOSURE and is intended only for the use > of the addresses(s) named above. If you have received this email in error, > please contact the sender immediately. > > --------------------------------------------------------------------- > 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