From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
---|---|
To: | James Im <im-james(at)hotmail(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: SQL query never ends |
Date: | 2006-08-10 07:15:43 |
Message-ID: | 44DADD1F.1080103@opencloud.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
James Im wrote:
> I'm experimenting a random problem on my PC. Sometimes a sql query
> executed with Statement never returns.
> simple execute,
> handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)996cca,
>
> maxRows=0, fetchSize=0, flags=17
> FE=> Parse(stmt=null,query="i've remove the select query",oids={})
> FE=> Bind(stmt=null,portal=null)
> FE=> Describe(portal=null)
> FE=> Execute(portal=null,limit=0)
> FE=> Sync
>
> .. and nothing else. No "<=BE ..." follow the " FE=> Sync" log entry.
This seems normal enough. What is logged immediately before before this?
Can you capture the network traffic between the server and JDBC driver?
If it's a concurrency issue we should see something at the connection
level. I'm not familiar with what windows tools are available to take
network captures (in the unix world I'd use tcpdump/snoop/ethereal), but
if you manage to get something in a format that ethereal will read, send
me the raw capture off-list and I'll take a look.
> I've also tried to put "stmt.setQueryTimeout(3);" but it doesn't seem to
> do anything.
setQueryTimeout() is a no-op in the current driver.
-O
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2006-08-10 07:17:50 | Re: Problem with JDBC and Large Objects |
Previous Message | Randall Hauch | 2006-08-09 23:12:02 | Problem with JDBC and Large Objects |