1

I'm trying to log hibernate activity (only dml operations) to an sql script file. My goal is to have a way to reconstruct the database from a given starting point to the current state by executing the generated script.

I can get the sql queries from log4j logs but they have more information than the raw sql queries and i would need to parse them and extract only the helpful statements.

So i'm looking for a programatic way, maybe by listening the persist/merge/delete operations and accessing the hibernate-generated sql statements.

I don't like to reinvent the wheel so, if anybody know a way for doing this i would appreciate it very much.

Thanks in advance

Improve this question

3 Answers 3

Reset to default
1

Generally the best way to do this is to just turn on logging on your SQL server. All the major RDBMSes support logging all the SQL statements that they run. This has the added advantage of catching things that happened outside of Hibernate.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Hi, Travis, in my case this isn't a good option because i want to detect if something has changed in the database as a result of an operation performed bypassing the application. Thanks anyway.
Logs are all done with user association. If Hibernate is connected with a specific user, just replay those statements done by that user. If you're thinking that this won't work because of "security," then your security model is broken in the first place.
0

You could also try to use NHProf which will intercept/record hibernate traffic to the database and dump it into an XML file. You might have to parse the file by hand, but all the information will be there.

Improve this answer

1 Comment

Good option, i will read the documentation. Thanks R0MANARMY.
0

You could also hook at the JDBC level directly and record the JDBC statements that are performed.

P6Spy is a great tool to inspect what's going on. It can log the queries, though I don't know if you can replay them as is.

I'm sure there are other such tool (or at worse you could try subclass the DataSource, Connection and PreparedStatement implementation of your choice to do that yourself).

Improve this answer

2 Comments

If i can hook jdbc statements this would be what i'm looking for. I will investigate it a little. Have you ever implemented something like this? Thanks ewernli.
@zeven No. I've used P6Spy or other products that would rely on this technique (e.g. Glassfish can wrap the JDBC object of the underlying datasource), but never developper wrappers for the JDBC objects myself.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.