JDBC fails while used from remote machine...

From: "Zhou, Lixin" <LZhou(at)illumina(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: JDBC fails while used from remote machine...
Date: 2000-05-04 00:11:05
Message-ID: 7711BB513213D4118E3700B0D0220F7902C0E5@ILLUMINA4
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

From Windows NT, I have a problem to connect to my PostgreSQL 6.5.2 server
running on an i386-based Linux, Red Hat 6.1, using JDBC. The java class I
used for testing was from the src/interfaces/jdbc/example/basic.java.

First of all, I know postmater runs with -i turned on. The standard
port number was used.

Secondly, I have $PGDAT/pg_hba.conf set up to allow everyone from my subnet
to connect to the server.

# pg_hba.conf
host all 192.168.50.158 255.255.255.255 trust
host all 192.168.50.0 255.255.255.0 trust

Everything runs okay on Linux machine using JDK1.1.8.

I copied the jdbc6.5-1.2.jar to my NT machine. While I run the "basic",
it failed. Jdk1.2 was used on the NT.

What's the problem?

Lixin
lzhou(at)illumina(dot)com

==============================================
I ran from 192.168.50.61 (Linux, Red Hat 6.1), and it worked.

Here is the log.
==============================================

Script started on Wed May 3 16:41:02 2000
6$ java basic jdbc:postgresql://192.168.50.61:5432/lixinz lixinz ""
PostgreSQL basic test v6.3 rev 1

Connecting to Database URL = jdbc:postgresql://192.168.50.61:5432/lixinz
Connected...Now creating a statement

Running tests:
Updated 3 rows
performing a query
a=1 b=8
a=2 b=8
a=3 b=8
a=4 b=2
a=4 b=3
a=4 b=4
performing another query
a=1 b=8
a=2 b=8
a=3 b=8
a=4 b=2
a=4 b=3
a=4 b=4
Now closing the connection
6$ exit
Script done on Wed May 3 16:48:26 2000

========================
When I ran the same thing from the MS NT machine with the IP
192.168.50.158, and it failed.

Here is the error message I got.
========================

E:\postgres>c:\jdk1.2.2\bin\java -cp .;jdbc6.5-1.2.jar basic
jdbc:postgresql://1
92.168.50.61:5432/lixinz lixinz ""
Exception caught.
The connection attempt failed because java.net.SocketException: setsockopt()
TCP
_NODELAY (code=10055)
The connection attempt failed because java.net.SocketException: setsockopt()
TCP
_NODELAY (code=10055)
at postgresql.Connection.openConnection(Connection.java, Compiled
Code)
at postgresql.Driver.connect(Driver.java:116)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:137)
at basic.<init>(basic.java:23)
at basic.main(basic.java:162)

when this happens, the server says "port reset by peer... or something
like that..."

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"
/>

Browse pgsql-general by date

  From Date Subject
Next Message Elijah Roberts 2000-05-04 06:20:36 lo_tell problem with JDBC and RC4
Previous Message Peter Eisentraut 2000-05-03 23:10:47 Re: RE: One last thing... psql and readline