Hibernate version:3.0.5
Spring version:1.2.5

I work with Spring and Hibernate and I don't succeed in getting DEBUG messages of Hibernate. I sure that my log4j.properties file there is in the right directory, log4j.jar and common-logging.jar there are in the classpath.
Also I use log4j logger for my application messages.

In applicationContext.xml of Spring I set
<prop key="hibernate.show.sql">true</prop>

I use Eclipse and in console I get only the [INFO] messages of Spring in red color.

Here is my log4j.properties file:
### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=debug, stdout

#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
log4j.logger.org.hibernate.SQL=debug

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

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

### 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

Dimka,

From memory, the proprty used to show SQL statements is
hibernate.show_sql, not hibernate.show.sql