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

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
>