Re: [INTERFACES] JDBC driver and postgreSQL

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(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)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(at)maidstone(dot)gov(dot)uk