tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bruno Armand <narbrun2...@yahoo.de>
Subject Re: jdbcodbc database connection problem (access-DB,jsp,tomcat,eclipse)!
Date Wed, 03 Sep 2003 20:00:42 GMT
Hello Jon,

In the file tomcat../log/stdout,
this error information can be found:
"
SQLException:
SQLState: IM002
Nachricht: [Microsoft][ODBC Driver Manager] Der
Datenquellenname wurde nicht gefunden, und es wurde
kein Standardtreiber angegeben.
Anbieter: 0
there was error
"

By testing myself, i realise that, after the
Connection con = .... statement, no html-code can be
displayed. But before it, it`s possible.
The problem is now to know to make the connection to
the database correctly. But at this level, i don`t
have so many experience, only because i am a
beginner...

I hope you understand what i mind.

Thank!

Bruno

 --- Jon Wingfield <jon.wingfield@mkodo.com> schrieb:
> Very difficult to tell ;)
> 
> 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 <jon.wingfield@mkodo.com>
> 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>&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>
> 
=== message truncated === 

__________________________________________________________________

Gesendet von Yahoo! Mail - http://mail.yahoo.de
Logos und Klingeltöne fürs Handy bei http://sms.yahoo.de

Mime
View raw message