Configuring Hibernate logging using Log4j XML config file

Question

I haven t been able to find any documentation on how to configure Hibernate s logging using the XML style configuration file for Log4j   Is this even possible or do I have use a properties style configuration file to control Hibernate s logging   If anyone has any information or links to documentation it would appreciated   EDIT  Just to clarify  I am looking for an example of the actual XML syntax to control Hibernate   EDIT2  Here is what I have in my XML config file    lt  xml version  1 0  encoding  UTF-8    gt   lt  DOCTYPE log4j configuration SYSTEM  log4j dtd  gt    lt log4j configuration xmlns log4j  http   jakarta apache org log4j   gt       lt appender name  console  class  org apache log4j ConsoleAppender  gt           lt param name  Threshold  value  info   gt           lt param name  Target  value  System out   gt           lt layout class  org apache log4j PatternLayout  gt               lt param name  ConversionPattern  value   d ABSOLUTE    t   -5p  c 1  -  m n   gt           lt  layout gt       lt  appender gt       lt appender name  rolling-file  class  org apache log4j RollingFileAppender  gt           lt param name  file  value  Program-Name log   gt           lt param name  MaxFileSize  value  1000KB   gt       lt  -- Keep one backup file -- gt           lt param name  MaxBackupIndex  value  4   gt           lt layout class  org apache log4j PatternLayout  gt               lt param name  ConversionPattern  value   d   t   -5p  l -  m n   gt           lt  layout gt       lt  appender gt        lt root gt           lt priority value   debug    gt           lt appender-ref ref  console    gt           lt appender-ref ref  rolling-file    gt       lt  root gt   lt  log4j configuration gt    Logging works fine but I am looking for a way to step down and control the hibernate logging in way that separate from my application level logging  as it currently is flooding my logs  I have found examples of using the preference file to do this  I was just wondering how I can do this in a XML file

User · Answer

Here s what I use    lt logger name  org hibernate  gt       lt level value  warn   gt   lt  logger gt    lt logger name  org hibernate SQL  gt       lt level value  warn   gt   lt  logger gt    lt logger name  org hibernate type  gt       lt level value  warn   gt   lt  logger gt    lt root gt       lt priority value  info   gt       lt appender-ref ref  C1   gt   lt  root gt     Obviously  I don t like to see Hibernate messages    -- set the level to  debug  to get the output

User · Answer

You can configure your log4j file with the category tag like this  with a console appender for the example     lt appender name  console  class  org apache log4j ConsoleAppender  gt       lt layout class  org apache log4j PatternLayout  gt           lt param name  ConversionPattern  value   d yy-MM-dd HH mm ss   p  c -  m n    gt       lt  layout gt   lt  appender gt   lt category name  org hibernate  gt       lt priority value  WARN    gt   lt  category gt   lt root gt       lt priority value  INFO    gt       lt appender-ref ref  console    gt   lt  root gt    So every warning  error or fatal message from hibernate will be displayed  nothing more  Also  your code and library code will be in info level  so info  warn  error and fatal   To change log level of a library  just add a category  for example  to desactive spring info log    lt category name  org springframework  gt       lt priority value  WARN    gt   lt  category gt    Or with another appender  break the additivity  additivity default value is true    lt category name  org springframework  additivity  false  gt       lt priority value  WARN    gt       lt appender-ref ref  anotherAppender    gt   lt  category gt    And if you don t want that hibernate log every query  set the hibernate property show sql to false

User · Answer

From http   docs jboss org hibernate core 3 3 reference en html session-configuration html configuration-logging  Here s the list of logger categories   Category                    Function  org hibernate SQL           Log all SQL DML statements as they are executed org hibernate type          Log all JDBC parameters org hibernate tool hbm2ddl  Log all SQL DDL statements as they are executed org hibernate pretty        Log the state of all entities  max 20 entities  associated with the session at flush time org hibernate cache         Log all second-level cache activity org hibernate transaction   Log transaction related activity org hibernate jdbc          Log all JDBC resource acquisition org hibernate hql ast AST   Log HQL and SQL ASTs during query parsing org hibernate secure        Log all JAAS authorization requests org hibernate               Log everything  a lot of information  but very useful for troubleshooting     Formatted for pasting into a log4j XML configuration file    lt  -- Log all SQL DML statements as they are executed -- gt   lt Logger name  org hibernate SQL  level  debug    gt   lt  -- Log all JDBC parameters -- gt   lt Logger name  org hibernate type  level  debug    gt   lt  -- Log all SQL DDL statements as they are executed -- gt   lt Logger name  org hibernate tool hbm2ddl  level  debug    gt   lt  -- Log the state of all entities  max 20 entities  associated with the session at flush time -- gt   lt Logger name  org hibernate pretty  level  debug    gt   lt  -- Log all second-level cache activity -- gt   lt Logger name  org hibernate cache  level  debug    gt   lt  -- Log transaction related activity -- gt   lt Logger name  org hibernate transaction  level  debug    gt   lt  -- Log all JDBC resource acquisition -- gt   lt Logger name  org hibernate jdbc  level  debug    gt   lt  -- Log HQL and SQL ASTs during query parsing -- gt   lt Logger name  org hibernate hql ast AST  level  debug    gt   lt  -- Log all JAAS authorization requests -- gt   lt Logger name  org hibernate secure  level  debug    gt   lt  -- Log everything  a lot of information  but very useful for troubleshooting  -- gt   lt Logger name  org hibernate  level  debug    gt    NB  Most of the loggers use the DEBUG level  however org hibernate type uses TRACE   In previous versions of Hibernate org hibernate type also used DEBUG  but as of Hibernate 3 you must set the level to TRACE  or ALL  in order to see the JDBC parameter binding logging   And a category is specified as such    lt logger name  org hibernate  gt       lt level value  ALL    gt       lt appender-ref ref  FILE   gt   lt  logger gt    It must be placed before the root element

User · Answer

From http   docs jboss org hibernate core 3 3 reference en html session-configuration html configuration-logging  Here s the list of logger categories   Category                    Function  org hibernate SQL           Log all SQL DML statements as they are executed org hibernate type          Log all JDBC parameters org hibernate tool hbm2ddl  Log all SQL DDL statements as they are executed org hibernate pretty        Log the state of all entities  max 20 entities  associated with the session at flush time org hibernate cache         Log all second-level cache activity org hibernate transaction   Log transaction related activity org hibernate jdbc          Log all JDBC resource acquisition org hibernate hql ast AST   Log HQL and SQL ASTs during query parsing org hibernate secure        Log all JAAS authorization requests org hibernate               Log everything  a lot of information  but very useful for troubleshooting     Formatted for pasting into a log4j XML configuration file    lt  -- Log all SQL DML statements as they are executed -- gt   lt Logger name  org hibernate SQL  level  debug    gt   lt  -- Log all JDBC parameters -- gt   lt Logger name  org hibernate type  level  debug    gt   lt  -- Log all SQL DDL statements as they are executed -- gt   lt Logger name  org hibernate tool hbm2ddl  level  debug    gt   lt  -- Log the state of all entities  max 20 entities  associated with the session at flush time -- gt   lt Logger name  org hibernate pretty  level  debug    gt   lt  -- Log all second-level cache activity -- gt   lt Logger name  org hibernate cache  level  debug    gt   lt  -- Log transaction related activity -- gt   lt Logger name  org hibernate transaction  level  debug    gt   lt  -- Log all JDBC resource acquisition -- gt   lt Logger name  org hibernate jdbc  level  debug    gt   lt  -- Log HQL and SQL ASTs during query parsing -- gt   lt Logger name  org hibernate hql ast AST  level  debug    gt   lt  -- Log all JAAS authorization requests -- gt   lt Logger name  org hibernate secure  level  debug    gt   lt  -- Log everything  a lot of information  but very useful for troubleshooting  -- gt   lt Logger name  org hibernate  level  debug    gt    NB  Most of the loggers use the DEBUG level  however org hibernate type uses TRACE   In previous versions of Hibernate org hibernate type also used DEBUG  but as of Hibernate 3 you must set the level to TRACE  or ALL  in order to see the JDBC parameter binding logging   And a category is specified as such    lt logger name  org hibernate  gt       lt level value  ALL    gt       lt appender-ref ref  FILE   gt   lt  logger gt    It must be placed before the root element

User · Answer

You can configure your log4j file with the category tag like this  with a console appender for the example     lt appender name  console  class  org apache log4j ConsoleAppender  gt       lt layout class  org apache log4j PatternLayout  gt           lt param name  ConversionPattern  value   d yy-MM-dd HH mm ss   p  c -  m n    gt       lt  layout gt   lt  appender gt   lt category name  org hibernate  gt       lt priority value  WARN    gt   lt  category gt   lt root gt       lt priority value  INFO    gt       lt appender-ref ref  console    gt   lt  root gt    So every warning  error or fatal message from hibernate will be displayed  nothing more  Also  your code and library code will be in info level  so info  warn  error and fatal   To change log level of a library  just add a category  for example  to desactive spring info log    lt category name  org springframework  gt       lt priority value  WARN    gt   lt  category gt    Or with another appender  break the additivity  additivity default value is true    lt category name  org springframework  additivity  false  gt       lt priority value  WARN    gt       lt appender-ref ref  anotherAppender    gt   lt  category gt    And if you don t want that hibernate log every query  set the hibernate property show sql to false

User · Answer

In response to homaxto s comment  this is what I have right now    lt  xml version  1 0  encoding  UTF-8    gt   lt  DOCTYPE log4j configuration SYSTEM  log4j dtd  gt    lt log4j configuration xmlns log4j  http   jakarta apache org log4j   gt       lt appender name  console  class  org apache log4j ConsoleAppender  gt           lt param name  Threshold  value  debug   gt           lt param name  Target  value  System out   gt           lt layout class  org apache log4j PatternLayout  gt               lt param name  ConversionPattern  value   d ABSOLUTE    t   -5p  c 1  -  m n   gt           lt  layout gt       lt  appender gt       lt appender name  rolling-file  class  org apache log4j RollingFileAppender  gt           lt param name  file  value  Program-Name log   gt           lt param name  MaxFileSize  value  500KB   gt           lt param name  MaxBackupIndex  value  4   gt           lt layout class  org apache log4j PatternLayout  gt               lt param name  ConversionPattern  value   d   t   -5p  l -  m n   gt           lt  layout gt       lt  appender gt        lt logger name  org hibernate  gt           lt level value  info    gt       lt  logger gt        lt root gt           lt priority value   debug    gt           lt appender-ref ref  console    gt           lt appender-ref ref  rolling-file    gt       lt  root gt   lt  log4j configuration gt    The key part being    lt logger name  org hibernate  gt       lt level value  info    gt   lt  logger gt    Hope this helps

User · Answer

From http   docs jboss org hibernate core 3 3 reference en html session-configuration html configuration-logging  Here s the list of logger categories   Category                    Function  org hibernate SQL           Log all SQL DML statements as they are executed org hibernate type          Log all JDBC parameters org hibernate tool hbm2ddl  Log all SQL DDL statements as they are executed org hibernate pretty        Log the state of all entities  max 20 entities  associated with the session at flush time org hibernate cache         Log all second-level cache activity org hibernate transaction   Log transaction related activity org hibernate jdbc          Log all JDBC resource acquisition org hibernate hql ast AST   Log HQL and SQL ASTs during query parsing org hibernate secure        Log all JAAS authorization requests org hibernate               Log everything  a lot of information  but very useful for troubleshooting     Formatted for pasting into a log4j XML configuration file    lt  -- Log all SQL DML statements as they are executed -- gt   lt Logger name  org hibernate SQL  level  debug    gt   lt  -- Log all JDBC parameters -- gt   lt Logger name  org hibernate type  level  debug    gt   lt  -- Log all SQL DDL statements as they are executed -- gt   lt Logger name  org hibernate tool hbm2ddl  level  debug    gt   lt  -- Log the state of all entities  max 20 entities  associated with the session at flush time -- gt   lt Logger name  org hibernate pretty  level  debug    gt   lt  -- Log all second-level cache activity -- gt   lt Logger name  org hibernate cache  level  debug    gt   lt  -- Log transaction related activity -- gt   lt Logger name  org hibernate transaction  level  debug    gt   lt  -- Log all JDBC resource acquisition -- gt   lt Logger name  org hibernate jdbc  level  debug    gt   lt  -- Log HQL and SQL ASTs during query parsing -- gt   lt Logger name  org hibernate hql ast AST  level  debug    gt   lt  -- Log all JAAS authorization requests -- gt   lt Logger name  org hibernate secure  level  debug    gt   lt  -- Log everything  a lot of information  but very useful for troubleshooting  -- gt   lt Logger name  org hibernate  level  debug    gt    NB  Most of the loggers use the DEBUG level  however org hibernate type uses TRACE   In previous versions of Hibernate org hibernate type also used DEBUG  but as of Hibernate 3 you must set the level to TRACE  or ALL  in order to see the JDBC parameter binding logging   And a category is specified as such    lt logger name  org hibernate  gt       lt level value  ALL    gt       lt appender-ref ref  FILE   gt   lt  logger gt    It must be placed before the root element

User · Answer

Loki s answer points to the Hibernate 3 docs and provides good information  but I was still not getting the results I expected    Much thrashing  waving of arms and general dead mouse runs finally landed me my cheese    Because Hibernate 3 is using Simple Logging Facade for Java  SLF4J   per the docs   if you are relying on Log4j 1 2 you will also need the slf4j-log4j12-1 5 10 jar if you are wanting to fully configure Hibernate logging with a log4j configuration file  Hope this helps the next guy

User · Answer

The answers were useful  After the change  I got duplicate logging of SQL statements  one in the log4j log file and one on the standard console  I changed the persistence xml file to say show sql to false to get rid of logging from the standard console  Keeping format sql true also affects the log4j log file  so I kept that true    lt persistence xmlns  http   java sun com xml ns persistence          xmlns xsi  http   www w3 org 2001 XMLSchema-instance          xsi schemaLocation  http   java sun com xml ns persistence http   java sun com xml ns persistence persistence 2 0 xsd          version  2 0  gt       lt persistence-unit name  myUnit  transaction-type  RESOURCE LOCAL  gt           lt provider gt org hibernate ejb HibernatePersistence lt  provider gt           lt properties gt               lt property name  javax persistence jdbc driver  value  org hsqldb jdbcDriver   gt               lt property name  javax persistence jdbc url  value  jdbc hsqldb file d  temp database cap1000 shutdown true  gt  lt  property gt               lt property name  dialect  value  org hibernate dialect HSQLDialect   gt               lt property name  hibernate show sql  value  false   gt               lt property name  hibernate format sql  value  true   gt               lt property name  hibernate connection username  value  sa   gt               lt property name  hibernate hbm2ddl auto  value  create-drop   gt           lt  properties gt       lt  persistence-unit gt   lt  persistence gt

User · Answer

In response to homaxto s comment  this is what I have right now    lt  xml version  1 0  encoding  UTF-8    gt   lt  DOCTYPE log4j configuration SYSTEM  log4j dtd  gt    lt log4j configuration xmlns log4j  http   jakarta apache org log4j   gt       lt appender name  console  class  org apache log4j ConsoleAppender  gt           lt param name  Threshold  value  debug   gt           lt param name  Target  value  System out   gt           lt layout class  org apache log4j PatternLayout  gt               lt param name  ConversionPattern  value   d ABSOLUTE    t   -5p  c 1  -  m n   gt           lt  layout gt       lt  appender gt       lt appender name  rolling-file  class  org apache log4j RollingFileAppender  gt           lt param name  file  value  Program-Name log   gt           lt param name  MaxFileSize  value  500KB   gt           lt param name  MaxBackupIndex  value  4   gt           lt layout class  org apache log4j PatternLayout  gt               lt param name  ConversionPattern  value   d   t   -5p  l -  m n   gt           lt  layout gt       lt  appender gt        lt logger name  org hibernate  gt           lt level value  info    gt       lt  logger gt        lt root gt           lt priority value   debug    gt           lt appender-ref ref  console    gt           lt appender-ref ref  rolling-file    gt       lt  root gt   lt  log4j configuration gt    The key part being    lt logger name  org hibernate  gt       lt level value  info    gt   lt  logger gt    Hope this helps

User · Answer

Here s what I use    lt logger name  org hibernate  gt       lt level value  warn   gt   lt  logger gt    lt logger name  org hibernate SQL  gt       lt level value  warn   gt   lt  logger gt    lt logger name  org hibernate type  gt       lt level value  warn   gt   lt  logger gt    lt root gt       lt priority value  info   gt       lt appender-ref ref  C1   gt   lt  root gt     Obviously  I don t like to see Hibernate messages    -- set the level to  debug  to get the output

User · Answer

Loki s answer points to the Hibernate 3 docs and provides good information  but I was still not getting the results I expected    Much thrashing  waving of arms and general dead mouse runs finally landed me my cheese    Because Hibernate 3 is using Simple Logging Facade for Java  SLF4J   per the docs   if you are relying on Log4j 1 2 you will also need the slf4j-log4j12-1 5 10 jar if you are wanting to fully configure Hibernate logging with a log4j configuration file  Hope this helps the next guy

User · Answer

The answers were useful  After the change  I got duplicate logging of SQL statements  one in the log4j log file and one on the standard console  I changed the persistence xml file to say show sql to false to get rid of logging from the standard console  Keeping format sql true also affects the log4j log file  so I kept that true    lt persistence xmlns  http   java sun com xml ns persistence          xmlns xsi  http   www w3 org 2001 XMLSchema-instance          xsi schemaLocation  http   java sun com xml ns persistence http   java sun com xml ns persistence persistence 2 0 xsd          version  2 0  gt       lt persistence-unit name  myUnit  transaction-type  RESOURCE LOCAL  gt           lt provider gt org hibernate ejb HibernatePersistence lt  provider gt           lt properties gt               lt property name  javax persistence jdbc driver  value  org hsqldb jdbcDriver   gt               lt property name  javax persistence jdbc url  value  jdbc hsqldb file d  temp database cap1000 shutdown true  gt  lt  property gt               lt property name  dialect  value  org hibernate dialect HSQLDialect   gt               lt property name  hibernate show sql  value  false   gt               lt property name  hibernate format sql  value  true   gt               lt property name  hibernate connection username  value  sa   gt               lt property name  hibernate hbm2ddl auto  value  create-drop   gt           lt  properties gt       lt  persistence-unit gt   lt  persistence gt

User · Answer

From http   docs jboss org hibernate core 3 3 reference en html session-configuration html configuration-logging  Here s the list of logger categories   Category                    Function  org hibernate SQL           Log all SQL DML statements as they are executed org hibernate type          Log all JDBC parameters org hibernate tool hbm2ddl  Log all SQL DDL statements as they are executed org hibernate pretty        Log the state of all entities  max 20 entities  associated with the session at flush time org hibernate cache         Log all second-level cache activity org hibernate transaction   Log transaction related activity org hibernate jdbc          Log all JDBC resource acquisition org hibernate hql ast AST   Log HQL and SQL ASTs during query parsing org hibernate secure        Log all JAAS authorization requests org hibernate               Log everything  a lot of information  but very useful for troubleshooting     Formatted for pasting into a log4j XML configuration file    lt  -- Log all SQL DML statements as they are executed -- gt   lt Logger name  org hibernate SQL  level  debug    gt   lt  -- Log all JDBC parameters -- gt   lt Logger name  org hibernate type  level  debug    gt   lt  -- Log all SQL DDL statements as they are executed -- gt   lt Logger name  org hibernate tool hbm2ddl  level  debug    gt   lt  -- Log the state of all entities  max 20 entities  associated with the session at flush time -- gt   lt Logger name  org hibernate pretty  level  debug    gt   lt  -- Log all second-level cache activity -- gt   lt Logger name  org hibernate cache  level  debug    gt   lt  -- Log transaction related activity -- gt   lt Logger name  org hibernate transaction  level  debug    gt   lt  -- Log all JDBC resource acquisition -- gt   lt Logger name  org hibernate jdbc  level  debug    gt   lt  -- Log HQL and SQL ASTs during query parsing -- gt   lt Logger name  org hibernate hql ast AST  level  debug    gt   lt  -- Log all JAAS authorization requests -- gt   lt Logger name  org hibernate secure  level  debug    gt   lt  -- Log everything  a lot of information  but very useful for troubleshooting  -- gt   lt Logger name  org hibernate  level  debug    gt    NB  Most of the loggers use the DEBUG level  however org hibernate type uses TRACE   In previous versions of Hibernate org hibernate type also used DEBUG  but as of Hibernate 3 you must set the level to TRACE  or ALL  in order to see the JDBC parameter binding logging   And a category is specified as such    lt logger name  org hibernate  gt       lt level value  ALL    gt       lt appender-ref ref  FILE   gt   lt  logger gt    It must be placed before the root element

[xml] Configuring Hibernate logging using Log4j XML config file?

Examples related to xml

Examples related to hibernate

Examples related to logging

Examples related to configuration

Examples related to log4j