<html><div style='background-color:'><DIV>Ok I am new to Linux, so please bear with me. I am running Red Hat 9 that comes with PostgreSQL7.3.2-3. </DIV>
<DIV> </DIV>
<DIV>I have created a "test" database and am trying to access it using a java program through jdbc. </DIV>
<DIV>I am recieving and error: "Exception! java.lang.ClassNotFoundException: postgresql.Driver"</DIV>
<DIV> </DIV>
<DIV>I have my CLASSPATH set to point to pg73b1jdbc1.jar, pg73b1jdbc2.jar and pg73b1jdbc3.jar.</DIV>
<DIV> </DIV>
<DIV>I am reading a HOW TO for jdbc and PostgreSQL From <A href="http://tldp.org/HOWTO/Enterprise-Java-for-Linux-HOWTO-6.html">http://tldp.org/HOWTO/Enterprise-Java-for-Linux-HOWTO-6.html</A> but this is for version 6.5, do I need to do anything else?</DIV>
<DIV> </DIV>
<DIV>here is my java code:</DIV>
<DIV>import java.sql.*;<BR><BR>class PostgreSQLTest {<BR> public static void main (String[] args) {<BR> try {<BR> Driver driver = (Driver)<BR> Class.forName("postgresql.Driver").newInstance();<BR> DriverManager.registerDriver(driver);<BR><BR> String url = "jdbc:postgresql:javatest"; <BR> Connection con = DriverManager.getConnection(url, "postgres", ""); <BR> Statement stm = con.createStatement(); <BR> <BR> stm.setQueryTimeout(10); <BR> ResultSet rs = stm.executeQuery("select col1 from test"); <BR> <BR> rs.next(); <BR> <BR> System.out.println(rs.getString(1)); <BR> <BR> } catch (SQLExcept
ion e) { <BR> <BR> System.out.println("Exception!"); <BR> System.out.println(e.toString()); <BR> } <BR>} <BR></DIV></div><br clear=all><hr>Tired of spam? Get <a href="http://g.msn.com/8HMLENUS/2734??PS=">advanced junk mail protection</a> with MSN 8.</html>