Обсуждение: JDBC driver and postgreSQL

Поиск
Список
Период
Сортировка

JDBC driver and postgreSQL

От
Agus Mingtarja
Дата:
Hi All,
i have postgresql 6.3.2 (Linux 2.0 debian) istalled, and i can make
database now. My question ist:
How can i install the JDBC driver? (i use JDK 1.1.5)
Ist my programm below correct?

...
try
      {  Class.forName("postgresql.driver");
         // force loading of driver
         String url = "jdbc:postgresql://localhost/database";
         String user = "nobody";
         String password = "password";
         Connection con = DriverManager.getConnection(url, user,
password);
         Statement stmt = con.createStatement();
...

that's all. Please give me a tip. Thank You for the tip!


--


 Agus MINGTARJA  ..........................
  RWTH-Aachen GERMANY  .....................
   mingtarja@hdz-ima.RWTH-Aachen.de  ........
    http://www.geocities.com/Athens/8668/  ...

Re: [INTERFACES] JDBC driver and postgreSQL

От
Peter T Mount
Дата:
On Wed, 6 May 1998, Agus Mingtarja wrote:

> Hi All,
> i have postgresql 6.3.2 (Linux 2.0 debian) istalled, and i can make
> database now. My question ist:
> How can i install the JDBC driver? (i use JDK 1.1.5)

To install, put the postgresql.jar into your classpath.

There are instructions in the README, and in the FAQ

      http://www.retep.org.uk/postgres

> Ist my programm below correct?

Looks ok, except drop the second : in the JDBC URL. It should only be
there if a non standard port number is also given

>
> ...
> try
>       {  Class.forName("postgresql.driver");
>          // force loading of driver
>          String url = "jdbc:postgresql://localhost/database";

           String url = "jdbc:postgresql//localhost/database";

>          String user = "nobody";
>          String password = "password";
>          Connection con = DriverManager.getConnection(url, user,
> password);
>          Statement stmt = con.createStatement();
> ...
>
> that's all. Please give me a tip. Thank You for the tip!

--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk