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@gmail.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.postgresql.Driver@c17164]
17:02:29.637 (1) simple execute, handler=org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@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
