I have configured the log4j properties correctly. If I eg set to DEBUG logging, I get much more information. However, if I set to ERROR, I still get log
information to my console, eg:

Hibernate: select user0_.userid as userid0_, user0_.firstname as firstname0_, user0_.lastname as lastname0_, user0_.email as email0_, user0_.password as password0_, user0_.roles as roles0_, user0_.country
as country0_, user0_.lastLogin as lastLogin0_ from users user0_ where user0_.email=?

How do I disable this? I have the "show_sql" property set to false in the config file too.

When you use Tomcat or JBoss you may have to look the log4j configuration there.

Regards Sebastian

As you're getting sql output even though you've set show_sql to false, no amount of log4j tweaking is going to help. You must have set show_sql to true in code somewhere and forgotten about it. If you load a configuration from a file, then set properties, then create the session factory, the in-code changes override the config file settings.

I am using Tomcat, yes.

Where/how? Anyone with an example?

It only shows this output when I load objects, not with update or save. I did not set it in code, no.

Log4j is configured as the first thing in the application. Where/how do I then, per session, reset the logging to not use console?

Found the problem, thanks.... silly mistake. The ant build script took an outdate cfg file for the .war.

doh.