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

["Agustin CS" <agustincs1(at)gmail(dot)com>]

I found the source of the problem... The database server is behind a router and any configuration parameter in that router close the 
communication between client and server.

Thanks

2008/2/22, Agustin CS <agustincs1(at)gmail(dot)com>:

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.

Here is the debug output that we get when running the SELECT statement from the first post.
JDBC driver used: 8.3-603 JDBC3
Java Virtual Machine used: sun-java-1.5.0.11
Platform used: Kubuntu 7.04

------------------------

17:02:29.152 (1) PostgreSQL 8.3 JDBC3 with SSL (build 603)
17:02:29.167 (1) Trying to establish a protocol version 3 connection to XXX.XXX.XXX.XXX:5432
17:02:29.281 (1)  FE=> StartupPacket(user=userdb, database=database_example, client_encoding=UNICODE, DateStyle=ISO, extra_float_digits=2)
17:02:29.384 (1)  <=BE AuthenticationReqPassword
17:02:29.386 (1)  FE=> Password(password=<not shown>)
17:02:29.489 (1)  <=BE AuthenticationOk
17:02:29.524 (1)  <=BE ParameterStatus(client_encoding = UNICODE)
17:02:29.525 (1)  <=BE ParameterStatus(DateStyle = ISO, DMY)
17:02:29.525 (1)  <=BE ParameterStatus(integer_datetimes = on)
17:02:29.525 (1)  <=BE ParameterStatus(is_superuser = off)
17:02:29.525 (1)  <=BE ParameterStatus(server_encoding = SQL_ASCII)
17:02:29.525 (1)  <=BE ParameterStatus(server_version = 8.2.6)
17:02:29.525 (1)  <=BE ParameterStatus(session_authorization = userdb)
17:02:29.526 (1)  <=BE ParameterStatus(standard_conforming_strings = off)
17:02:29.526 (1)  <=BE ParameterStatus(TimeZone = localtime)
17:02:29.526 (1)  <=BE BackendKeyData(pid=16418,ckey=140210510)
17:02:29.526 (1)  <=BE ReadyForQuery(I)
17:02:29.526 (1)     compatible = 8.3
17:02:29.528 (1)     loglevel = 2
17:02:29.529 (1)     prepare threshold = 5
getConnection returning driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)c17164]
17:02:29.637 (1) simple execute, handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)1ca318a, maxRows=0, fetchSize=0, flags=17
17:02:29.641 (1)  FE=> Parse(stmt=null,query="SELECT * FROM table1 ORDER BY field1",oids={})
17:02:29.643 (1)  FE=> Bind(stmt=null,portal=null)
17:02:29.643 (1)  FE=> Describe(portal=null)
17:02:29.644 (1)  FE=> Execute(portal=null,limit=0)
17:02:29.645 (1)  FE=> Sync
17:02:29.763 (1)  <=BE ParseComplete [null]
17:02:29.765 (1)  <=BE BindComplete [null]
17:02:29.767 (1)  <=BE RowDescription(1)
17:02:29.769 (1)  <=BE DataRow
17:02:29.769 (1)  <=BE DataRow
17:02:29.769 (1)  <=BE DataRow
17:02:29.769 (1)  <=BE DataRow