MySQL Database and Tomcat 4.0.1

["Nottebrok, Guido" <Gu...@t-systems.de>]

Hallo,

I try to use a MySQL database with tomcat4.0.1. and Windows2000 but no success.
The jdbc2_0-stdext.jar and mm.mysql-2.0.6.jar are in CATALINA_HOME\common\lib.
I read the jndi-resources-howto.html and searched in the list-archive but I get
always null for the DataSource or a NamingException.

Do I need the factory entry in server.xml ?
Is the correct type javax.sql.DataSource or org.gjt.mm.mysql.MysqlDataSource?
In some exampes I found auth="SERVLET". But in the documentation was written, that
the value must be "Container" or "Application". What do I have to put there?

Could somebody please send me an example for web.xml, server.xml and coding
or show me my mistakes.

Here is what I have, but this is not working.

----- server.xml -----

        <Context path="/schulpartner"
                 docBase="schulpartner"
                 crossContext="false"
                 debug="0"
                 reloadable="true" >
            <Logger className="org.apache.catalina.logger.FileLogger"
                     prefix="localhost_schulpartner_log." suffix=".txt"
        	  timestamp="true"/>
            <!-- JNDI JDBC DataSource Resource for using MySQL dB -->
          <Resource name="jdbc/mysqlDB" auth="SERVLET"
                    type="javax.sql.DataSource"/> 
                    <!-- type="org.gjt.mm.mysql.MysqlDataSource"/> -->
            <ResourceParams name="jdbc/mysqlDB">
               <parameter><name>factory</name>
                 <value>org.gjt.mm.mysql.MysqlDataSourceFactory</value> 
               </parameter> 
               <parameter><name>user</name><value>name</value></parameter>
               <parameter><name>password</name>pw<value></value></parameter>
               <parameter><name>driverClassName</name>
                 <value>org.gjt.mm.mysql.Driver</value></parameter>
               <parameter><name>driverName</name>
                 <value>jdbc:mysql://localhost:3306/mysql</value>
               </parameter>
            </ResourceParams>
        </Context>

----- server.xml -----

  <resource-ref>
    <description>
        Datenbank LPM Schulpartnerschaften
    </description>
    <res-ref-name>jdbc/mysqlDB</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
    <!--<res-type>org.gjt.mm.mysql.MysqlDataSource</res-type>  -->
    <res-auth>Container</res-auth>
  </resource-ref>


----- in my Servlet -----
        DataSource ds = null;
        //MysqlDataSource mds = null;
        Context initCtx = null;
        Context envCtx = null;
        
        
        //IninitialContext anlegen
        try
        {
            initCtx = new InitialContext();
        }
        catch (NamingException e)
        {
            log(" Konnte keinen InitialContext anlegen: " + e);
            return;
        }

        try
        {
            envCtx = (Context) initCtx.lookup("java:comp/env");
        }
        catch (NamingException e)
        {
            log(" Konnte keinen Context für 'java:comp/env' anlegen: " + e);
            return;
        }

        try
        {
            ds = (DataSource) envCtx.lookup("jdbc/mysqlDB");
            //ds = (MysqlDataSource) envCtx.lookup("jdbc/mysqlDB");
            log(" Datasource: "+ds);
        }
        catch (NamingException e)
        {
            log("lookup für 'jdbc/mysqlDB' fehlgeschlagen: " + e);
            return;
        }

Thanks in advance
Guido