CODEWITHSUNDEEP
javahibernatehbm2ddl
FoxyBOA
FoxyBOA

Reputation: 5836

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)

Upvotes: 7

Views: 10172

Answers (2)

FelixJongleur42
FelixJongleur42

Reputation: 950

You can also set a debug breakpoint on

org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(boolean, boolean)

and see how it goes.

Upvotes: 3

stacker
stacker

Reputation: 68942

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

Upvotes: 5

Related Questions