This is a discussion on Re: SQL query never ends within the pgsql Interfaces jdbc forums, part of the PostgreSQL category; --> I've done some more tests and I think that I can say that a same connection is not used ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| |||
| 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 |
| ||||
| James Im wrote: > Have you seen the thread dump? Does it helps you at all? Unfortunately the thread dump just says what the logging says -- that the driver is waiting for a message from the server that never comes. -O ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |