-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Chuck,
On 5/11/2009 8:47 PM, Caldarale, Charles R wrote: >> 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. Whoops, I missed that; thanks for catching it. Wouter, can you check to see if OracleDataSource has similar configuration parameters? If not, consider using Tomcat's pool while you inspect your application... you can always set it back to using Oracle's DataSource if you need to. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkoJoncACgkQ9CaO5/Lv0PDx9ACfUvrw45atUZm65T9LI87GvrCB RlYAnRAasHu2ay/EVgEtthCdy0kiNOTh =agwY -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
