Thanks.
Incidently I find I get the same problem with Sun One App server, although they don't use DBCP :D
TULK, Daniel, FM wrote:
I replaced the jar. I downloaded the latest commons-dbcp and commons-pool jars, dropped them into $TOMCAT_HOME/common/lib and removed dbcp.jar from $TOMCAT_HOME/common/lib
-----Original Message----- From: Kwok Peng Tuck [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 11:30 To: Jakarta Commons Users List Subject: Re: [Commons DBCP] Question.
That didn't work, if a connection in the pool was closed. I still get an exception.
Are you referring to the DBCP that shipped with tomcat or did you replace the jar ?
TULK, Daniel, FM wrote:
********I had a similar problem and it was because the connections weren't being validated. The current release version of DBCP allows a validationQuery configuration parameter. The parameter is used to test the database connection before it is returned, when it isn't valid it will be renewed. I don't know how to test a SAPDB connection but for Sybase I added this to my Tomcat server.xml in the section where the DataSource is configured:
<parameter> <name>validationQuery</name> <value>SELECT 1</value> </parameter>
Dan
-----Original Message----- From: Kwok Peng Tuck [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 11:09 To: Jakarta Commons Users List Subject: [Commons DBCP] Question.
I have a question about commons DBCP, maybe someone has and idea.
I want to know how commons DBCP would cope with DB connections that have gone idle and are closed by the
database.
I've used commons DBCP provided by tomcat and find that after 15 minutes SAPDB will close the connection.
When DBCP gives the webapp a connection, we get a BorrowObject null and throw a exception. I've found that
writing some sort of keep alive helps this alot for us.
Does anyone know if the nightly build of DBCP can cope with this better ?
Thanks.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
***************************************************************************
********This e-mail is intended only for the addressee named above. As this e-mail may contain confidential or privileged information, if you are not the named addressee, you are not authorised to retain, read, copy or disseminate this message or any part of it. The Royal Bank of Scotland plc is registered in Scotland No 90312 Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB Regulated by the Financial Services Authority
Visit our website at http://www.rbs.co.uk/CBFM/
***************************************************************************
--------------------------------------------------------------------- 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]
*********************************************************************************** This e-mail is intended only for the addressee named above. As this e-mail may contain confidential or privileged information, if you are not the named addressee, you are not authorised to retain, read, copy or disseminate this message or any part of it. The Royal Bank of Scotland plc is registered in Scotland No 90312 Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB Regulated by the Financial Services Authority
Visit our website at http://www.rbs.co.uk/CBFM/ ***********************************************************************************
--------------------------------------------------------------------- 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]
