jndi resources in tomcat 4

[Marc Savitsky]

Hi,

I am having great trouble getting tomcat to give me a  mysql Datasource.
When I switch on debugging, I can see that the resource seems to be created
in the tomcat context from the monitor file catalina.out:

XmlMapper: new null org.apache.catalina.deploy.ContextResource resource-ref
ContextResource[name=null,scope=Shareable]
XmlMapper: org.apache.catalina.deploy.ContextResource.setName( jdbc/rmtDb)
XmlMapper: org.apache.catalina.deploy.ContextResource.setType(
javax.sql.DataSource)
XmlMapper: org.apache.catalina.deploy.ContextResource.setAuth( Container)
XmlMapper: Calling org.apache.catalina.core.StandardContext.addResource
ContextResource[name=jdbc/rmtDb, type=javax.sql.DataSource, auth=Container,
scope=Shareable]
XmlMapper: pop resource-ref org.apache.catalina.deploy.ContextResource:
ContextResource[name=jdbc/rmtDb, type=javax.sql.DataSource, auth=Container,
scope=Shareable]

but when accessed by a servlet, tomcat is giving me a DataSource with a null
value.
mm.mysql-2.0.13-bin.jar has been installed in the common/lib directory.
I am using tomcat 4.0.3 on HPux 11.00 with jdk1.4.

here are the relevent sections from the configuration files that I am using:

server.xml

        <Context path="/rmt" docBase="rmt" debug="9"
                 reloadable="true" cookies="true">
          <Logger className="org.apache.catalina.logger.FileLogger"
                     prefix="localhost_rmt_log." suffix=".txt"
                  timestamp="true"/>
          <Resource name = "jdbc/rmtDb" auth="Container"
                    type="javax.sql.DataSource"/>
          <ResourceParams name = "jdbc/rmtDb">
            <parameter><name>user</name><value>mysql</value></parameter>
            <parameter><name>password</name><value>mysql</value></parameter>

<parameter><name>driverClassName</name><value>org.gjt.mm.mysql.Driver</value
></parameter>

<parameter><name>driverName</name><value>jdbc:mysql://gwl:3306/rmt</value></
parameter>
          </ResourceParams>
        </Context>

and web.xml

    <resource-ref>
      <res-ref-name>jdbc/rmtDb</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
    </resource-ref>

I have tried to follow the jndi how-to without success.
I'm sure that I am missing out something really fundermental.
Has anyone got any ideas to help me out?

thanks

Marc



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>