Hi,
Where in server.xml is your Resource declaration? Is there a matching
resource-ref in your web.xml? (It's required). You also probably want
a factory parameter, as mentioned in the JNDI DataSources how-to.
Yoav Shapira
Millennium Research Informatics
-----Original Message-----
From: Jeffrey Barnett [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 19, 2004 2:04 PM
To: Tomcat Users List
Subject: Binding DataSources to Contexts in Tomcat 4.06/4.1
I have a servlet that contains the following code in its init() method:
public void init(ServletConfig config) throws ServletException {
super.init(config);
try {
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
System.out.println("Context loaded: " );
ds = (DataSource) envCtx.lookup("ReportsDB");
System.out.println("DataSource found: " + ds.toString());
con = ds.getConnection();
con1 = ds.getConnection();
} catch(Exception e) {
System.err.println("Init Error " + e.getMessage());
}
System.out.println("Init Complete");
}
the server.xml file contains:
<Resource name="ReportsDB" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="ReportsDB">
<parameter><name>maxActive</name><value>100</value></parameter>
<parameter><name>maxIdle</name><value>10</value></parameter>
<parameter><name>maxWait</name><value>10000</value></parameter>
<parameter><name>user</name><value>user</value></parameter>
<parameter><name>password</name><value>password</value></parameter>
<parameter><name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value></parameter>
<parameter><name>driverName</name>
<value>jdbc:oracle:thin:@myhost.edu:1521:LIBR</value></parameter>
</ResourceParams>
When I deploy the servlet on my development server (Tomcat 4.06) it
runs
without error and reports "Init Complete" in the localhost log.
The same code and xml deployed on a test server (tomcat 4.1.12) a
naming
exception is thrown and the catch block reports "Init Error Name
ReportsDB is not bound in this Context".
Is there a difference between the two releases that would explain this,
or are other settings involved in "binding" that I should be examining?
All suggestions gratefully accepted :-)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
This e-mail, including any attachments, is a confidential business communication, and
may contain information that is confidential, proprietary and/or privileged. This
e-mail is intended only for the individual(s) to whom it is addressed, and may not be
saved, copied, printed, disclosed or used by anyone else. If you are not the(an)
intended recipient, please immediately delete this e-mail from your computer system
and notify the sender. Thank you.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
