logging sql queries

hacktorious · **Joined:** Sun Aug 22, 2004 5:32 pm **Posts:** 40

My customer has a requirement to log all sql queries made. I was considering the hibernate.show_sql and log4j.

Does anyone have any suggestions, information and/or advice on how I should handle this requirement?

Thanks. :)

max · **Posted:** Wed Jun 08, 2005 12:24 pm

use log4j. the show_sql dumps the same to system.out which is inefficient compared to log4j logging to a file.

hacktorious · **Joined:** Sun Aug 22, 2004 5:32 pm **Posts:** 40

max wrote:

use log4j. the show_sql dumps the same to system.out which is inefficient compared to log4j logging to a file.

How much of an issue will this cause in production? I realize it will cause some sort of performance hit, but not sure how bad.

max · **Posted:** Wed Jun 08, 2005 12:39 pm

BAD!

printing to system.out/err should not be done in a production system.

*Always* log to file and if possibly do it asynchronusly (possible with log4j) - but this can make the ordering out of sync (so you need to include a sequence number (also possible with log4j)

Go to log4j for more docs on this - not an hibernate issue any more ,)

dgaspary · **Joined:** Wed Jun 08, 2005 12:33 pm **Posts:** 9

How must I proceed to make log4j log the sql commands when using Hibernate tools within Eclipse ?

max · **Posted:** Wed Jun 08, 2005 5:39 pm

add a log4j.properties into the root of one of the libs in org.hibernate.eclipse.

-max