 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Struts - A MVC web framework | | Tomcat - JSP/Servlet container | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | | JSP - A mailing list about Java Server Pages specification and reference | |
Struts & Hibernate
|
|
|
| | | Datasource - OK in app context - Fails in Global context | Datasource - OK in app context - Fails in Global context 2004-01-09 - By Keshav Sarin
Back
There's a catch though....
In TC 4.x, if you put a app context entry in the server.xml, the app
doesn't get reloaded even if the war is overwritten or the app directory
is deleted or the server is restarted. The fully expanded (war)
directory has to be overwritten to webapps directory and server needs to
be restarted to make it work.
This bug is fixed in 5.x.
>>> Bruno.Melloni@(protected) 01/09/04 02:44PM >>>
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); 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@(protected) 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:@(protected):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@(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)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
|
|
|
