logging tool for JDBC (offtopic maybe ?)
Hello,
I would like to announce a nice little tool that I am involved in developing: it's called JDBC Logger. What this tool does is it wraps around an existing JDBC Driver and logs in plain text everything that passes throw (including prepared statements). For now we have a generic driver and a custom one for Oracle 10. We have tested the generic driver with MySQL, HSQLDB and Postgre SQL.
We're still in a beta phase but it looks pretty stable to me. What we need right now is a few people testing it with different database engines and requirements. So if you have a project and if you would like to try our logger please let us know of the results (positive or negative)
here is the link to the web page:
http://jdbclogger.sourceforge.net/index.html
In order to use JDBC Logger you have to place the jar file in your classpath and to specifynet.sourceforge.jdbclogger.JdbcLoggerDriver as your JDBC driver. You also have to make ajdbclogger.properties file and add a line with your actual JDBC driver like this:
jdbclogger.driver=org.hsqldb.jdbcDriver
(We have an example in our SVN repository so you can take a look there or you can contact me on our projects forum)
The statements are logged by using the commons-logging library, and has been tested with log4j. Make sure you include the following line in your log4j.properties.
log4j.logger.net.sourceforge.jdbclogger=DEBUG
Hope you find it as nice as I do ... and please don't hesitate to send me your questions and remarks..
happy hacking :)
Sorin.
