-----Original Message-----
From: Dames, Kristopher J [mailto:[email protected]]
Sent: Friday, December 13, 2013 1:39 PM
To: Tomcat Users List
Subject: RE: What if my database is unavailable at startup?
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"
/>
I use DBCP and Oracle as well, and am also on Tomcat 6 - 6.0.26. Take a look at
mine, as I have NO trouble with it, and see if you can configure it similarly
with success. NOTE - remove those other two parameters that Jose mentions in a
prior email.
<Resource
auth="Container"
description="mytomcatapp"
name="jdbc/myoracle"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
username="username"
password="password"
url="jdbc:oracle:thin:@cgnrdb1p:1648:SERVNAME"
maxIdle="30"
maxWait="10000"
maxActive="10"
testOnBorrow="true"
timeBetweenEvictionRunsMillis="-1"
minEvictableIdleTimeMillis="28800"
poolPreparedStatements="true"
removeAbandoned="true"
removeAbandonedTimeout="300"
logAbandoned="false"/>
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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
