> From: Christopher Schultz [mailto:ch...@christopherschultz.net]
> Subject: Re: Tomcat and Oracle connections
> 
> I would highly recommend adding these two attributes to your
> <Resource>:
> 
>    logAbaodoned="true"
>    removeAbandoned="true"
>    removeAbandonedTimeout="30"
> 
> While you're at it, maybe you want to set:
> 
>    validationQuery="SELECT 1 FROM DUAL"

Note that the OP is using type="oracle.jdbc.pool.OracleDataSource" rather than 
Tomcat's pooling mechanism; consequently the above (slightly misspelled) 
attributes may not be applicable.

 - Chuck


THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY 
MATERIAL and is thus for use only by the intended recipient. If you received 
this in error, please contact the sender and delete the e-mail and its 
attachments from all computers.

Reply via email to