Connecting a Postgres Database from a Java application

Paulo Góes · 04-01-2003, 02:54 PM

How can I connect a Postgres Database from a Java application? Someone could help me describing a step-by-step set of instructions about how to do it? In my machine is installed Postgres 7.2.3 and JSDK 1.4.1

Thanks

mcleodnine · 04-01-2003, 03:03 PM

Moved to the 'Programming' forum
.

Tinkster · 04-01-2003, 08:20 PM

Have you looked at the PostgreSQL
documentation, Chapter 5 of the
Programmer's Guide in particular?

Cheers,
Tink

jdruin · 08-14-2003, 10:14 AM

Hello.

1. set up the postgresql.conf file to allow tcpip connections
2. set up the pg_hba.conf file to allow your network to connect
3. restart postgres with the "-i" option to allow intranet connection
4. follow instrctions the java obdc chapter at http://www.postgresql.org/docs/7.3/i...tive/jdbc.html

german · 08-23-2003, 10:08 AM

I would highly recommend NOT using ODBC in java, ever, ever, ever. It destroys the platform neutrality of JDBC, and this is, after all, a Linux forum. Just put the postgres JDBC driver on the classpath, and use standard JDBC calls.

http://java.sun.com/docs/books/tutorial/jdbc/basics/

that should help you along.

HTH

B.