I'm sure we're all tired of reading about these problems (and God knows I'm tired of
pounding my head against a wall because of them), but I can't seem to get the contexts
and connectionpooling/datasources working.
For starters:
Local Development Machine: pIII450, 512MB ram, win2000, tomcat 4.03 through sun one
studios/forte
Remote Development Machine: SunOS, 1Gig ram, tomcat 4.03 standalone
The problem:
I've attempted to configure my app to use a JDBC DataSource by changing the server.xml
and web.xml files. The resource tags in the server.xml are:
<Resource name="jdbc/myoracle" auth="Container" type="javax.sql.Datasource" />
<ResourceParams name="jdbc/myoracle">
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:oracle:thin:@oracle.host.blah:1521:ORCL</value>
</parameter>
<parameter>
<name>username</name>
<value>scott</value>
</parameter>
<parameter>
<name>password</name>
<value>tiger</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
These are the connection strings and parameters that I use to successfully connect the
database by manually registering the driver and simply making a connection.
The web.xml has:
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
So, I saw the JndiServlet example, and modified it to spit out whatever I had bound to
my context both by looking to the initial context and my environmental context (which,
yes, I know, is part of the initial context, but I'm stumped, so I'm trying most
anything I can think of). This is the code:
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:comp/env");
DataSource ds = (DataSource) envContext.lookup("jdbc/myoracle");
if(ds!=null)
{
Connection conn = ds.getConnection();
}
else
{
out.println("DataSource ds is null<br>");
}
//This page tests the database connection pool.
//
//Imported from JndiServlet.java in examples folder
NamingEnumeration enum = initContext.list("java:/comp/env/jdbc");
while (enum.hasMoreElements()) {
out.print("Binding : ");
out.println(enum.nextElement().toString());
}
enum = envContext.listBindings("jdbc");
out.println("<br>listBindings1() on /comp/env/jdbc Context : ");
//enum = initContext.listBindings("java:/comp/env/jdbc");
while (enum.hasMoreElements()) {
out.print("Binding : ");
out.println(enum.nextElement().toString());
}
out.println("<br>listBindings2() on /comp/env/jdbc Context : ");
enum = initContext.listBindings("java:/comp/env/jdbc");
while (enum.hasMoreElements()) {
out.print("Binding : ");
out.println(enum.nextElement().toString());
}
%>
So, anytime I try it, ta-dah! The datasource is null. However, the output shows this:
DataSource ds is null
Binding : myoracle: org.apache.naming.ResourceRef
listBindings1() on /comp/env/jdbc Context : Binding : myoracle:
org.apache.naming.ResourceRef:Reference Class Name: javax.sql.DataSource Type:
description Content: Oracle Datasource example Type: scope Content: Shareable Type:
auth Content: Container Type: maxWait Content: -1 Type: maxActive Content: 20 Type:
password Content: tiger Type: driverName Content:
jdbc:oracle:thin:@oracle.host.blah:1521:ORCL Type: driverClassName Content:
oracle.jdbc.driver.OracleDriver Type: maxIdle Content: 10 Type: username Content:
scott
listBindings2() on /comp/env/jdbc Context : Binding : myoracle:
org.apache.naming.ResourceRef:Reference Class Name: javax.sql.DataSource Type:
description Content: Oracle Datasource example Type: scope Content: Shareable Type:
auth Content: Container Type: maxWait Content: -1 Type: maxActive Content: 20 Type:
password Content: tiger Type: driverName Content:
jdbc:oracle:thin:@oracle.host.blah:1521:ORCL Type: driverClassName Content:
oracle.jdbc.driver.OracleDriver Type: maxIdle Content: 10 Type: username Content:
scott
So it looks like it can find all of the information for this datasource... and yet,
no datasource?
Any suggestions? Please... my head hurts as it is...:)
Thanks for your time...
Michael Nicholson
