RE: couldn't load DB driver : null
От | Peter Mount |
---|---|
Тема | RE: couldn't load DB driver : null |
Дата | |
Msg-id | 1B3D5E532D18D311861A00600865478CF1B195@exchange1.nt.maidstone.gov.uk обсуждение исходный текст |
Ответ на | couldn't load DB driver : null ("S.A.Pamungkas" <moenk_2000@yahoo.com>) |
Ответы |
RE: couldn't load DB driver : null
|
Список | pgsql-interfaces |
I think servlets don't use CLASSPATH. An alternative is to place the jar file into the lib/rt directory. That way, it's always available to the JVM regardless of any classpath setting. 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 1:16 PM To: pgsql-interfaces@postgresql.org Subject: RE: [INTERFACES] couldn't load DB driver : null 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 по дате отправления: