Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Received-SPF: neutral (hermes.apache.org: local policy)
Message-ID: <42A75BC3.1090506@luniks.net>
Date: Wed, 08 Jun 2005 22:57:39 +0200
From: =?ISO-8859-1?Q?Torsten_R=F6mer?= <torsten.roemer@luniks.net>
User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050322)
MIME-Version: 1.0
To: Tomcat Users List <tomcat-user@jakarta.apache.org>
Subject: Re: Tomcat 5.5.9: NamingException cannot be resolved or is not a
 type - JNDI, MySQL
References: <20050608194720.CC4E070000C3@mwinf1412.wanadoo.fr>
 <42A74C24.8080401@technologist.com>
In-Reply-To: <42A74C24.8080401@technologist.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Greg Brownell schrieb:
> I have.  Here is what I have at top of jsp:
> 
> <%@ page import="java.sql.*" %>
> <%@ page import="javax.sql.DataSource" %>
> <%@ page import="javax.naming.InitialContext" %>
> <%@ page import="javax.naming.Context" %>
> <%@ page import="java.io.File" %>

You are missing javax.naming.NamingException (or do javax.naming.*)

Torsten

> 
> Greg.
> 
> Arnaud HERITIER wrote:
> 
>> You must import the classes you use in your JSP :
>>
>> <%@ page import="{package.class | package.*}, ..." ...
>>
>> Arnaud
>>
>>
>>  
>>
>>> -----Message d'origine-----
>>> De : Greg Brownell [mailto:gwb@technologist.com] Envoy� : mercredi 8 
>>> juin 2005 21:34
>>> � : tomcat-user@jakarta.apache.org
>>> Objet : Tomcat 5.5.9: NamingException cannot be resolved or is not a 
>>> type - JNDI, MySQL
>>>
>>> I get the error below when trying to compile/execute a jsp that wants 
>>> to connect to a MySQL db named
>>>
>>> testdb.  Here's the code snippet from testdb.jsp:
>>>
>>>     InitialContext initCtx = null;
>>>     DataSource ds = null;
>>>     Connection conn = null;
>>>     Statement stmt = null;
>>>     ResultSet rset = null;
>>>     try {
>>>         initCtx = new InitialContext();
>>>
>>>         ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/testdb");
>>>         conn = ds.getConnection();
>>>        
>>>         stmt = conn.createStatement();
>>>         rset = stmt.executeQuery("select * from subscriber");
>>>
>>> It fails on the lookup with:
>>>
>>> org.apache.jasper.JasperException: Unable to compile class for JSP
>>>
>>> An error occurred at line: 52 in the jsp file: /testdb.jsp Generated 
>>> servlet error:
>>> NamingException cannot be resolved or is not a type
>>>
>>>
>>>     
>>> org.apache.jasper.compiler.DefaultErrorHandler.javacError(Defa
>>> ultErrorHandler.java:84)
>>>     
>>> org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDis
>>> patcher.java:328)
>>>     
>>> org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompil
>>> er.java:397)
>>>     org.apache.jasper.compiler.Compiler.compile(Compiler.java:288)
>>>     org.apache.jasper.compiler.Compiler.compile(Compiler.java:267)
>>>     org.apache.jasper.compiler.Compiler.compile(Compiler.java:255)
>>>     
>>> org.apache.jasper.JspCompilationContext.compile(JspCompilation
>>> Context.java:556)
>>>     
>>> org.apache.jasper.servlet.JspServletWrapper.service(JspServlet
>>> Wrapper.java:293)
>>>     
>>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet
>>> .java:291)
>>>     
>>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
>>>     javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>>>
>>> I am using MySQL 4.1.12a (Windows nt), Connector/J v 3.1.8 
>>> Connector/j stuff moved to common/lib
>>>
>>> Tomcat: under webapps, app name testdb.
>>> testdb/WEB-INF/web.xml:
>>> <?xml version="1.0" encoding="ISO-8859-1"?> <web-app 
>>> xmlns="http://java.sun.com/xml/ns/j2ee"
>>>   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>>   xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 
>>> http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
>>>   version="2.4">
>>>
>>> <display-name>testdb</display-name>
>>>   <description>
>>>     db test site
>>>   </description>
>>>
>>> <resource-ref>
>>>     <description>Tomcat DBCP</description>
>>>     <res-ref-name>jdbc/testdb</res-ref-name>
>>>     <res-type>javax.sql.DataSource</res-type>
>>>     <res-auth>Container</res-auth>
>>> </resource-ref>
>>> </web-app>
>>>
>>> conf/Catalina/localhost/testdb.xml:
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <Context
>>>  path="/Search"   docBase="Search"
>>>  debug="1"    crossContext="true"
>>>   reloadable="true">
>>> <ResourceLink name="jdbc/testdb" type="javax.sql.DataSource" 
>>> global="jdbc/testdb"/> </Context>
>>>
>>> conf/server.xml:
>>> <GlobalNamingResources>
>>>   <Environment
>>>     name="simpleValue"
>>>     type="java.lang.Integer"
>>>     value="30"/>
>>>   <Resource
>>>     auth="Container"
>>>     description="User database that can be updated and saved"
>>>     name="UserDatabase"
>>>     type="org.apache.catalina.UserDatabase"
>>>     pathname="conf/tomcat-users.xml"
>>>     factory="org.apache.catalina.users.MemoryUserDatabaseFactory"/>
>>> <Resource
>>>   name="jdbc/testdb"
>>>   auth="Container"
>>>   type="javax.sql.DataSource"
>>>   factory="org.apache.commons.dbcp.BasicDataSourceFactory"
>>>   username="xxxx"
>>>   password="yyyy"
>>>   removeAbandonedTimeout="60"
>>>   maxActive="4"
>>>   maxIdle="2"
>>>   removeAbandoned="true"
>>>   driverClassName="com.mysql.jdbc.Driver"
>>>   url="jdbc:mysql://localhost:3306/testdb?autoReconnect=true"/>
>>> </GlobalNamingResources>
>>>
>>> Any ideas why this doesn't work?
>>>
>>> By the way, I've tried moving the Resource lines in server.xml to 
>>> testdb.xml (the context file) and replaced the resource-link.  Same 
>>> error.
>>>
>>> Thanks in advance.
>>>
>>> Greg.
>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>>
>>>   
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>>  
>>
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org