Re: [enterprise-list] DataSource + Tomcat + Access

Andrï¿½ Marinho Thu, 09 Jan 2003 15:49:26 -0800

Verifica se no server.xml o <Resource></Resource> estï¿½ dentro do <Context></Context> onde roda o teu servlet ???

Comigo resolveu desta forma.

Andrï¿½ Marinho

----- Original Message -----

From: Tangerini, Marcio

To: [EMAIL PROTECTED]

Sent: Thursday, January 09, 2003 11:38 AM

Subject: [enterprise-list] DataSource + Tomcat + Access

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

Re: [enterprise-list] DataSource + Tomcat + Access

Responder a