I think it's not possible for tomcat 4.0.1 to do a ConnectionPoolDataSource,
you can only make a DataSource.
You have to use javax.sql.DataSource.

All the others params are the same...

Christophe

----- Original Message -----
From: "Niclas Rothman" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, December 11, 2001 2:33 PM
Subject: JNDI resource in Tomcat 4.0.1


Hi!
Got a serious problem to define and use a Resource in Tomcat 4.0.1.
I want to define in the Tomcat a JNDI resource like this (server.xml) under
my webapplication (<context.......>    </context>)

<Resource name="jdbc/tdcconn" auth="Container"
type="javax.sql.ConnectionPoolDataSource"/>
<ResourceParams name="jdbc/tdcconn">
            <parameter>
<name>user</name>
<value>tdc</value>
</parameter>
            <parameter>
<name>password</name>
<value>tdc</value>
</parameter>
            <parameter>
<name>driverClassName</name>

<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
            <parameter>
<name>driverName</name>

<value>jdbc:microsoft:sqlserver://ramirez:1433</value>
</parameter>
          </ResourceParams>

And in the web.xml for my webapplication I�vd declared the resource like
this:

<resource-ref>
  <description>Try connection pool with fucking
MS</description>
  <res-ref-name>jdbc/tdcconn</res-ref-name>
  <res-type>javax.sql.ConnectionPoolDataSource</res-type>
  <res-auth>Container</res-auth>
</resource-ref>

In my JSP code I try to access the resource like this:

javax.naming.InitialContext ctx= new javax.naming.InitialContext();
ctx.lookup("java:comp/env");
javax.naming.NamingEnumeration enum= ctx.list("java:comp/env");
ds= (javax.sql.ConnectionPoolDataSource) ctx.lookup("jdbc/tdcconn");


And the exception comes out like this:

javax.naming.NameNotFoundException: Name jdbc is not bound in this
context.....


Any suggestions

Niclas Rothman



Niclas Rothman
System Developer

e|sense
�ster F�lled Torv 4
DK-2100 Copenhagen
Denmark

+45 35 44 17 00 - reception
+45 35 44 17 21 - direct
+45 35 44 17 17 - fax

[EMAIL PROTECTED]
www.e-sense.dk

e|sense - a Kunde Group company



--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>



--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

Reply via email to