I'm getting messages like this in my server log and want to turn them off.

Hibernate: select user0_.id as id, user0_.forename as forename, ...)


I have set the logger level to 'error' in log4j.properties like this

log4j.rootLogger=error, stdout

log4j.logger.net.sf.hibernate=error

Can anybody help.

My own loggers are controlled from the same file and behave as expected. I suspect that the log4j.properties file is not the place for these 'Hibernate: ...' type messages.

Cheers,

Nick

set show_sql = false in your hibernate config.

Great. Many thanks for the quick reply