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: [email protected]
For additional commands, e-mail: [email protected]