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 по дате отправления: