try <%= rs.getString(i) %> instead of <% = rs.getString(i) %>
Bruno Armand wrote:
Please i try since one week to become this program without error, but without success. Perrhaps can you help me!
I write a jsp-file for calling and saving data from an access existing database which i connect with a odbc-driver. The adrList.jsp ist in the directory c:\eclipse\workspace\projectX\ I try to start it from tomcat with http://localhost:8080/student. The file HelloWorld.jsp in the same directory runs without problem.
Please here are:
1. The code of the adrList.jsp and
2. The displayed errormessage.
__________________________________-
1.
<html>
<head>
<%@ page language="java" import = "java.sql.*" %>
<%@ page import = "java.lang.*" %>
<% try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Properties props = new Properties();
props.setProperty("user", "");
props.setProperty("password", "");
String url =
"jdbc:odbc:http://localhost:8080:Bruno_Adress_odbc";;
Connection con = DriverManager.getConnection(url,
props);
String sql1 = "INSERT INTO Adressen (Nachname, Adresse," + " Postleitzahl, Land, Ort)" + " VALUES ('Bruno Armando', 'Am Vaihingen 20', '70187', " + "'Deutschland', 'Stuttgart')";
String sql2 = "INSERT INTO Adressen (Nachname,
Adresse,"+
" Postleitzahl, Land, Ort) " + "VALUES ('Becker Marlise', 'Koenigstr 78', '70174',
"+
"'Deutschland', 'Stuttgart')";
String query = "SELECT * FROM Adressen";
Statement stmt = con.createStatement();
stmt.executeUpdate(sql1);
stmt.executeUpdate(sql2);
ResultSet rs = stmt.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount(); %>
<title>Details-Adressen von den 5 Besten</title> </head> <BODY>
<TABLE width='80%' border=0 align='center'
cellSpacing=5 cellPadding=2 bgcolor="#0000FF"
bordercolor="#000000"> <tr>
<TD align=left> </TD> <TD align=right >
</TD>
<td> Name</td> <td> Street</td> <td> Zip</td> <td> Town</td> <td> Country</td> </tr>
<%
while (rs.next())
{
%>
<tr>
<TD align=left> </TD> <TD align=right > </TD>
<%
for (int i = 2; i <= columnCount; i++)
%>
<td>
<% = rs.getString(i) %>
</td>
<%
}
%>
</tr><br>
<%
}
rs.close();
stmt.close();
con.close();
} catch (SQLException ex) {
System.out.println("SQLException:");
while (ex != null)
{
System.out.println("SQLState: " +
ex.getSQLState());
System.out.println("Nachricht: " +
ex.getMessage());
System.out.println("Anbieter: " +
ex.getErrorCode());
ex = ex.getNextException();
System.out.println("");
}
%>
</table>
</body>
</html>
2. Errormessage:
HTTP Status 500 -
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: 106 in the jsp file: /adrList.jsp
Generated servlet error: [javac] Compiling 1 source file
C:\Programme\Apache Group\Tomcat
4.1\work\Standalone\localhost\student2\adrList_jsp.java:159:
illegal start of expression
= rs.getString(i) ^
An error occurred at line: 14 in the jsp file: /adrList.jsp
Generated servlet error:
C:\Programme\Apache Group\Tomcat
4.1\work\Standalone\localhost\student2\adrList_jsp.java:58:
'try' without 'catch' or 'finally'
try ^
An error occurred at line: 112 in the jsp file: /adrList.jsp
Generated servlet error: C:\Programme\Apache Group\Tomcat 4.1\work\Standalone\localhost\student2\adrList_jsp.java:186: illegal start of expression public static Connection getConnection() ^
An error occurred at line: 14 in the jsp file: /adrList.jsp
Generated servlet error: C:\Programme\Apache Group\Tomcat 4.1\work\Standalone\localhost\student2\adrList_jsp.java:61: cannot resolve symbol symbol : method getConnection () location: class org.apache.jsp.adrList_jsp Connection con = getConnection(); ^
An error occurred at line: 112 in the jsp file: /adrList.jsp
Generated servlet error:
C:\Programme\Apache Group\Tomcat
4.1\work\Standalone\localhost\student2\adrList_jsp.java:170:
cannot resolve symbol
symbol : variable rs location: class org.apache.jsp.adrList_jsp
rs.close();
^
An error occurred at line: 112 in the jsp file: /adrList.jsp
Generated servlet error:
C:\Programme\Apache Group\Tomcat
4.1\work\Standalone\localhost\student2\adrList_jsp.java:171:
cannot resolve symbol
symbol : variable stmt location: class org.apache.jsp.adrList_jsp
stmt.close();
^
An error occurred at line: 112 in the jsp file: /adrList.jsp
Generated servlet error:
C:\Programme\Apache Group\Tomcat
4.1\work\Standalone\localhost\student2\adrList_jsp.java:172:
cannot resolve symbol
symbol : variable con location: class org.apache.jsp.adrList_jsp
con.close();
^
7 errors
at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:130) at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:293) at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:353) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:370) at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:473) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:190) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:536)
________________________ Thank!
Bruno!
__________________________________________________________________
Gesendet von Yahoo! Mail - http://mail.yahoo.de Logos und Klingelt�ne f�rs Handy bei http://sms.yahoo.de
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
