Skip site navigation (1) Skip section navigation (2)

Problem in PostgreSQL - jdbc

From: Seema Noor <seema_56(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Problem in PostgreSQL - jdbc
Date: 2001-03-25 18:12:23
Message-ID: 20010325181224.19601.qmail@web3305.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-jdbcpgsql-novice
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/

Responses

pgsql-novice by date

Next:From: Aaron BrashearsDate: 2001-03-25 22:06:22
Subject: Re: [JDBC] Problem in PostgreSQL - jdbc
Previous:From: Tom LaneDate: 2001-03-25 16:48:07
Subject: Re: On Postgres and permissions, cant read a file into a table

pgsql-interfaces by date

Next:From: Peter EisentrautDate: 2001-03-25 20:39:09
Subject: Re: pgmonitor on solaris
Previous:From: Paul MateosDate: 2001-03-25 04:50:38
Subject: ODBC Driver Needed

pgsql-jdbc by date

Next:From: Peter EisentrautDate: 2001-03-25 20:35:31
Subject: Re: Compiling
Previous:From: Peter MountDate: 2001-03-25 18:03:34
Subject: Re: Compiling

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group