From: | Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk> |
---|---|
To: | "'S(dot)A(dot)Pamungkas'" <moenk_2000(at)yahoo(dot)com>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | RE: couldn't load DB driver : null |
Date: | 2000-07-31 11:48:25 |
Message-ID: | 1B3D5E532D18D311861A00600865478CF1B191@exchange1.nt.maidstone.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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/
From | Date | Subject | |
---|---|---|---|
Next Message | S.A.Pamungkas | 2000-07-31 12:15:56 | RE: couldn't load DB driver : null |
Previous Message | S.A.Pamungkas | 2000-07-31 11:39:43 | couldn't load DB driver : null |