From: | "Stefano B(dot)" <stefano(dot)bonnin(at)comai(dot)to> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | executeQuery hangs my application |
Date: | 2005-12-13 13:52:53 |
Message-ID: | 005801c5ffec$83c779a0$0501a8c0@comai04 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
I have a problem with the PostgreSQL JDBC drivers 8.1+.
In my code I call the executeQuery method and sometimes it seems to lock my application.
I tried to update the driver to the newer 8.2 version but I obtained the same result ...
The database server version is 8.1 for Windows (but I am not the administrator)
I have found this problem (for now) only on this server ...
the jdbc log is the following:
*****************************************************
14:09:10.171 (2) PostgreSQL 8.2devel JDBC3 with SSL (build 500)
14:09:10.171 (2) Trying to establish a protocol version 3 connection to <_the_server_IP_>:5432
14:09:10.265 (2) FE=> StartupPacket(user=postgres, database=barricalla, client_encoding=UNICODE,
DateStyle=ISO)
14:09:10.390 (2) <=BE AuthenticationReqMD5(salt=be98c8a8)
14:09:10.390 (2) FE=> Password(md5digest=md5724bad3aac24aa6aed8dfebfe9eafcfa)
14:09:10.468 (2) <=BE AuthenticationOk
14:09:10.468 (2) <=BE ParameterStatus(client_encoding = UNICODE)
14:09:10.468 (2) <=BE ParameterStatus(DateStyle = ISO, MDY)
14:09:10.468 (2) <=BE ParameterStatus(integer_datetimes = off)
14:09:10.468 (2) <=BE ParameterStatus(is_superuser = on)
14:09:10.468 (2) <=BE ParameterStatus(server_encoding = UTF8)
14:09:10.468 (2) <=BE ParameterStatus(server_version = 8.1.1)
14:09:10.468 (2) <=BE ParameterStatus(session_authorization = postgres)
14:09:10.468 (2) <=BE ParameterStatus(standard_conforming_strings = off)
14:09:10.468 (2) <=BE ParameterStatus(TimeZone = CET)
14:09:10.468 (2) <=BE BackendKeyData(pid=1664,ckey=1388535757)
14:09:10.468 (2) <=BE ReadyForQuery(I)
14:09:10.468 (2) compatible = 8.2
14:09:10.468 (2) loglevel = 2
14:09:10.468 (2) prepare threshold = 5
getConnection returning driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)15fc672]
14:09:10.468 (2) simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)9770a3, maxRows=0, fetchSize=0,
flags=17
14:09:10.468 (2) FE=> Parse(stmt=null,query="SELECT max("fulldate"),min("fulldate") FROM "data_cab_a"
",oids={})
14:09:10.484 (2) FE=> Bind(stmt=null,portal=null)
14:09:10.484 (2) FE=> Describe(portal=null)
14:09:10.484 (2) FE=> Execute(portal=null,limit=0)
14:09:10.484 (2) FE=> Sync
14:09:10.687 (2) <=BE ParseComplete [null]
14:09:10.687 (2) <=BE BindComplete [null]
14:09:10.687 (2) <=BE RowDescription(2)
14:09:10.687 (2) <=BE DataRow
14:09:10.687 (2) <=BE CommandStatus(SELECT)
14:09:10.828 (2) <=BE ReadyForQuery(I)
14:09:11.187 (2) simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)4298e, maxRows=0, fetchSize=0,
flags=17
14:09:11.187 (2) FE=> Parse(stmt=null,query="SELECT * FROM "data_cab_a" WHERE "fulldate" < timestamp
'2005-11-11 00:00:00' AND "fulldate" >= timestamp '2005-10-12 00:00:00'",oids={})
14:09:11.187 (2) FE=> Bind(stmt=null,portal=null)
14:09:11.187 (2) FE=> Describe(portal=null)
14:09:11.187 (2) FE=> Execute(portal=null,limit=0)
14:09:11.187 (2) FE=> Sync
14:09:11.578 (2) <=BE ParseComplete [null]
14:09:11.578 (2) <=BE BindComplete [null]
14:09:11.578 (2) <=BE RowDescription(13)
14:09:11.578 (2) <=BE DataRow
14:09:11.578 (2) <=BE DataRow
14:09:11.578 (2) <=BE DataRow
14:09:11.593 (2) <=BE DataRow
14:09:11.593 (2) <=BE DataRow
14:09:11.593 (2) <=BE DataRow
14:09:11.593 (2) <=BE DataRow
14:09:11.593 (2) <=BE DataRow
...
...
... other ~5000 lines
...
...
14:10:06.109 (2) <=BE CommandStatus(SELECT)
14:10:06.109 (2) <=BE ReadyForQuery(I)
14:10:42.515 (2) simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)11ed166, maxRows=0,
fetchSize=0, flags=17
14:10:42.515 (2) FE=> Parse(stmt=null,query="SELECT * FROM "data_cab_a" WHERE "fulldate" < timestamp
'2005-12-11 00:00:00' AND "fulldate" >= timestamp '2005-11-11 00:00:00'",oids={})
14:10:42.515 (2) FE=> Bind(stmt=null,portal=null)
14:10:42.515 (2) FE=> Describe(portal=null)
14:10:42.515 (2) FE=> Execute(portal=null,limit=0)
14:10:42.515 (2) FE=> Sync
14:10:42.859 (2) <=BE ParseComplete [null]
14:10:42.859 (2) <=BE BindComplete [null]
14:10:42.859 (2) <=BE RowDescription(13)
14:10:42.859 (2) <=BE DataRow
14:10:42.859 (2) <=BE DataRow
14:10:42.859 (2) <=BE DataRow
14:10:42.859 (2) <=BE DataRow
...
... other ~5000 lines
...
14:11:21.140 (2) <=BE DataRow
14:11:21.140 (2) <=BE DataRow
14:11:21.140 (2) <=BE DataRow
14:11:21.140 (2) <=BE DataRow
14:11:21.140 (2) <=BE DataRow
14:11:21.140 (2) <=BE DataRow
******************************************************************************
at this point no other log messages are printed and the application seems locked on the executeQuery method.
The database connection is opened (even if I wait for 2 or 3 hours ...)
Any hints?
Thanks in advance.
Stefano
From | Date | Subject | |
---|---|---|---|
Next Message | kbforge | 2005-12-13 20:12:08 | New release: - kbforge 1.20 Free desktop search application with PGSQL database option |
Previous Message | Heikki Linnakangas | 2005-12-12 19:29:37 | Re: pgsql XA with weblogic 8.1? |