not able to use two oracle resources/

[kumaresh P N]

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.


<Resource name="jdbc/DEVDS"^M
   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
   <Resource name="jdbc/TRGDS"
   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