Hibernate version: 3.2.4

I am looking for the SQL that is generated similarily in hibernate.show_sql. We need the sql and the parameters because we want to forward it to another database. I am well aware of the replication option available in MySQL, but that causes another problem that I don't want to get into.

I have noticed that Interceptor will solve my problem, however I don't see the actual SQL. How do I find the actual SQL that Hibernate generates at the database?

Thanks in advance.

The show_sql parameter only makes the generated SQL statements to be written to the console, which might not be what you want.

In order to show the SQL statements in a log file, use log4j, and simply add a category that grabs anything from the package org.hibernate.SQL, for example:



you could also create a separate file only for SQL statements, for example:



SQL logging belongs to the DEBUG level, but you can log at different levels to different destinations. For example, the rest of your applicationmight log only at "INFO" level, but you can log the SQL code to a different file at DEBUG level.

We need the information at the code level. We need to basically have some form of an injection which can do the following:

Depending on which table is being updated, added, etc. - We would take that SQL and push it off to another database. You see we would need to catch the update/add/delete after the transaction has committed, and only then capture the SQL and after that make the appropriate action.

Thanks anyways for your input.

Then you face an additional problem:
Unless you force ugly explicit, code transactions boundaries pretty much on every single command you write, and flush the session all the time, you cannot tell when Hibernate will decide to actually perform those SQL statements.

Is there not a way for me to capture the statement when Hibernate decides to write to the log file. There has to be something that is executing the SQL command in the database and then if necessary to update the logs if logging is turned on. I was hoping to capture it once it has completed those steps. I am aware that Interceptors can help me capture the updates, adds, etc. However I believe, I would still have to create the SQL Query manually - Is there not a way to automate this or extract this information on demand?

Anyone?

Try Debugging the database there you can find the query hibernate generates