I am using Apache Tomcat/4.1.27.
Problem: when datbase restarts connection is not established.
Connection pool is done by Tomcat using DBCP.
Context congiguration under server.xml file is as
<Context path="/MyWebApp" docBase="MyWebApp" debug="0" reloadable="true" >
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_MyWebApp_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/rmsDataSource" type="javax.sql.DataSource"
auth="Container" description="Database resource for MyWebApp" />
<ResourceParams name="jdbc/rmsDataSource">
<parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSource
Factory</value></parameter> <parameter > <name >maxActive</name><value
>20</value> </parameter>
<parameter > <name >maxIdle</name><value >25</value> </parameter>
<parameter > <name >maxWait</name><value >100000</value> </parameter>
<parameter> <name>removeAbandoned</name> <value>true</value> </parameter>
<parameter> <name>removeAbandonedTimeout</name> <value>1</value>
</parameter>
<parameter> <name>logAbandoned</name> <value>true</value> </parameter>
<parameter><name>username</name><value>test_app</value></parameter>
<parameter><name>password</name><value>test_app</value></parameter>
<parameter><name>driverClassName</name><value>oracle.jdbc.driver.OracleDriver
</value></parameter>
<parameter><name>url</name><value>jdbc:oracle:thin:@test.com:1521:testDB</va
lue></parameter> </ResourceParams>
</Context>
web.xml this is configured as
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd";>
<web-app>
<display-name>Welcome to Tomcat</display-name>
<description>Welcome to Tomcat</description>
<welcome-file-list>
<welcome-file>/jsp/login.jsp</welcome-file>
</welcome-file-list>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/rmsDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
Is there any tag which takes care that application is automatically
connected whenever datbase goes up.
It would be really great if there is some feedback on this problem.
I know for My SQL we can append autoRecconnect=true in database url ..
Is there any equivalent for jdbc:oracle:thin driver like
oracle.jdbc.driver.OracleDriver
Going through Tomcat DBCP configuration somewhere it is mention use
validationQuery as a parameter in context tag.
But I am not really sure....because it is not clear what is the purpose of
this parameter.
Any ideas ? ?
Thank you,
Bhavesh Kumar
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
