Received: from web4904.mail.yahoo.com (web4904.mail.yahoo.com
 [216.115.106.29])
	by hub.org (8.10.1/8.10.1) with SMTP id e6VCG2B98218
	for <pgsql-interfaces@postgresql.org>;
	Mon, 31 Jul 2000 08:16:02 -0400 (EDT)
Message-ID: <20000731121556.18433.qmail@web4904.mail.yahoo.com>
Received: from [133.15.144.14] by web4904.mail.yahoo.com;
	Mon, 31 Jul 2000 05:15:56 PDT
Date: Mon, 31 Jul 2000 05:15:56 -0700 (PDT)
From: "S.A.Pamungkas" <moenk_2000@yahoo.com>
Subject: RE: couldn't load DB driver : null
To: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Archive-Number: 200007/224

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/