Exporting Session sql statements to file

lt · **Joined:** Wed Apr 20, 2005 5:05 pm **Posts:** 12

Hi,

Hibernate does an amazing job wireing everything together but instead of flushing the session and writing the batch sql to the db, i was wondering if it would/could just write the sql to a file for batch loading. Anybody tried this or has any thoughts?

Thanks,
LT

steckemetz · **Posted:** Tue May 23, 2006 4:04 am

Maybe you can use the logger.
Set

Code:

log4j.logger.org.hibernate.SQL=debug

in you log4j.properties and create an file appender.

lt · **Joined:** Wed Apr 20, 2005 5:05 pm **Posts:** 12

yeah i had thought about that. Couple problems with that though. I don't want it to actually execute the update/insert statements. I just want hibernate to write out what it would have done...and ill bulk load it later. Also, I don't want the random select statements that other session's might produce...

Good thought though...

LT

steckemetz · **Posted:** Wed May 24, 2006 2:53 am

What about p6spy ?
Its a JDBC-Wrapper, i.e. it intercepts all
JDBC-calls before sending them to the database driver.