tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bruno Armand <narbrun2...@yahoo.de>
Subject jdbcodbc database connection problem (access-DB,jsp,tomcat,eclipse)!
Date Wed, 03 Sep 2003 15:01:10 GMT
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>&nbsp; </TD> 
    <TD align=right > 
     &nbsp;
    </TD> 

<td> Name</td>
<td> Street</td>
<td> Zip</td>
<td> Town</td>
<td> Country</td>
</tr>

<%
while (rs.next())
{
%>
<tr>
 <TD align=left>&nbsp; </TD> 
 <TD align=right > &nbsp; </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

Mime
View raw message