You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Bhavesh Kumar <bh...@db.com> on 2005/03/06 15:17:19 UTC
application can not reconnect when database restarts
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.BasicDataSourceFactory</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</value></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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
RE: Tomcat on Win XP 64 Bit
Posted by Jeffrey Lanham <bl...@gvtc.com>.
Yes, I'm currently running it under the 64bit RC2 with the Java 1.5.0 jdk/jre. It runs well, if only in 32bits.
Jeff
-----Original Message-----
From: Peter Neu [mailto:peter.neu@gmx.net]
Sent: Monday, March 07, 2005 12:09 PM
To: Tomcat Users List
Subject: Tomcat on Win XP 64 Bit
Hello,
has anyone tried to run Tomcat on Window XP 64 Bit? I
was wondering if it is safe to switch my whole
devlopement environment to the new OS version.
cheer,
Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Tomcat on Win XP 64 Bit
Posted by Peter Neu <pe...@gmx.net>.
Hello,
has anyone tried to run Tomcat on Window XP 64 Bit? I
was wondering if it is safe to switch my whole
devlopement environment to the new OS version.
cheer,
Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: application can not reconnect when database restarts
Posted by James Sys <ja...@MySpareKey.co.uk>.
Hi Bhavesh,
Glad to hear the auto-reconnect worked for you with MySQL.
I've not tried the same with Oracle, so can only suggest you research this option.
Still, Deutsche Bank are a large company & must have lots of Oracle experts available. I'm sure one of them can point you in the right direction.
Good luck.
Regards,
James.
=====
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 <ja...@MySpareKey.co.uk>
07/03/2005 16:49
Please respond to "Tomcat Users List"
To: "Tomcat Users List" <to...@jakarta.apache.org>
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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: application can not reconnect when database restarts
Posted by Bhavesh Kumar <bh...@db.com>.
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 <ja...@MySpareKey.co.uk>
07/03/2005 16:49
Please respond to "Tomcat Users List"
To: "Tomcat Users List" <to...@jakarta.apache.org>
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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: application can not reconnect when database restarts
Posted by James Sys <ja...@MySpareKey.co.uk>.
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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org