What should we do to disable trace level logging in case of Hibernate when we are using log4j.xml for logging purposes because it consumes a lot of time in case of calling function log() of org.hibernate.type.Nullabletype class.

We have tried different options that are as follows:-

1)Set org.apache.log4j.Logger.getLogger("net.sf.hibernate").setLevel(org.apache.log4j.Level.FATAL)

2)Set <category name="log4j.logger.org.hibernate.type"><priority value="FATAL"/></category>

3)Set <category name="log4j.logger.net.sf.hibernate "><priority value="FATAL"/></category>

Regards,
Jamunt

Which logs do you have in the console? Are you speaking about general hibernate logs, or about the generated SQL?

If you speak about the SQL, also check the hibernate.cfg.xml file to see if the "show_sql" property is actually set to false. Apart from this, setting org.hibernate logging level to, say, warn or error should already be sufficient to remove a big part of of the logs.

You should set the level to "org.hibernate" logger

Yep.. it works good as batmat suggested.

<category name="org.hibernate"><priority value="fatal"/></category>

Using the ablove tag in your log4j.xml will solve the problem

OR

Set
org.hibernate = fatal in you log4j.properties file

This will limit your log output.

Hope this info helps!