struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dan Tran" <dantt...@hotmail.com>
Subject Re: problem with dbcp and database restart
Date Wed, 09 Jul 2003 15:38:01 GMT
Meissa,

When your database restarts, all your dbcp connections (in the pool) become
staled connection.

In order to resolve this problem, dbcp needs to do a ping to database server
to make the connection is still up before giving to your app.

Looking into dbcp configuration doc, it should have a param you can setup
(something like QueryString) where
it should be a select statement to a database table.  You many need to setup
a dummy table just for this purpose.

Hope this helps.

-Dan
----- Original Message ----- 
From: <meissa.Sakho@assetmanagement.natexis.fr>
To: <struts-user@jakarta.apache.org>
Sent: Wednesday, July 09, 2003 7:36 AM
Subject: problem with dbcp and database restart


>
> hi all,
>
> I have a problem with my configured datasource using dbcp.
> I have posted this question to tomcat user list in vain...
> Maybe some struts user could help.
>
> I've configured my dbcp connection pool  in Tomcat 4.1.18
> server.xml file.
>
> here is an extract of it
> <ResourceParams name="jdbc/intranetMail">
>  <parameter><name>username</name><value>XXXXXXX</value></parameter>
>  <parameter><name>password</name><value>XXXXXXX</value></parameter>
>             <parameter><name>driverClassName</name>
>               <value>com.sybase.jdbc2.jdbc.SybDriver</value></parameter>
>             <parameter><name>url</name>
>  <value>jdbc:sybase:Tds:s198000SGD1:5000/intranet_mail</value></parameter>
>
>             <parameter>
>               <name>removeAbandoned</name>
>               <value>true</value>
>             </parameter>
>             <parameter>
>               <name>removeAbandonedTimeout</name>
>               <value>60</value>
>             </parameter>
> Everything works fine. But
> when our database server is restarted, I have to restart Tomcat
> in order to aquire connection to my defined pool.
>
> I wonder if there is a manner to avoid restarting Tomcat when
> the database server is restarted.
>
> I have added the parameters below to my pool config.
>
>             <parameter>
>               <name>removeAbandoned</name>
>               <value>true</value>
>             </parameter>
>             <parameter>
>               <name>removeAbandonedTimeout</name>
>               <value>60</value>
>             </parameter>
>
>  I recognize ,I've added that quite blindly.
>  Can someone confirm me if this is a cure to my problem ?
>
>  any suggestion is greatly appreciated.
>
>
>  Meissa
>
> L'integrite de ce message n'etant pas assuree sur internet, Natexis
> Banques Populaires ne peut etre tenu responsable de
> son contenu. Toute utilisation ou diffusion non autorisee est
> interdite. Si vous n'etes pas destinataire de ce message, merci de le
> detruire et d'avertir l'expediteur.
>
> The integrity of this message cannot be guaranteed
> on the Internet. Natexis Banques Populaires can not therefore be
> considered responsible for the contents.Any unauthorized use or
dissemination is prohibited.
> If you are not the intended recipient of this message, then please delete
it and
> notify the sender.

---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org


Mime
View raw message