RE: couldn't load DB driver : null

From: "Joe Shevland" <shevlandj(at)kpi(dot)com(dot)au>
To: "Peter Mount" <petermount(at)it(dot)maidstone(dot)gov(dot)uk>, "'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-08-01 02:34:31
Message-ID: MJEMLFCFPOPOFFFLIIDGOEIACCAA.shevlandj@kpi.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

This is correct; in JServ there's a jserv.properties file with the classpath settings, in Tomcat, you can put the postgresql.jar file under ./webapps/<app_name>/WEB-INF/lib to have it included automatically.

Cheers,
Joe

>-----Original Message-----
>From: pgsql-interfaces-owner(at)hub(dot)org
>[mailto:pgsql-interfaces-owner(at)hub(dot)org]On Behalf Of Peter Mount
>Sent: Monday, 31 July 2000 10:22 PM
>To: 'S.A.Pamungkas'; pgsql-interfaces(at)postgresql(dot)org
>Subject: RE: [INTERFACES] couldn't load DB driver : null
>
>
>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(at)yahoo(dot)com]
>Sent: Monday, July 31, 2000 1:16 PM
>To: pgsql-interfaces(at)postgresql(dot)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(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/
>

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message S.A.Pamungkas 2000-08-01 07:30:29 RE: couldn't load DB driver : null
Previous Message Tim Uckun 2000-08-01 02:06:48 Re: Access and Postgres question.