Search code examples
javahibernatehbm2ddl

Hibernate: hibernate.hbm2ddl.auto=update show generated sql

I wish to pass to Hibernate's SessionFactory 

hibernate.hbm2ddl.auto=update

and see in log file generated sql statements. Is it possible w/o java coding (know how to achieve the result with SchemaExport, but hope that hibernate has "in box" solution)

Solution

  • You could setup logging to System.out using

    • SessionFactory sf = new Configuration().setProperty("hibernate.show_sql", "true")

    • or log4j 

      log4j.logger.org.hibernate.SQL=DEBUG, SQL_APPENDER   
log4j.additivity.org.hibernate.SQL=false

    EDIT: This maybe also helpful Hibernate sql logging with values