Tenho instalado o TonCat 5.0 e o MySQL 4.1.7 rodo um teste de configuração e recebo uma mensagem de erro.
Muito grato a quem puder ajudar.
Segue o teste e o erro
[color=“orange”][size=“18”]TESTE:[/size][/color]
<%@ page import=“java.sql.*” %>
<html><body>
<b>Seus usuários são:</b><br>
<%
String cURL = “jdbc:mysql://localhost:3306/mysql?useUnicode=true”;
Class.forName(“org.gjt.mm.mysql.Driver”).newInstance();
Connection con = DriverManager.getConnection(cURL, “”, “”);
Statement stm = con.createStatement();
ResultSet res = stm.executeQuery(“select user from user”);
While (res.next()) {
out.println(res.getString(“user”)+"<br>");
}
res.close();
%>
</body></html>
[size=“18”][color=“red”]ERRO:[/color][/size]
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 4 in the jsp file: /Teste1.jsp
Generated servlet error:
C:\Arquivos de programas\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\dev\org\apache\jsp\Teste1_jsp.java:52: ‘;’ expected
While (res.next()) {
^
1 error
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
