commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kwok Peng Tuck <pengt...@makmal.net>
Subject Re: [Commons DBCP] Question.
Date Wed, 10 Sep 2003 10:41:16 GMT
The nightly release right ? If that's so I guess it's time for me to 
download a build and rebuild the binaries on my own.
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:pengtuck@makmal.net]
>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:pengtuck@makmal.net]
>>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: commons-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>>
>>
>>***************************************************************************
>>    
>>
>********
>  
>
>>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: commons-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>>
>>
>>
>> 
>>
>>    
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
>***********************************************************************************
>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: commons-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
>
>  
>


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


Mime
View raw message