Hi everyone,

Does anyone know how to find the exact Sql query (with the data) that Hibernate fires to the Database.

For example.. by turning on the show_sql to true .. i can get information like the following:
Hibernate: insert into studentaddress (EnquiryId, AddressType, street1, street2, city, state, pincode) values (?, ?, ?, ?, ?, ?, ?).

But then what is being passed as "values" to these question marks seems to be a mystery. Debugging is becoming nightmarish if I dont know the exact values being passed.

The exceptions that Hibernate is throwing arent helpful either. It just throws a ConstraintViolationException... I have no clue how to find which constraint on which field has been violated from the exception.


Can someone help me please?

Thanks much.
Raghu

http://www.p6spy.com/ might be helpful

or you might be able to increase verbosity level of the database server log, in case of
Postges it will be -d parameter, -d 2 usually prints out enough information

See http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-logging

(org.hibernate.type logging will show parameters)