tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacob Kjome <h...@visi.com>
Subject RE: Datasource - OK in app context - Fails in Global context
Date Sat, 10 Jan 2004 04:38:31 GMT
At 03:44 PM 1/9/2004 -0600, you wrote:
>Bingo!!!  That was it.
>
>It might be a good idea to add a paragraph to the JDBC DataSources section 
>of the documentation that mentions:
>
>(a) That global datasources are defined in <GlobalNamingResources> of 
>server.xml
>(b) The need for the <ResourceLink> in the application context .xml file
>
>I had the mistaken impression that anything placed in the server.xml file 
>was automatically applied to all application contexts.  I am sure that 
>others make the same mistake.
>
>Thanks, I have been pulling my hair on this issue for almost a month.

This is true for <DefaultContext>.  Maybe you were confusing 
<GlobalNamingResources> with that.  The latter lets you define things once 
and let applications link to it if they want the service whereas the former 
makes the service available for every app whether it is wanted or not.

Jake


>Bruno
>
>-----Original Message-----
>From: ext Keshav Sarin [mailto:KSarin@net-deposit.com]
>Sent: Friday, January 09, 2004 3:22 PM
>To: tomcat-user@jakarta.apache.org; Melloni Bruno (Nokia-BI/Dallas)
>Subject: Re: Datasource - OK in app context - Fails in Global context
>
>
>Have you defined a reference to the global resource in the
><ResourceLink> element of the application context ?
>
> >>> Bruno.Melloni@nokia.com 01/09/04 10:38AM >>>
>I have an Oracle JDBC datasource that I defined in the Tomcat5 context
>for an application (conf/Catalina/localhost/nwg.xml).  Works fine,
>context file listed below.
>
>But when I tried to move the datasource to the <GlobalNamingResources>
>section of server.xml so that it would be accessible to all apps it gets
>recognized in the admin console, but not by the application.
>
>What gives?  I thought a Global resource is supposed to function
>identically to an application resource.
>
>Any help would be greatly welcomed.
>
>
>nwg.xml:
>   <Resource auth="Container" name="rcfDS"
>type="javax.sql.DataSource"/>
>   <ResourceParams name="rcfDS">
>     <parameter>
>       <name>factory</name>
>       <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
>     </parameter>
>     <parameter>
>       <name>driverClassName</name>
>       <value>oracle.jdbc.driver.OracleDriver</value>
>     </parameter>
>     <parameter>
>       <name>url</name>
>
><value>jdbc:oracle:thin:@hostNameHere:portNumberHere:dbNameHere</value>
>     </parameter>
>     <parameter>
>       <name>username</name>
>       <value>usernameHere</value>
>     </parameter>
>     <parameter>
>       <name>password</name>
>       <value>userpasswordHere</value>
>     </parameter>
>     <parameter>
>       <name>maxIdle</name>
>       <value>10</value>
>     </parameter>
>     <parameter>
>       <name>maxActive</name>
>       <value>20</value>
>     </parameter>
>     <parameter>
>       <name>maxWait</name>
>       <value>-1</value>
>     </parameter>
>     <parameter>
>       <name>removeAbandoned</name>
>       <value>true</value>
>     </parameter>
>     <parameter>
>       <name>logAbandoned</name>
>       <value>true</value>
>     </parameter>
>   </ResourceParams>
>
>Note: The JDBC driver is ojdbc14.jar and is present in common/lib, the
>application's WEB-INF/lib and is present also in the JRE's lib/ext for
>unrelated JAAS reasons.
>
>Bruno Melloni
>eBusiness Application Center, Americas
>Nokia, Inc
>6000 Connection Drive, Mailstop 4w223
>Irving, TX  75039  USA
>*Office: +1 (972)894-6120
>*Cellular: +1 (469) 939-1067
>* SMS:     4699391067@tmomail.net
>* e-mail: bruno.melloni@nokia.com
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message