[enterprise-list] DataSource + Tomcat + Access

[Tangerini, Marcio]

Pessoal,

 

Estou tentando executar o seguinte trecho de c�digo num servlet:

 

  resp.setContentType("text/html");  
  java.io.PrintWriter out = resp.getWriter();
  Context jndictx=new InitialContext();
  DataSource ds=(DataSource)jndictx.lookup("jdbc/HelpWFMS");
  con=ds.getConnection("help","senha");
  stmt=con.createStatement();
  rs=stmt.executeQuery("select * from Users");

 

S� que quando o servlet executa, recebo a seguinte mensagem do Tomcat:

 

javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
        at org.apache.naming.NamingContext.lookup(NamingContext.java:811)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:194)
        at org.apache.naming.SelectorContext.lookup(SelectorContext.java:183)
        at javax.naming.InitialContext.lookup(InitialContext.java:347)
        at HelpWFMS.DbCacheServlet.doGet(DbCacheServlet.java:50)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServl
et.java:458)
        at org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java
:180)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:247)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

 

Meu server.xml t� configurado da seguinte maneira (trecho):

 

          <Resource name="jdbc/HelpWFMS" auth="SERVLET"
                    type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/HelpWFMS">
            <parameter><name>username</name><value>help</value></parameter>
            <parameter><name>password</name><value>senha</value></parameter>
            <parameter><name>driverClassName</name>
              <value>sun.jdbc.odbc.JdbcOdbcDriver</value></parameter>
            <parameter><name>url</name>
              <value>jdbc:odbc:HelpWFMS</value></parameter>
          </ResourceParams>

 

Meu 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>
  <display-name>Welcome to Tomcat</display-name>
  <description>
     Welcome to Tomcat
  </description>
<resource-ref>
 <description>Test Datasource</description>
 <res-ref-name>jdbc/HelpWFMS</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
</resource-ref>
</web-app>

 

Estou utilizando o Tomcat 4.1.12 com o MS Access como BD.

 

Alguma dica ?

 

Valeu, 

Marcio Tangerini