Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2.1.7

The generated SQL (show_sql=true):

Hi forun friends,
I have a doubt, for example there is a way to intercept the bank query hibernate sends to the bank, like this :
"from TUtilizacao u where u.codServico = '5' " ( HQL )
"select u.* from TUtilizacao u where u.codServico ='5' " ( SQL sended )

String s = "select u.* from TUtilizacao u where u.codServico ='5' ";
only this.

Thanks JP.

I don't understand the question here. You don't beleive Hibernate is displaying the same SQL it actually sends to the database?

thats true JustKeith my client just want to know the sql thats ariving at the bank .

Thanks JP

First off I can say that I've never encountered a case where what Hibernate displays with show_sql=true was not entirely accurate. If you'd like to prove this to your self though you'll need to look to your database or the JDBC driver.

Many database servers have trace features that would allow you to see the SQL delivered to them. This is probably the most authoratative source in my opinion as it shows what the database engine is seeing.

Many JDBC drivers also having logging options. This is often useful when the database is on a server somewhere and shared by many people. I've used this frequently with DB2.

I've never used it personally but there is a open source JDBC driver called P6Spy that is designed to wrap another JDBC driver for the specific purpose of logging all interaction between a application and a JDBC driver. I've never used it personally but have heard it mentioned favorably here on the boards before.