From: Keith/Suzanne Barron <keith@barron.com>
To: pgsql-interfaces@postgresql.org
Subject: Problem loading jdbc driver in servlet, but not in program
Date: Sat, 15 May 1999 09:24:56 -0700
Message-ID: <373D9FD8.198A35D5@barron.com> (raw)
I have two simple programs, one is a regular java program, the other
is a java servlet.
When I try to run the servlet, I get "Could not load database driver".
Any ideas on why this
happens?
-Keith
Here are the programs:
1. regular java program:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DBPhoneLookup {
public static void main (String args[]) throws
ClassNotFoundException, FileNotFoundException, IOException,
SQLException {
try {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String url = "jdbc:postgresql:school";
String usr = "postgres";
String pwd = "postgres";
// Load (and therefore register) the Postgres driver
Class.forName("postgresql.Driver");
// Get a connection to the database
con = DriverManager.getConnection(url, usr, pwd);
// Create a Statement object
stmt = con.createStatement();
// Execute an SQL query, get a ResultSet
rs = stmt.executeQuery("Select first_name from students");
// Display the result set as a list
while (rs.next()) {
System.out.println(rs.getString("first_name"));
}
con.close();
}
catch(ClassNotFoundException e) {
System.out.println("Could not load database driver: " +
e.getMessage());
}
}
}
2. servlet program:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DBPhoneLookup
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 {
String url = "jdbc:postgresql:school";
String usr = "postgres";
String pwd = "postgres";
// Load (and therefore register) the Postgres driver
Class.forName("postgresql.Driver");
// Get a connection to the database
con = DriverManager.getConnection(url, usr, pwd);
// Create a Statement object
stmt = con.createStatement();
// Execute an SQL query, get a ResultSet
rs = stmt.executeQuery("Select first_name from students");
// Display the result set as a list
out.println("");
out.println("");
out.println("");
while (rs.next()) {
out.println(" " + rs.getString("first_name"));
}
out.println(" ");
}
catch(ClassNotFoundException e) {
out.println("Could not load database driver: " +
e.getMessage()); }
catch(SQLException e) {
out.println("SQLException caught: " + e.getMessage()); }
finally {
// Always close the database connection
try { if (con != null) con.close(); }
catch (SQLException ignored) { }
}
}
}
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: keith@barron.com
Subject: Re: Problem loading jdbc driver in servlet, but not in program
In-Reply-To: <373D9FD8.198A35D5@barron.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox