Configure Tomcat’s Resource Factory

Tomcat 7, Oracle 11g

<Resource name="jdbc/dsName" auth="Container">
maxActive="100"
maxIdle="10"
removeAbandoned="true"
removeAbandonedTimeout="1200"
testWhileIdle="true"
testOnBorrow="true"
validationQuery="select 1 from dual"
poolPreparedStatements="false"/>

Note: Read this article and pick up required attributes based on project.
http://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howto.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s