Virtual spy driver for JDBC
IronGrid provides an easy to use virtual spy driver for JDBC which can be used to gather performance related data for all your SQL queries. I have benefited it from it so give it a try if you are not using something similar.
The driver is called p6spy which wraps the JDDC driver and traps all the request coming and going through it. Thus it has the flexibility in keeping frequency/responsiveness of your SQL queries. Apart from trapping the data this driver also listen to port( configurable) which can be used to connect from a client ( provided by IronGrid) to read the data.
Three things rocks most
1) You don't have to make a single line of code change on your app server. Everything is configured.
2) You can see the binding variable data on your prepared statement, which I believe is wonderful as I miss it a lot with straight JDBC logging.
3) Provides a client which can get all these data and present it in a nice way, can also generate reports.
Setup is quite straight forward , basically put the jar file in classpath and configure the spy.properties so it knows which driver it has to wrap.It supports most of the popular JDBC driver, and the product is free of cost!!!
The driver is called p6spy which wraps the JDDC driver and traps all the request coming and going through it. Thus it has the flexibility in keeping frequency/responsiveness of your SQL queries. Apart from trapping the data this driver also listen to port( configurable) which can be used to connect from a client ( provided by IronGrid) to read the data.
Three things rocks most
1) You don't have to make a single line of code change on your app server. Everything is configured.
2) You can see the binding variable data on your prepared statement, which I believe is wonderful as I miss it a lot with straight JDBC logging.
3) Provides a client which can get all these data and present it in a nice way, can also generate reports.
Setup is quite straight forward , basically put the jar file in classpath and configure the spy.properties so it knows which driver it has to wrap.It supports most of the popular JDBC driver, and the product is free of cost!!!
posted by Anand @ 6:54 PM
0 Comments:
Post a Comment
<< Home