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

FoxyBOA picture FoxyBOA · Mar 13, 2010 · Viewed 9.8k times · Source

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)

Answer

stacker picture stacker · Mar 13, 2010

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