Re: SQL query never ends - Mailing list pgsql-jdbc

From Mark Lewis
Subject Re: SQL query never ends
Date
Msg-id 1155239726.13254.3.camel@archimedes
Whole thread Raw
In response to Re: SQL query never ends  ("James Im" <im-james@hotmail.com>)
Responses Unexpected Statement Caching with CURRENT_TIMESTAMP
List pgsql-jdbc
Yeah, Windows special-cases even non-loopback local network traffic and
bypasses the packet sniffer.  I once had to do some iptables magic with
a Linux box to bounce local traffic off a remote server and back in so I
could sniff it.

-- Mark

On Thu, 2006-08-10 at 14:55 +0000, James Im wrote:
> Sorry it doesn't work. I connect to 192.168.0.8 but Wireshark doesn't
> caputre anything on the database port.
>
> I'll try to reproduced the problem on linux.
>
> Dave Cramer wrote:
> >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
> >>
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 4: Have you searched our list archives?
> >
> >               http://archives.postgresql.org
> >
>
> _________________________________________________________________
> Find dine dokumenter lettere med MSN Toolbar med Windows-pc-sgning:
> http://toolbar.msn.dk
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

pgsql-jdbc by date:

Previous
From: "James Im"
Date:
Subject: Re: SQL query never ends
Next
From: "Nicholas E. Wakefield"
Date:
Subject: Unexpected Statement Caching with CURRENT_TIMESTAMP