File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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):
I agree. Here's the link:
subject: how to monitor size of traffic?
It's not a secret anymore!