RE: couldn't load DB driver : null
| От | S.A.Pamungkas |
|---|---|
| Тема | RE: couldn't load DB driver : null |
| Дата | |
| Msg-id | 20000731121556.18433.qmail@web4904.mail.yahoo.com обсуждение исходный текст |
| Ответ на | couldn't load DB driver : null ("S.A.Pamungkas" <moenk_2000@yahoo.com>) |
| Список | pgsql-interfaces |
Thank you.
But I already put the postgresql.jar file in the
CLASSPATH like this :
export CLASSPATH=.:/usr/local/lib/postgresql.jar
And, when I try againt ten minutes ago, applet could
connect the database ( by appletviewer ), but servlet
couldn't.
S.A.Pamungkas
--- Peter Mount <petermount@it.maidstone.gov.uk>
wrote:
> 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 load DB 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/
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
В списке pgsql-interfaces по дате отправления: