Re: SQL query never ends

From: Dave Cramer <pg(at)fastcrypt(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 12:20:44
Message-ID: BF98101C-EBFB-43D3-B0B3-E5401AF842FC@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

James,

Change the connection so that it connects to the ethernet device on
the box, then Wireshark can listen to it.

--dc--
On 10-Aug-06, at 6:45 AM, James Im wrote:

> I've done some more tests and I think that I can say that a same
> connection is not used by several thread at the same time.
> However different connections are being used by several threads at the
> same time.
>
>> Can you capture the network traffic between the server and JDBC
>> driver?
> I don't know how to do that on Windows. Wireshark cannot listen to the
> windows loopback interface.
>
> Have you seen the thread dump? Does it helps you at all?
>
> _________________________________________________________________
> Ta' på udsalg året rundt på MSN Shopping: http://shopping.msn.dk
> - her finder du altid de bedste priser
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message James Im 2006-08-10 14:55:57 Re: SQL query never ends
Previous Message James Im 2006-08-10 10:45:00 Re: SQL query never ends