Can Hibernate display values it is going to inser/update

Pascal jacob · **Joined:** Mon Dec 12, 2005 10:45 am **Posts:** 12

Hello,

"show_sql" and "format_sql" tell Hibernate to display the SQL statement but values are not displayed, they are proxied with a '?' character.

Is there an switch to tell Hibernate to also display the values it is going to insert/update ?

Pascal Jacob.

ramnath · **Posted:** Fri Jan 20, 2006 5:11 am

Hi,

I think you have an answer in this thread: http://forum.hibernate.org/viewtopic.ph ... highlight=

Pascal jacob · **Joined:** Mon Dec 12, 2005 10:45 am **Posts:** 12

Thank you Ramnat.

I investigate a bit more and I also found that in my log4j.properties (I did copy that in the file at the time I start the project then completely forget about it !!)

I hope this will help other people.

Code:

### Log levels for Hibernate

log4j.logger.org.hibernate = info
#log4j.logger.org.hibernate = debug

### log HQL query parser activity
#log4j.logger.org.hibernate.hql.ast.AST = debug

### log just the SQL
## it respects the "format_sql" and "use_sql_comments" settings from hibernate.cfg.xml
log4j.logger.org.hibernate.SQL = info

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

### log schema export/update
log4j.logger.org.hibernate.tool.hbm2ddl = info

### log HQL parse trees
#log4j.logger.org.hibernate.hql = debug

### log cache activity
#log4j.logger.org.hibernate.cache = debug

### log transaction activity
#log4j.logger.org.hibernate.transaction = debug

### log JDBC resource acquisition
#log4j.logger.org.hibernate.jdbc = debug

### enable the following line if you want to track down connection
### leakages when using DriverManagerConnectionProvider
#log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider = trace