I am using hibernate for persistence data, but unfortunatelly I had to save the data by myself for my special project. Every save/update/delete operation I should get the SQL and save them to the text files. And I have two problems:
1. How can I get the SQL from Hibernate.Session.save / update / delete in application? The option <show_sql>true</show_sql> just control hibernate to write the SQL to the log files, I didn't want to analyse the log files to get the SQL.
2. If can't get the SQL file, so I just save the Object and if there are a Set in the persistence object, did all the data in the Set will be saved?

Thanks all very much.

You could use log4j to configure a separate appender only for the logger org.hibernate.SQL. That way you have all SQL statements in one file.

But I'm sure that is not what you want, because you will only have the statements, not the parameter values.

So I would suggest log4jdbc [http://log4jdbc.sourceforge.net/]. It's a proxy JDBC driver that is capable of logging all JDBC statement passing through. That way you should be able to get both, statements and parameters values.

Hope that helps a bit.

org.hibernate.Interceptor.onPrepareStatement()