Do you have any errors in the tomcat logs?
Does your debug in the SQLException catch clause get written to std out or catalina.out?
If a SQLException did get thrown during the inserts/select the output would be:
<html> <head> </table> </body> </html>
Not quite sure how that would be rendered in a browser.
Are you sure you can load the jdbc driver? A ClassNotFoundException can be thrown from Class.forName(...)
Are you sure you are getting a connection to the database? Is your connection url correct? Also, the JdbcOdbcBridge has always been flaky at best.
I would recommend removing as much java code as possible from the jsp and use Beans or taglibs for the database access. It should make the jsp code a lot cleaner. For another thing it makes testing a lot easier :)
HTH,
Jon
Bruno Armand wrote:
Now,
i correct all the errors (As you see n the code below), but the jsp-page ist displayed, but without anything written (from html or database.). Can you know why please?
Thank!
--- Jon Wingfield <[EMAIL PROTECTED]> schrieb:
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");
String username = ""; String password = ""; String url = "jdbc:odbc:Bruno_Adress_odbc"; Connection con = DriverManager.getConnection(url, username,password);
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>
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
