Cannot using Tomcat4.1 connect mysql/sqlserver with JNDI DataSource

[Kelvin Mak]

hi all,
javax.naming.NameNotFoundException: Name MySQLDB is not bound in this Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:811)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:194)
at org.apache.jsp.dbtest_jsp._jspService(dbtest_jsp.java:57)
my server.xml as followin

--------------------------
<GlobalNamingResources>
    <Environment name="simpleValue" override="true" type="java.lang.Integer" value="30"/>
    <Resource 
        auth="Container" 
        description="User database that can be updated and saved" 
        name="UserDatabase" 
        scope="Shareable" 
        type="org.apache.catalina.UserDatabase"
/>
    <Resource name="jdbc/jiveDB" scope="Shareable" type="javax.sql.DataSource"/>
    <Resource name="jdbc/MySQLDB" scope="Shareable" type="javax.sql.DataSource"/>
    <ResourceParams name="UserDatabase">
      <parameter>
        <name>factory</name>
        <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
      </parameter>
      <parameter>
        <name>pathname</name>
        <value>conf/tomcat-users.xml</value>
      </parameter>
    </ResourceParams>
    <ResourceParams name="jdbc/jiveDB">
      <parameter>
        <name>validationQuery</name>
        <value>select * from jiveUser</value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jive</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value></value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>4</value>
      </parameter>
      <parameter>
        <name>maxWait</name>
        <value>5000</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</value>
      </parameter>
      <parameter>
        <name>username</name>
        <value>sa</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>2</value>
      </parameter>
    </ResourceParams>
    <ResourceParams name="jdbc/MySQLDB">
      <parameter>
        <name>validationQuery</name>
        <value>select * from testdata</value>
      </parameter>
      <parameter>
        <name>maxWait</name>
        <value>5000</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>4</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>system</value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:mysql://localhost:3306/mydb?autoReconnect=true</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>org.gjt.mm.mysql.Driver</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>2</value>
      </parameter>
      <parameter>
        <name>username</name>
        <value>kelvin</value>
      </parameter>
    </ResourceParams>
  </GlobalNamingResources>
  

I try to connect mysql and sqlserver2k with JNDI DataSource, alway alert me "Name MySQLDB is not bound in this Context". Anyone ever succeed done with this situation? Any reply will be highly appreciated!!
Kelvin
-- edited by MC to use code tags
[ March 22, 2003: Message edited by: Mike Curwen ]

[Mike Curwen]

Have you followed the steps outlined in Tomcat's docs?

JNDI Resourced HOW-TO

Context Configuration

Some of the things in your server.xml look achingly familiar. I've gone through some of my server.xml's here at home, but can't find validationQuery in any of them. So it must have been at work (for a company I don't work for anymore). But I'm sure this can be made to work. I *do* recall that there were quite a few gotchas. eg: putting your driver classes where the Tomcat internal classes AND your webapp can see them (that would be common/lib)