I think the following mail to you describes everything that you need
to connect to database with java. If something is not working, check your
pg_hba.conf file and start postmaster with the -i option. You could use the
following command for that
pg_ctl -o "-i" start
From: Raghunath T
Sent: Wed 4/4/2001 9:41 PM
To: Gabriel García
Subject: RE: [JDBC] How connect JDBC
you'll have to first build the jdbc driver. Typically it would be
For this you go to postgresql-7.0.2/src/interfaces/jdbc and then type
make jdbc1 or make jdbc2 (if you need j2se support)
This will give you postgresql.jar file
update ur classpath env variable to include the full path of
Then in your code add
java.sql.Connection conn =
host ip : is the ip address of the host. could be something like
port : usually it is 5432 unless you are running postmaster on some
If your java code is on the same machine as your database then you
need not give ip and port.
You could just say "jdbc:postgresql:<dbname>"
I hope this should be sufficient :-))
From: Gabriel García
Sent: Wed 4/4/2001 9:18 PM
Subject: [JDBC] How connect JDBC
I have a program's java, and I need read a Postgres database, How I can call
the database from java.
Thanks in advance.
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
pgsql-jdbc by date
|Next:||From: Peter T Mount||Date: 2001-04-06 07:32:10|
|Subject: Re: WG: JDBC 2.0 Scrollable Result Sets -- Slightly going mad --|
|Previous:||From: Knud Alex Mueller||Date: 2001-04-05 17:30:55|
|Subject: WG: JDBC 2.0 Scrollable Result Sets -- Slightly going mad --|