I want to disable all logging using the following 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

### direct messages to file hibernate.log ###
#log4j.appender.file=org.apache.log4j.FileAppender
#log4j.appender.file.File=hibernate.log
#log4j.appender.file.layout=org.apache.log4j.PatternLayout
#log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

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

log4j.rootLogger=warn, stdout

log4j.logger.net.sf.hibernate=off

### log just the SQL
log4j.logger.net.sf.hibernate.SQL=off

### log JDBC bind parameters ###
log4j.logger.net.sf.hibernate.type=off

### log schema export/update ###
log4j.logger.net.sf.hibernate.tool.hbm2ddl=off

### log cache activity ###
log4j.logger.net.sf.hibernate.cache=off

### enable the following line if you want to track down connection ###
### leakages when using DriverManagerConnectionProvider ###
log4j.logger.net.sf.hibernate.connection.DriverManagerConnectionProvider=off

but I still get a lot of logging - see trace excerpt belowe!

For production use I need to disable ALL printouts (for max performance) except critical errors etc - how do I do this?????

Hibernate version:2.1

Mapping documents:NA

Code between sessionFactory.openSession() and session.close():NA

Full stack trace of any exception that occurs:NA

Name and version of the database you are using:MySQL

The generated SQL (show_sql=true):NA

Debug level Hibernate log excerpt:
Hibernate: insert into LogData (time, sequenceNumber, source, recordType, description) values (?, ?, ?, ?, ?)
Hibernate: insert into TracingData (sourceClass, sourceMethod, threadId, id) values (?, ?, ?, ?)
Hibernate: insert into LogData (time, sequenceNumber, source, recordType, description) values (?, ?, ?, ?, ?)
Hibernate: insert into TracingData (sourceClass, sourceMethod, threadId, id) values (?, ?, ?, ?)
Hibernate: insert into LogData (time, sequenceNumber, source, recordType, description) values (?, ?, ?, ?, ?)
Hibernate: insert into TracingData (sourceClass, sourceMethod, threadId, id) values (?, ?, ?, ?)
Hibernate: insert into LogData (time, sequenceNumber, source, recordType, description) values (?, ?, ?, ?, ?)
Hibernate: insert into arguments (id, arg, argument) values (?, ?, ?)
Hibernate: insert into arguments (id, arg, argument) values (?, ?, ?)
Hibernate: insert into arguments (id, arg, argument) values (?, ?, ?)
Hibernate: insert into arguments (id, arg, argument) values (?, ?, ?)
Hibernate: insert into arguments (id, arg, argument) values (?, ?, ?)
Hibernate: insert into arguments (id, arg, argument) values (?, ?, ?)
Hibernate: insert into arguments (id, arg, argument) values (?, ?, ?)

Guess you have

in your hibernate config.

HTH
Ernst

In my hibernate.proiperties I have:

##############################
### Miscellaneous Settings ###
##############################

## print all generated SQL to the console

hibernate.show_sql false

hibernate.show_sql=false

i think you are missing the =

Instead of setting your loggers to "off", set them to "fatal".

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

I've got the opposite problem. I don't seem to be able to get any debug logging out of hibernate at all. I have added the following to my log4j.xml



that did nothing.

I then tried adding a separate appender, which is the recommended approach as far as I can tell:



and altering the categories accordingly



that didn't work either.

I have tried DEBUG, ALL, TRACE, but all I ever get is the raw SQL which is controlled in the hibernate.cfg.xml. My conclusion is that none of the above is making the slightest bit of difference, so I'm stuck.

I don't have a .properties file in my JBoss instance and as far as I can tell this is a legacy approach and an XML resource file is preferred.

Without being able to switch on debug logging I am really struggling to track issues through my Hibernate code and I've been fiddling with this on and off for two weeks with no success. Very frustrated and would appreciate guidance if you have any.

I've got the opposite problem. I don't seem to be able to get any debug logging out of hibernate at all. I have added the following to my log4j.xml



that did nothing.

I then tried adding a separate appender, which is the recommended approach as far as I can tell:



and altering the categories accordingly



that didn't work either.

I have tried DEBUG, ALL, TRACE, but all I ever get is the raw SQL which is controlled in the hibernate.cfg.xml. My conclusion is that none of the above is making the slightest bit of difference, so I'm stuck.

I don't have a .properties file in my JBoss instance and as far as I can tell this is a legacy approach and an XML resource file is preferred.

Without being able to switch on debug logging I am really struggling to track issues through my Hibernate code and I've been fiddling with this on and off for two weeks with no success. Very frustrated and would appreciate guidance if you have any.