I have a web application that I have just upgraded from hibernate 2 to hibernate 3. The performance went down with Hibernate 3, so I am trying to compare the SQL generated by each version of Hibernate. My question is this:
I have show_sql set to true in my hibernate.cfg.xml, but I am not getting all the SQL logged. I know this because my program created over 19000 records in one table, but only 4 insert statements show up for this table.

My SQL statements are showing up in the catalina.out file in the tomcat directory, and this file shows all the inserts when I am using Hibernate 3.

Is there any reason a SQL statement would not be logged?

Steve

try setting the logging for

org.hibernate.SQL package

in your log4j.properties

I tried enabling net.sf.hibernate.SQL in my logs, and I get the same SQL statements as I got with show_sql=true.

I wonder if hibernate 2 is somehow smart enough to see that a second insert statement is the same as the first, except for the data it is binding, then smart enough to bind the new values and execute without creating another query.

If so, how do I get hibernate 3 to do the same?

Steve