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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-jdbc pgsql-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

Browse pgsql-interfaces by date

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

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Eisentraut 2001-03-25 20:35:31 Re: Compiling
Previous Message Peter Mount 2001-03-25 18:03:34 Re: Compiling

Browse pgsql-novice by date

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