how to monitor size of traffic?

[Bret Waldow]

We have a legacy java app. The coder is long gone. It connects to a database over the network via jdbc.

I found a nice tool called loq4jdbc which logs all calls including Result Set accesses. But it gives time statistics. I need size measurements.

For each call to the database (either an initial call or a request to consume the next row of a Result Set) I need to know the size of the call & the size of the corresponding response.

Do you know of a tool that can do this?

Thanks in advance,
Bret

[James Ward]

Try 'smsniff' (google it); it sniffs all tcp conversations taking place from your windows machine and presents them in a neat UI. Have never tried it for JDBC though; but it does give size information.

justsniffer - this tool specifically claims to capture jdbc related packets (not sure if it gives size information):
http://justniffer.sourceforge.net/