Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem in PostgreSQL - jdbc

Problem in PostgreSQL - jdbc

From
Seema Noor
Date:
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/

Re: [INTERFACES] Problem in PostgreSQL - jdbc

From
PostgreSQL Server
Date:
On Sun, 25 Mar 2001, Seema Noor wrote:

> 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/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>



try


org.postgresql.Driver


leonel

Re: [JDBC] Problem in PostgreSQL - jdbc

From
Aaron Brashears
Date:
On Sun, Mar 25, 2001 at 10:12:23AM -0800, Seema Noor wrote:
>    Do I have to use "org.postgresql.Driver" instead
>    of "postgresql.Driver"?

Yes.

Perhaps if you had typed the 4 extr characters in your code and
recompiled, you would have found this out.