You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "David P. Nesbitt" <dn...@questerra.com> on 2002/12/07 21:59:50 UTC

Tomcat 4.0.4 and DataSource problem

I am having a problem obtaining a DataSource using Tomcat 4.0.4.

Here is what is in the log:

Data source name is:jdbc/QTDSDEV
java.lang.ClassCastException: org.apache.naming.ResourceRef

Here is my server.xml snippet:

<Context path="/myapp" docBase="myapp"
         debug="5" reloadable="true" crossContext="true">

   <Logger className="org.apache.catalina.logger.FileLogger"
           prefix="localhost_myapp_log." suffix=".txt"
           timestamp="true"/>

   <Resource name="jdbc/QTDSDEV" 
             auth="Container" 
             type="javax.sql.DataSource"/>

   <ResourceParams name="jdbc/QTDSDEV">
      <parameter>
         <name>user</name>
         <value>myuser</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>mypassword</value>
      </parameter>
      <parameter>
         <name>driverClassName</name>
         <value>oracle.jdbc.driver.OracleDriver</value>
      </parameter>      
      <parameter>
         <name>driverName</name>
         <value>jdbc:oracle:thin:@172.16.1.244:1521:qtdsdev</value>
      </parameter>
   </ResourceParams>
</Context>

Here is my web.xml snippet:

   <resource-ref> 
      <description>DB Connection</description> 
      <res-ref-name>jdbc/QTDSDEV</res-ref-name> 
      <res-type>javax.sql.DataSource</res-type> 
      <res-auth>Container</res-auth> 
   </resource-ref>

Here is my source code snippet:

   initCtx = new InitialContext();
   dbCtxt = (Context) initCtx.lookup("java:comp/env");
   dataSource = (DataSource) dbCtxt .lookup("jdbc/QTDSDEV");

I have renamed classes12.zip to classes12.jar and placed it in
common/lib.

Thanks in advance for any help you can provide.

Regards,
Dave

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>