Hi James,
In mine case I am using jdbc:oracle:thin driver class
oracle.jdbc.driver.OracleDriver
and going through Tomcat doc I can only guess for reconnecting to datbase
a parameter tag in Context tag can
solve the issue.
<parameter><name>validationQuery</name><value>SELECT 1 FROM
DUAL</value></parameter>
But I doubt as from doc it is not clear what exactly this attribute is
used for.
In my sql giving the autoReconnect=true in url works. I was just
wondering waht is the similar attribute for
oracle.jdbc.driver.OracleDriver class. In mine case I am using connection
pool provided by Apache Tomcat
through org.apache.commons.dbcp.BasicDataSourceFactory
Any ideas...?? it would really give me a boost to ahead...
Thank you,
Bhavesh Kumar
Deutsche Bank - FX IT Managed Services Group
Tel: +44 (0)20754 53292 (W)
FX Options Support Information
For support please follow this link: Global FX Options Website
James Sys <[EMAIL PROTECTED]>
07/03/2005 16:49
Please respond to "Tomcat Users List"
To: "Tomcat Users List" <[email protected]>
cc:
Subject: Re: application can not reconnect when database
restarts
Hi,
I'm using Apache 4.1.30 with MySQL and find that connections are
re-established.
I suspect it's worth looking at the options for your Oracle database
connection url.
For example, with MySQL we can specify:
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/MyDatabase?autoReconnect=true</value>
</parameter>
...which seems to do the trick for us.
Regards.
James.
=====
Hi,
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.
Any ideas ? ?
Thank you,
Bhavesh Kumar
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
