Anyone know of a GENERIC (NOT DBCP SPECIFIC) algorithm for testing to
see if a connection needs to be reset before the pool hands it out
without making a query?
--Angus
-Original Message-
From: Andy Eastham [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 11:24 AM
To: Tomcat Users List
Subject: RE: [OFFTOPIC??] RE: dbcp connection and database restart
Angus,
You can call Conection.isClosed(), but the documentation
suggests that this
is not a reliable method of telling that it is _definitely_ closed.
However, if it does return true, you know that you should
reconnect before
attempting a call with the connection.
Andy
-Original Message-
From: Angus Mezick [mailto:[EMAIL PROTECTED]
Sent: 09 July 2003 15:53
To: Tomcat Users List
Subject: [OFFTOPIC??] RE: dbcp connection and database restart
Is there a better way of doing this? Even if I 'select 1
from TABLE' I
don't like the fact that there is an extra DB communication
for every
connection I get from the pool. I don't know if there are
alternatives
to this in DBCP but are there any other ways to ask if a
connection in a
pool is still valid besides just running a query and seeing
if it fails?
(in general, NOT in dbcp)
--Angus
-Original Message-
From: Raible, Matt [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 8:49 AM
To: 'Tomcat Users List'
Subject: RE: dbcp connection and database restart
Try adding a validation query, for example:
parameter
namevalidationQuery/name
valueSELECT * FROM USER_TABLE/value
/parameter
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 6:46 AM
To: [EMAIL PROTECTED]
Subject: dbcp connection and database restart
I've configured my jdbc datasource connection pool(using dbcp) in
Tomcat
4.1.18
server.xml file.
here is an extract of it.
ResourceParams name=jdbc/intranetMail
parameternameusername/namevalueXXX/value/parameter
parameternamepassword/namevalueXXX/value/parameter
parameternamedriverClassName/name
valuecom.sybase.jdbc2.jdbc.SybDriver/value/parameter
parameternameurl/name
valuejdbc:sybase:Tds:s198000SGD1:5000/intranet_mail/value
/parameter
/ResourceParams
Everything works fine. But
when our database server is restarted, I have to restart
Tomcat too
in order to aquire connections from 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
nameremoveAbandoned/name
valuetrue/value
/parameter
parameter
nameremoveAbandonedTimeout/name
value60/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: [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]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]