Hi ,

i was wondering if there is any way in hibernate to cofingure so all SQL statement will be log with value


Below are something i get when i do searching using Criteria

/* criteria query */ select
this_.MENU_ID as MENU1_5_0_,
this_.PARENT_ID as PARENT2_5_0_,
this_.LOCALE as LOCALE5_0_,
this_.MENU_NAME as MENU4_5_0_,
this_.MENU_TYPE as MENU5_5_0_,
this_.PAGE_URL as PAGE6_5_0_
from
SWIM.SWIM.MENU_CONFIGURATION this_
where
this_.PARENT_ID=?
and this_.MENU_TYPE=?
order by
this_.MENU_ID asc



But as you can see Parent_id and menu_type = ?
Seems like preparedStatement to me.
How can i see full SQL statement so it would be easier to just copy and paste the SQL to my Database Query Editor to run the query


Thanks

Hi,
If I understand it correctly, the operations that take place are, ( done by Hibernate )
i) set the values into host bind variables.
ii) fire the query as-is with bind variables to underlying database.

A query of the form "select * from my_table where my_name = 'name'" is never formed. ( assume 'name' is the bind value )

So, we might not ( my guess and understanding ) get a query that can be directly fired at prompt.

However, to know the values of bind variables, you can use,
log4j.logger.org.hibernate.type=debug


------------------------------------------------------------------
Rate the reply if you find it helpful