Here is configuration which would work for your TC environment http://forum.springsource.org/showthread.php?t=63392
One more link which will illustrate usage of OracleConnectionCacheImpl http://www.stanford.edu/group/coursework/stanfordoki/oracle/oracle/jdbc/pool/OracleConnectionCacheImpl.html feel free to ping me offline for any details on configuring the DataSource or how to determine if your DB supports FCF Martin Gainty ______________________________________________ Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité This message is confidential. If you should not be the intended receiver, then we ask politely to report. Each unauthorized forwarding or manufacturing of a copy is inadmissible. This message serves only for the exchange of information and has no legal binding effect. Due to the easy manipulation of emails we cannot take responsibility over the the contents. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Tue, 12 May 2009 12:23:19 -0400 > From: ch...@christopherschultz.net > To: users@tomcat.apache.org > Subject: Re: Tomcat and Oracle connections > > -----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 > _________________________________________________________________ Insert movie times and more without leaving Hotmail®. http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=TXT_TAGLM_WL_HM_Tutorial_QuickAdd1_052009
