RE: couldn't load DB driver : null
От | Peter Mount |
---|---|
Тема | RE: couldn't load DB driver : null |
Дата | |
Msg-id | 1B3D5E532D18D311861A00600865478CF1B191@exchange1.nt.maidstone.gov.uk обсуждение исходный текст |
Ответ на | couldn't load DB driver : null ("S.A.Pamungkas" <moenk_2000@yahoo.com>) |
Список | pgsql-interfaces |
Looking at your code, the "Couldn't load DB driver" message is being generated by a ClassNotFound exception being thrown. This would indicate that the org.postgresql.Driver class is not being found in the CLASSPATH. That's probably what's going wrong here. Peter -- Peter Mount Enterprise Support Maidstone Borough Council Any views stated are my own, and not those of Maidstone Borough Council -----Original Message----- From: S.A.Pamungkas [mailto:moenk_2000@yahoo.com] Sent: Monday, July 31, 2000 12:40 PM To: pgsql-interfaces@postgresql.org Subject: [INTERFACES] couldn't load DB driver : null Before, I can connect database both from applet or servlet.But today, when I try to connect database from applet or servlet, there was a problem. By servlet the error message is : "Couldn't load DB driver :null". By applet, in the browser just appear "Connecting to database ", and in the status bar is a message "Applet myapplet org/postgresql/jdbc2/Resultset". Help me please...... The SERVLET code : import java.io.*;import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class myServlet extends HttpServlet { public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { Connection con = null;Statement stmt = null; ResultSet rs = null; res.setContentType("text/html"); PrintWriter out = res.getWriter(); try[ Class.forName("org.postgresql.Driver"); con = DriverManager.getConnection("jdbc:postgresql:myDB", "me", "pass"); stmt = con.createStatement(); rs = stmt.executeQuery("select k_id, k_name, date from myTable"); out.println("<HTML><HEAD><TITLE>KAMOKU</TITLE></HEAD>"); out.println("<BODY><FONT COLOR='RED'><H3><BR>TEST SERVLET & JDBC</H3><BR></FONT>"); out.println("SELECT id, name, date FROM kamoku<BR><BR> "); out.println("<UL>"); while(rs.next()){ out.println("<LI>" + rs.getString("k_id")+" "+ rs.getString("k_name") + " " + rs.getDate("date")); } out.println("<UL>"); out.println("</BODY></HTML>"); } catch(ClassNotFoundException e) { out.println("Couldn't loadDB driver : " + e.getMessage()); } catch(SQLException e) { out.println("SQLException caught : " + e.getMessage()); } finally { try { if (con != null) con.close(); } catch (SQLException ignored) { } } } } Thank you. S.A.Pamungkas __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/
В списке pgsql-interfaces по дате отправления: