실행환경
windows 2000 professional, Tomcat 4.0.2-b2, mysql 3.23.47, mm.mysql-2.0.11-bin.jar
		

c:/tomcat4/webapps/WEB-INF/web.xml
<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>
  <resource-ref>
    <description>
      Resource reference to a factory for java.sql.Connection
      instances that may be used for talking to a particular
      database that is configured in the server.xml file.
    </description>

    <res-ref-name>
      jdbc/OkjspDB
    </res-ref-name>

    <res-type>
      javax.sql.DataSource
    </res-type>

    <res-auth>
      Container
    </res-auth>
  </resource-ref>
</web-app>
		

c:/tomcat4/conf/server.xml 중 일부

...
        <!-- Tomcat Root Context -->
        <!--
        -->
        <Context path="" docBase="ROOT" debug="0">
  <Resource name="jdbc/OkjspDB" auth="Container"
            type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/OkjspDB">
    <parameter>
      <name>user</name>
      <value>okjsp</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>kenu1234</value>
    </parameter>

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

    <parameter>
      <name>driverName</name>
      <value>jdbc:mysql://localhost:3306/okjspDB</value>
    </parameter>
  </ResourceParams>
        </Context>  

...
		

c:/tomcat4/webapps/ROOT/jndi01.jsp

<%@ page 
import="java.sql.*, javax.naming.*, javax.sql.*"%><%

Context initCtx = new InitialContext();

Context envCtx = (Context) initCtx.lookup("java:comp/env");

DataSource ds = (DataSource) envCtx.lookup("jdbc/OkjspDB");

Connection conn = ds.getConnection();

Statement stmt = conn.createStatement();

String query = "select now()";

ResultSet rs = stmt.executeQuery(query);

if(rs.next()) {
  out.println(rs.getTimestamp(1));
}

rs.close();

stmt.close();

conn.close();
%>