Logging hibernate SQL using log4j

Question

I am using hibernate and I am trying to log all the SQL that hibernate automatically generates to the console so that i can see if there is an error in my mapping. I am using log4j so i am trying to use

log4j.logger.org.hibernate.SQL=ALL, SQL_APPENDER

to display all the SQL that hibernate is using but this is not working. I have added this line of code to my log4j.properties file but it is not working! am i forgetting something or doing something wrong

i want to display something like this

Hibernate: INSERT INTO mkyong.stock_transaction (CHANGE, CLOSE, DATE, OPEN, STOCK_ID, VOLUME) 
VALUES (?, ?, ?, ?, ?, ?)

flexinIT · Accepted Answer · 2012-06-29 15:25:36Z

1

I managed to solve this. Instead of using

log4j.logger.org.hibernate.SQL=ALL, SQL_APPENDER

in my log4j.properties file it should be

log4j.category.org.hibernate.SQL = ALL

answered Jun 29, 2012 at 15:25

flexinIT

4312 gold badges10 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Logging hibernate SQL using log4j

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related