By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,541 Members | 1,476 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,541 IT Pros & Developers. It's quick & easy.

Question about connection java and Postgresql in Linux

P: n/a
DN
I am trying to use Redhat Linux 9, J2sdk 1.4.2 and Postgresql 7.3.2 to
do my setting. But, I cannot access the database to set/get data
through the java program. Please help give me some suggestions.
Here is what my setting and problems:
http://hk.geocities.com/daisy_nhy/java_postgresql2.html

Thanks
Nov 11 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

On 20/09/2003 15:23 DN wrote:
I am trying to use Redhat Linux 9, J2sdk 1.4.2 and Postgresql 7.3.2 to
do my setting. But, I cannot access the database to set/get data
through the java program. Please help give me some suggestions.
Here is what my setting and problems:
http://hk.geocities.com/daisy_nhy/java_postgresql2.html

Thanks

The postgreSQL .jar file must go in common/lib _not_ share/lib. Two other
things:

1) have you enabled tcpip on the postmaster by seting

tcpip_socket = true

in /var/lib/pgsql/data/postgresql.conf

2) have you edited /var/lib/pgsql/data/pg_hba.conf to un-comment the line

# host all all 127.0.0.1 255.255.255.255 trust

because if you haven't done both of these, you won't be able to connect
from Java.

And before anybody jumps in, I'll just point out that the "host" line is
far too permissive to be used in production but if you're just starting
out experimenting with PostgreSQL and Java, it's one less thing to have to
worry about for now.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #2

P: n/a
DN
Thank you for answering my question

I have moved postgresql.jar to common/lib.

Also, my setting are:
tcpip_socket = true
in /var/lib/pgsql/data/postgresql.conf

host all all 127.0.0.1 255.255.255.255 crypt
in /var/lib/pgsql/data/pg_hba.conf

but, it also cannot work well.
By the way, do I need to set
./configure with-java

if yes, how can I set it?
Nov 11 '05 #3

P: n/a

On 21/09/2003 09:30 DN wrote:
Thank you for answering my question

I have moved postgresql.jar to common/lib.

Also, my setting are:
tcpip_socket = true
in /var/lib/pgsql/data/postgresql.conf

host all all 127.0.0.1 255.255.255.255 crypt
in /var/lib/pgsql/data/pg_hba.conf

but, it also cannot work well.
By the way, do I need to set
./configure with-java

if yes, how can I set it?


../configure is used to build PostgreSQL from source. It doesn't affect any
of the run-time settings.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 11 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.