jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes how to monitor size of traffic? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to monitor size of traffic?" Watch "how to monitor size of traffic?" New topic

how to monitor size of traffic?

Bret Waldow
Ranch Hand

Joined: Aug 04, 2000
Posts: 59
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,
James Ward
Ranch Hand

Joined: Apr 27, 2003
Posts: 263
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):
Consider Paul's rocket mass heater.
subject: how to monitor size of traffic?