I have a requirement in my current project to get access to the generated SQL at runtime. I am using Hibernate v3. Does anybody know if this is possible and where in the API one can do this?

thanks,
ray

Use the hibernate.show_sql property:

http://www.hibernate.org/hib_docs/v3/re ... n-optional

HTH,
Robert

the hibernate.show_sql just logs the SQL statements to the console. I want to get access to the String in my code and store it in a database. Is there a way to do that?

-ray

Hey,
you can get the sql queries by calling, getQueryString() method of Query class. you will get whole sql except the runtime parameters

Unfortunately, the getQueryString() method returns the HQL query string and not the SQL query string

I think you can enable DEBUG on the log4j system of Hibernate and use JDBCAppender or some custom Appender to capture the native SQL.

Anyway this option will make your app very slow (hibernate generates a lot of debug).

Good idea there andre. You can set the JDBCAppender to only log the org.hibernate.sql package, I believe that will get you only the sql statements. Of course it will be prepended by "Hibernate: ", not sure if you can use a ConversionPattern or what not to get rid of that.

Oh, sure, I didn't realize you can enable the DEBUG only for a given package. You're right,

About the "hibernate" prefix it only occurs when you use "show_sql=true". The class "SQL" debug's the SQL string directly (SQL:393, in my hibernate 3.2 CR4).

Regards

There ya go. I never thought about using log4j to log SQL statments to a database, never had cause to use the JDBCAppender. Now I'm going to scuttle off to see how this works, it would be nice to log the SQL in a database on-demand with timestamps to tweak optimizations.

Anyhoo, back to the OP:

Use log4j with either the JDBCAppender and read from that table or use the WriterAppender and create a Writer which will synchronize access to a (thread-bound?) data stream and read from there.

Ananasi, i tried to use JDBCAppender and have some problems with it... if you want to talk about it send me email at angoro -at- gmail

I'll give it a quick whirl when I get the chance (crunch time at the moment), but will keep this thread bookmarked for when I encounter a problem with the JDBCAppender.

org.hibernate.Interceptor.onPrepareStatement()

Hey! the one who knows, knows (as we say in spain...)

Regards.

You can get it from system tables, there are many usefull views and features for performance tuning (statistics, tracing, query plans). oracle store this stuff in v$sqltext view