Re: JDBC in Red hat 9

<div style="background-color:"><div><p>ok, <p>I updated the CLASSPATH to have pgb1jdbc2.jar, and modfied my code to say
"Class.forName("org.postgresql.Driver").newInstance();"<p>but I am still getting the error "Exception!
java.lang.ClassNotFoundException:org.postgresql.Driver" <br /><br /></div><div></div>----Original Message Follows----
<div></div>From:Barry Lind  <div></div>To: Joseph Thomas  <div></div>CC: pgsql-jdbc@postgresql.org <div></div>Subject:
Re:[JDBC] JDBC in Red hat 9 <div></div>Date: Wed, 28 May 2003 21:58:02 -0700 <div></div><div></div>Joseph,
<div></div><div></div>Twothings wrong that I can see: <div></div><div></div>1) The driver class is now
org.postgresql.Driver(not postgresql.Driver) <div></div>2) You only include one of the jar files in the classpath (the
onethat corresponds to the version of java/jdbc you are running: jdbc1 = jdk1.1, jdbc2= jdk1.2 and 1.3, jdbc3= jdk1.4
<div></div><div></div>thanks,<div></div>--Barry <div></div><div></div><div></div>Joseph Thomas wrote: <div></div>>Ok
Iam new to Linux, so please bear with me. I am running Red Hat 9 <div></div>>that comes with PostgreSQL7.3.2-3.
<div></div>>I have created a "test" database and am trying to access it using <div></div>>a java program through
jdbc.<div></div>>I am recieving and error: "Exception! <div></div>>java.lang.ClassNotFoundException:
postgresql.Driver"<div></div>> I have my CLASSPATH set to point to pg73b1jdbc1.jar, <div></div>>pg73b1jdbc2.jar
andpg73b1jdbc3.jar. <div></div>> I am reading a HOW TO for jdbc and PostgreSQL From
<div></div>>http://tldp.org/HOWTO/Enterprise-Java-for-Linux-HOWTO-6.htmlbut <div></div>>this is for version 6.5,
doI need to do anything else? <div></div>> here is my java code: <div></div>>import java.sql.*; <div></div>>
<div></div>>classPostgreSQLTest { <div></div>> public static void main (String[] args) { <div></div>> try {
<div></div>>Driver driver = (Driver) <div></div>> Class.forName("postgresql.Driver").newInstance();
<div></div>>DriverManager.registerDriver(driver); <div></div>> <div></div>> String url =
"jdbc:postgresql:javatest";<div></div>> Connection con = DriverManager.getConnection(url, "postgres",
<div></div>>"");<div></div>> Statement stm = con.createStatement(); <div></div>> <div></div>>
stm.setQueryTimeout(10);<div></div>> ResultSet rs = stm.executeQuery("select col1 from test"); <div></div>>
<div></div>>rs.next(); <div></div>> <div></div>> System.out.println(rs.getString(1)); <div></div>>
<div></div>>} catch (SQLExcept ion e) { <div></div>> <div></div>> System.out.println("Exception!");
<div></div>>System.out.println(e.toString()); <div></div>> } <div></div>>} <div></div>>
<div></div>>------------------------------------------------------------------------<div></div>>Tired of spam?
Getadvanced junk mail protection <div></div>> with MSN 8.
<div></div><div></div><div></div><div></div>---------------------------(endof broadcast)---------------------------
<div></div>TIP5: Have you checked our extensive FAQ? <div></div><div></div>http://www.postgresql.org/docs/faqs/FAQ.html
<div></div></div><brclear="all" /><hr />Tired of spam? Get <a href="http://g.msn.com/8HMHENUS/2734??PS=">advanced junk
mailprotection</a> with MSN 8.