Posted 2009-06-03 18:10. Last updated 2017-06-24 12:00. Tagged java, debugging, jdbc, utveckling.
When developing code with Hibernate (or other Java tools that create SQL statements for you) it is often a good idea to take a close look at the generated SQL code, for example if you have performerance issues.
A very nice and simple way to do that is logdriver by Ryan Bloom. (Update 2017-06-24: Unfortunatley, the domain seems to have been lost to a spam site).
And it’s simple to use! I’ve got a
.properties file where I’ve
commented out the ordinary db driver and use logdriver instead. As
simple as this:
# DB_DRIVER=oracle.jdbc.driver.OracleDriver # DB_URL=jdbc:oracle:thin:@dbhost.mydomain:1523:db DB_DRIVER=net.rkbloom.logdriver.LogDriver DB_URL=jdbc:log:oracle.jdbc.driver.OracleDriver:oracle:thin:@dbhost.mydomain:1523:db