tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jose MarĂ­a Zaragoza <demablo...@gmail.com>
Subject Re: What if my database is unavailable at startup?
Date Fri, 13 Dec 2013 20:10:11 GMT
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.Dames@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-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message