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. Any documentation out there to help? Any tips? I
assume you don't want a 620KB attachment to an email to this list.
Thanks,
-Kevin
>>> Oliver Jowett <[EMAIL PROTECTED]> 08/26/05 5:04 PM >>>
Kevin Grittner wrote:
> 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
