How do I print the values hibernate is inserting ?

nitz_tech · **Joined:** Wed Mar 17, 2004 12:44 am **Posts:** 25

Hello folks,

Is there any way out with which I could know the values hibernate is inserting ?

nitin

UltimoAmore · **Joined:** Tue Jan 27, 2004 8:33 am **Posts:** 29

give a look at p6spy

nitz_tech · **Joined:** Wed Mar 17, 2004 12:44 am **Posts:** 25

I installed the p6spy but cannot run. I am using spring framework with hibernate. Using connection factory of spring framework. Logically speaking there should not be any problem. But there is ..

Exception :
WARN [main] JDBCExceptionReporter.logExceptions(38) | SQL Error: 0, SQLState: null
ERROR [main] JDBCExceptionReporter.logExceptions(46) | Cannot create JDBC driver of class 'com.p6spy.engine.spy.P6SpyDriver' f
or connect URL 'jdbc:oracle:oci8:@username'

nitin

nitz_tech · **Joined:** Wed Mar 17, 2004 12:44 am **Posts:** 25

oh sorry .. m using commons dbcp.. from apache..

UltimoAmore · **Joined:** Tue Jan 27, 2004 8:33 am **Posts:** 29

This is more a p6spy question than a Hibernate question...
Anyway check the name of the driver into p6spy config and check
that you added the p6spy lib to the classpath.

jfifield · **Joined:** Tue Aug 26, 2003 3:09 pm **Posts:** 58

I believe this information is logged at the DEBUG level. Just configure log4j (or whatever you use for logging).

emmanuel · **Posted:** Fri Mar 26, 2004 3:40 pm

### log just the SQL
log4j.logger.net.sf.hibernate.SQL=debug

### log JDBC bind parameters ###
log4j.logger.net.sf.hibernate.type=debug