Why class not found?
От | Michael Hanna |
---|---|
Тема | Why class not found? |
Дата | |
Msg-id | 3575524A-B75B-11D6-A0A7-00039308EB2C@hwcn.org обсуждение исходный текст |
Ответы |
Re: Why class not found?
("Nick Fankhauser" <nickf@ontko.com>)
|
Список | pgsql-jdbc |
OK, thanks to all regarding my previous Exceptions question. New problem: I'm getting a ClassNotFoundException from this line: Class.forName("org.postgresql.Driver"); //load the driver However I do import this package and I'm certain it's in my classpath: [taoki:~] michael% $CLASSPATH /System/Library/Frameworks/JavaVM.framework/Versions/1.3.1/Classes/classes. jar:/usr/local/jakarta- tomcat-4.0.3/common/lib/servlet.jar:/usr/local/pgsql/share/java/pgjdbc2.jar: ./: Command not found. [taoki:~] michael% Also that HelloPostgresql.class by Mr. Fankhauser works fine.. Any ideas... here's the whole code: -- Rigby.java -- // Copyright Michael Hanna 2002 // do not use without permission of author import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; // All we need for JDBC public class Rigby extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response)throws IOException, ServletException { PrintWriter out; DBThing dbt; ResultSet results; String database = "rigby"; String username = "postgres"; String password = "postgres"; response.setContentType("text/html"); out = response.getWriter(); out.println("<html>"); out.println("<body>"); out.println("<head>"); out.println("<title>Rigby</title>"); out.println("</head>"); out.println("<body>"); out.println("<h1>Contents of friends:</h1>"); try { Class.forName("org.postgresql.Driver"); //load the driver out.println("<B>Inside try</B>"); dbt = new DBThing(database, username, password); results = dbt.queryDB("select * from friends"); if (results != null) { out.println("<B>id" + "First Name" +"Surname" + "Email" + "Phone"+"Bday</B>"); while (results.next()) { out.println(results.getInt("id") + results.getString("firstname") + results.getString("surname")+ results.getString("email")+results.getInt("tel")+results.getString("date") + "\n"); } } else { out.println("The friends database is empty.<br>"); } results.close(); } catch (ClassNotFoundException cnf) { out.println("***Exception:\n"+cnf); cnf.printStackTrace(); } catch (SQLException se) { out.println("***Exception:\n"+se); se.printStackTrace(); } out.println("hey2"); out.println("</body>"); out.println("</html>"); /* try { new DBThing(database, user, password); } catch (ClassNotFoundException cnfe) { throw new IOException("Could not instantiate driver: " + cnfe.getMessage()); } catch (SQLException se) { throw new IOException("Unable to connect to database or work with it: " + se.getMessage()); } */ } } -- DBThing.java -- // Copyright Michael Hanna 2002 // do not use without permission of author import java.sql.*; // All we need for JDBC import java.lang.*; public class DBThing { Connection db; // A connection to the database Statement sql; // Our statement to run queries with DatabaseMetaData dbmd; // This is basically info the driver delivers // about the DB it just connected to. I use // it to get the DB version to confirm the // connection in this example. public DBThing(String database, String username, String password) throws ClassNotFoundException, SQLException { Class.forName("org.postgresql.Driver"); //load the driver db = DriverManager.getConnection("jdbc:postgresql:"+database, username, password); //connect to the db dbmd = db.getMetaData(); //get MetaData to confirm connection System.out.println("Connection to "+dbmd.getDatabaseProductName()+" "+ dbmd.getDatabaseProductVersion()+" successful.\n"); sql = db.createStatement(); //create a statement that we can use later } public ResultSet queryDB(String query) throws SQLException { ResultSet rs; rs = sql.executeQuery(query); // try to query DB return rs; } }
В списке pgsql-jdbc по дате отправления: