Hibernate-- Lgging SQL query and binding parameters in single statement

[Santosh Ramachandrula]

Hello,
Can I log SQL statements (select, insert, update, delete) and binding parameters in one single statement?

If yes can you please let me know how?(Interceptors and classes that I may need to use?)

Please let me know if you need more information.

[Santosh Ramachandrula]

Any pointers/suggestions on this?

[Santosh Ramachandrula]

Any suggestions?

[Paul Sturrock]

I can't think of a way to do this. But its pretty easy to output the SQL followed by the parameter values - use hibernate.show_sql and have org.hibernate.types log at debug. Or you could use p6spy.

[Santosh Ramachandrula]

Paul,
I am doing what you mentioned and I can see the sql and binding parameters in my logs but what I am trying to accomplish is get the sql query dynamically and execute the "EXPLAIN PLAN" on it through my test cases. Something like below

satement.execute("EXPLAIN PLAN FOR XXXXXX");


where XXXXXX is the sql query from hibernate