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

Question

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)

stacker · Accepted Answer · 2010-03-13T08:24:48.560

5

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

edited Mar 13 '10 at 08:24

answered Mar 13 '10 at 08:18

stacker

68,052
28
140
210

3

Unfortunately, hbm2ddl ignore both options. So I don't see any alter/create statement in my log file. – FoxyBOA Mar 13 '10 at 08:38
5

@FoxyBOA for ddl statements you should try : log4j.logger.org.hibernate.tool.hbm2ddl=debug – stacker Mar 13 '10 at 08:45

score 3 · Answer 2 · answered Mar 07 '13 at 12:50

3

You can also set a debug breakpoint on

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

and see how it goes.

answered Mar 07 '13 at 12:50

FelixJongleur42

833
7
8

1

Or `SchemaExport` if this is not an update but an initial schema creation – Thilo Jul 29 '13 at 06:05

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

2 Answers2