 |
AppletTalk.com
Java discussions newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Roedy Green
Guest
|
 Posted: Tue Jan 17, 2006 4:05 am Post subject: Snooping |
 |
|
Is there an official way to snoop on what the app and database say to
each other? Just what does PreparedStatement send? Just what does a
raw resultset coming back look like?
--
Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.
|
|
| Back to top |
|
 |
Tony Morris
Guest
|
| Posted: Tue Jan 17, 2006 6:38 am Post subject: Re: Snooping |
|
|
"Roedy Green" <my_email_is_posted_on_my_website (AT) munged (DOT) invalid> wrote in
message news:76ros118apt14q85bsonm9cvrrp8pdu4kb (AT) 4ax (DOT) com...
| Quote: | Is there an official way to snoop on what the app and database say to
each other? Just what does PreparedStatement send? Just what does a
raw resultset coming back look like?
--
Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.
|
That depends on the driver.
As far as 'snooping' on what the driver is doing, I have written a driver
that accepts an underlying driver and a callback on the URL that performs
delegation and calls back when sending/receiving data. I will try to find it
if you like but I have a feeling that it is property of my employer.
--
Tony Morris
http://tmorris.net/
|
|
| Back to top |
|
|
Alan Krueger
Guest
|
| Posted: Tue Jan 17, 2006 1:31 pm Post subject: Re: Snooping |
|
|
Thomas Hawtin wrote:
| Quote: | Roedy Green wrote:
Is there an official way to snoop on what the app and database say to
each other? Just what does PreparedStatement send? Just what does a
raw resultset coming back look like?
At a TCP/IP level, directing through a straightforward dumping proxy
should work. Assuming the driver is just using a a simple TCP/IP link
(obviously not the case for embedded databases).
|
Ethereal may come in handy here, rather than using a proxy.
http://www.ethereal.com/
|
|
| Back to top |
|
|
Roedy Green
Guest
|
| Posted: Tue Jan 17, 2006 5:34 pm Post subject: Re: Snooping |
|
|
On Tue, 17 Jan 2006 09:37:49 +0000, Thomas Hawtin
<usenet (AT) tackline (DOT) plus.com> wrote, quoted or indirectly quoted someone
who said :
| Quote: | a dumping dynamic proxy
|
What one would you recommend?
--
Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.
|
|
| Back to top |
|
|
Adam Maass
Guest
|
| Posted: Wed Jan 18, 2006 4:07 am Post subject: Re: Snooping |
|
|
"Roedy Green" wrote:
| Quote: | Is there an official way to snoop on what the app and database say to
each other? Just what does PreparedStatement send? Just what does a
raw resultset coming back look like?
|
Nothing official. Note that the wire-level protocol for each database and
JDBC driver will be different, so snooping at the wire level isn't going to
accomplish much -- unless you know (or can decode) that protocol.
P6Spy, http://www.p6spy.com/, does a pretty good job of logging the calls to
an underlying JDBC driver. Lower than that, and you're talking about
proprietary protocols...
-- Adam Maass
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
