From: | "S(dot)A(dot)Pamungkas" <moenk_2000(at)yahoo(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | RE: couldn't load DB driver : null |
Date: | 2000-07-31 12:15:56 |
Message-ID: | 20000731121556.18433.qmail@web4904.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)it(dot)maidstone(dot)gov(dot)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(at)yahoo(dot)com]
> Sent: Monday, July 31, 2000 12:40 PM
> To: pgsql-interfaces(at)postgresql(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Phil Davis | 2000-07-31 12:18:05 | JDBC getRow returns 0 after first instead of 1 |
Previous Message | Peter Mount | 2000-07-31 11:48:25 | RE: couldn't load DB driver : null |