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.
Bruno
-----Original Message-----
From: ext Keshav Sarin [mailto:KSarin@(protected)]
Sent: Friday, January 09, 2004 3:22 PM
To: tomcat-user@(protected))
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@(protected) >>>
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:@(protected)>
</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@(protected)
* e-mail: bruno.melloni@(protected)
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
