Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Problem executing remote SELECT's (through internet) with JDBC



Agustin CS wrote:
Hello all,

I have a problem invocating SELECT statements using Java JDBC driver having a remote communication between PostgreSQL database client-server through Internet.

You may want to re-run with logLevel=2 as a connection parameter; then the driver will log all the network I/O it is doing.

Without a detailed TCP trace I can't be sure but it sounds like perhaps you have a path MTU discovery problem between the server and client, or something similar. I suspect that when you turn on driver debugging, you will see the driver just stop receiving new data from the network at some point.

(if you like, mail me a tcpdump or wireshark packet capture off-list - ideally one capture from each end of the connection - and I'll take a look)

-O



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group