Summary:: not able to use two oracle resources/
worked perfectly fine after removing those ^M .. came by copy paste from another server. Thanks to all for help Best Regards Kumaresh On Thu, May 6, 2010 at 11:02 AM, kumaresh P N wrote: > Hi, > > was trying to load and use both oracle DB resources from server.xml file > ... but it loads only the first one and not the second one. > > > auth="Container"^M >type="oracle.jdbc.pool.OracleDataSource"^M >driverClassName="oracle.jdbc.driver.OracleDriver"^M >factory="oracle.jdbc.pool.OracleDataSourceFactory"^M >url="jdbc:oracle:thin:@server1:1521:GDOC"^M >user="username"^M >password="password"^M >connectionCacheProperties="{MaxStatementsLimit=10, MinLimit=0, > InitialLimit=0, ValidateConnection=true, ConnectionWaitTimeout=10, > MaxLimit=25}"^M >connectionCachingEnabled="true"^M >connectionCacheName="ConnCache"^M > maxWait="-1" />^M >auth="Container" >type="oracle.jdbc.pool.OracleDataSource" >driverClassName="oracle.jdbc.driver.OracleDriver" >factory="oracle.jdbc.pool.OracleDataSourceFactory" >url="jdbc:oracle:thin:@server2:1521:GDOC" >user="username" >password="password" >scope="Shareable" >connectionCachingEnabled="true" >connectionCacheName="ConnCache" >connectionCacheProperties="{MaxStatementsLimit=10, MinLimit=0, > InitialLimit=0, ValidateConnection=true, ConnectionWaitTime > out=10, MaxLimit=4}" >maxWait="-1" /> > > > Best Regards > Kumaresh > >
Re: not able to use two oracle resources/
2010/5/6 kumaresh P N : > connectionCacheProperties="{MaxStatementsLimit=10, MinLimit=0, > InitialLimit=0, ValidateConnection=true, ConnectionWaitTime > out=10, MaxLimit=4}" Is there an extra space or a linewrap in the "ConnectionWaitTimeout" above? > not the second one Are there any message is the logs? There must be some. Best regards, Konstantin Kolinko - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: not able to use two oracle resources/
define each resource at the server level server.xml with GlobalNamingResources ^M and then reference the desired resource in context.xml with ResourceLink explained here at http://www.microdeveloper.com/html/JNDI_Orcl_Tomcat1p.html Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité 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. > From: pnkumar...@gmail.com > Date: Thu, 6 May 2010 11:02:57 -0400 > Subject: not able to use two oracle resources/ > To: users@tomcat.apache.org > > Hi, > > was trying to load and use both oracle DB resources from server.xml file ... > but it loads only the first one and not the second one. > > > auth="Container"^M >type="oracle.jdbc.pool.OracleDataSource"^M >driverClassName="oracle.jdbc.driver.OracleDriver"^M >factory="oracle.jdbc.pool.OracleDataSourceFactory"^M >url="jdbc:oracle:thin:@server1:1521:GDOC"^M >user="username"^M >password="password"^M >connectionCacheProperties="{MaxStatementsLimit=10, MinLimit=0, > InitialLimit=0, ValidateConnection=true, ConnectionWaitTimeout=10, > MaxLimit=25}"^M >connectionCachingEnabled="true"^M >connectionCacheName="ConnCache"^M > maxWait="-1" />^M >auth="Container" >type="oracle.jdbc.pool.OracleDataSource" >driverClassName="oracle.jdbc.driver.OracleDriver" >factory="oracle.jdbc.pool.OracleDataSourceFactory" >url="jdbc:oracle:thin:@server2:1521:GDOC" >user="username" >password="password" >scope="Shareable" >connectionCachingEnabled="true" >connectionCacheName="ConnCache" >connectionCacheProperties="{MaxStatementsLimit=10, MinLimit=0, > InitialLimit=0, ValidateConnection=true, ConnectionWaitTime > out=10, MaxLimit=4}" >maxWait="-1" /> > > > Best Regards > Kumaresh _ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
RE: not able to use two oracle resources/
> From: Gregor Schneider [mailto:rc4...@googlemail.com] > Subject: Re: not able to use two oracle resources/ > > My crystal ball is just out for maintenance, and without it I'm not > able to read your logs containing the error-message... I think Pid will be teaching his Internet Telepathy class soon - but you have to figure out where and when. - 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.
Re: not able to use two oracle resources/
Could you please come back on that issue next week? My crystal ball is just out for maintenance, and without it I'm not able to read your logs containing the error-message... Rgds Gregor -- just because you're paranoid, don't mean they're not after you... gpgp-fp: 79A84FA526807026795E4209D3B3FE028B3170B2 gpgp-key available @ http://pgpkeys.pca.dfn.de:11371 @ http://pgp.mit.edu:11371/ skype:rc46fi - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
not able to use two oracle resources/
Hi, was trying to load and use both oracle DB resources from server.xml file ... but it loads only the first one and not the second one. ^M Best Regards Kumaresh