| Kevin Grittner 2005-09-06, 8:24 pm |
| Sorry to have left this hanging so long, but I was off sick all last week.
We started with the loglevel=2 option in the driver. We ran for a few seconds and got about 620KB of output, including 15 of these. I'm starting to pore over them, but I'm not sure what I'm loooking for. I've never read one of these puppies before. An
y documentation out there to help? Any tips? I assume you don't want a 620KB attachment to an email to this list.
Thanks,
-Kevin
Kevin Grittner wrote:
[color=darkred]
> I'm afraid I'm not familiar with a good way to capture the stream of communications with the database server. If you could point me in the right direction, I'll give it my best shot.
tcpdump will do the trick (something like 'tcpdump -n -w
some.output.file -s 1514 -i any tcp port 5432')
Or you can pass '&loglevel=2' as part of the JDBC connection URL to have
the JDBC driver generate a log of all the messages it sends/receives (in
less detail than a full network-level capture would give you, though)
> I did just have a thought, though -- is there any chance that the JDBC Connection.commit is returning once the command is written to the TCP buffer, and I'm getting hurt by some network latency issues
No, the JDBC driver waits for ReadyForQuery from the backend before
returning.
-O
---------------------------(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
|