Message-ID: <20010325181224.19601.qmail@web3305.mail.yahoo.com>
Date: Sun, 25 Mar 2001 10:12:23 -0800 (PST)
From: =?iso-8859-1?q?Seema=20Noor?= <seema_56@yahoo.com>
Subject: Problem in PostgreSQL - jdbc 
To: pgsql-novice@postgresql.org, pgsql-jdbc@postgresql.org,
	pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

I want to know how to use jdbc for postgresql in red
hat linux 7.0. I have installed red hat linux 7.0
completely and there are four jdbc.jar files of
different version.There are no postgresql.jar and
finder.jar files. I found two different methods for
jdbc interface:

1) Just set the path   
   CLASSPATH=$CLASSPAH /usr/lib/pgsql/jdbc6.5.1.2.jar
   and compile the program.

   But when I compiled the program using jdk1.1.2   
   there was an exception CLASSNOTFOUND. When this 
   exception was caught it gave the error message 
   "postgresql/driver"
   How do I set the driver? I used the statements:

   Driver driver = (Driver)Class.forName  
   ("postgresql.Driver").newInstance();      
   
   DriverManager.registerDriver(driver);

   String     url = "jdbc:postgresql:jtest"; 
   
   Connection con = DriverManager.getConnection 
   (url, "postgres", "postgres"); 
   
   Statement  stm = con.createStatement(); 

   Do I have to use "org.postgresql.Driver" instead 
   of "postgresql.Driver"?


2)  Change to directory src/interface/jdbc and type:
    % make 
    to get postgresql.jar and then set the class path 
    to:
    
export CLASSPATH    =
/usr/local/lib/finder.jar:/usr/local/lib/
postgresql.jar:.java uk.org.retep.finder.Main

    This src/interface/jdbc is not in any of the   
    postgresql directories (installed from red hat  
    linux 7.0)I therefore downloaded 
    postgresql-7.0.2.tar but some classes were missing

    in it. 
    If I'll succeed in getting postgresql.jar from 
    this method then how will I get finder.jar?    

I found in the same mailing list to rename jdbc6.5.1.2
.jar to postgresql.jar and then set the CLASSPATH. But
it also didn't work out.

Can someone please help me?


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/