Hibernate Community • View topic - SQL logging in hibernate

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

SQL logging in hibernate

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

breako

Post subject: SQL logging in hibernate

Posted: Wed Nov 07, 2007 7:27 am

Senior

Joined: Mon Jul 24, 2006 8:43 am
Posts: 160

Hi,
I know Hibernate supports logging, detailed in the F.A.Q.
http://www.hibernate.org/119.html#A17

and the Manning book.

However, this logs the prepared statements with the ?, ?, ? I need to be 100% sure of what values are being passed up.

No I could turn on additional logging in my JPA entity POJOs but I need to absolutely sure.

Is there any plans for hibernate to include this feature as user friendly as possible.

Is it possible to know what hibernate's plans are for logging?

Many many thanks

Top

cmh28

Post subject: SQL logging

Posted: Fri Nov 09, 2007 11:14 am

Newbie

Joined: Fri Nov 09, 2007 10:06 am
Posts: 2

In your logging config in addition to having org.hibernate.sql set to debug level to display SQL statements do the same for org.hibernate.type and the values of the bind variables will be displayed.

Here is an example from one of our logs:

Code:

    where
        beverages0_.person_id=?
DEBUG - 15:13:10,862 - [IntegerType][main]: binding '1' to parameter: 1

Top

Page 1 of 1

[ 2 posts ]

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum