帮我看看我的LOG4J哪里错了，不能禁止hibernate输出

Question

现在hibernate执行一个语句，都要输出大量的以INFO开头的语句，非常的烦
通过配置LOG4J可以控制这些语句不输出，不过我不知道哪里弄错了，怎样配置，都还是有大量输出以下是我的LOG4J的配置，麻烦大家给看看log4j.rootLogger=ERROR,A1
log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=%n%d{yy-MM-dd hh:mm:ss} [%t] %c %x - %m%nlog4j.logger.org.hibernate==ERROR
log4j.logger.org.hibernate.SQL=DEBUG
log4j.logger.com.opensymphony=WARN
log4j.logger.org.apache.struts2=WARNlog4j.logger.org.apache=WARN 
log4j.logger.org.apache.catalina=ERROR
log4j.logger.org.apache.commons=WARN

Answer 1

试试这个#LOG4J
log4j.rootCategory=INFO,CONSOLE
log4j.additivity.org.apache=falselog4j.category.org=ERRORlog4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.Threshold=INFO
log4j.appender.CONSOLE.Target=System.out
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%d [%t] %-5p %c %x - %m%n

Answer 2

log4j.rootLogger=WARN, console ,filelog4j.logger.sysuiengine = WARN
log4j.logger.sysuiengine.web.filter.authentication = INFOlog4j.logger.org =WARN
log4j.logger.org.apache =WARN
log4j.logger.org.hibernate = WARN
log4j.logger.org.springframework = WARNlog4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=[%-5p] %d{yyyy-MM-dd HH:mm:ss,SSS} [%l] %m%n#log4j.appender.file=org.apache.log4j.RollingFileAppender
#log4j.appender.file.MaxFileSize=2048KB
#log4j.appender.file.MaxBackupIndex=20log4j.appender.file=org.apache.log4j.DailyRollingFileAppender
log4j.appender.file.DatePattern='.'yyyy-MM-dd-HH
log4j.appender.file.Append=true
log4j.appender.file.File=C:/log.loglog4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=[%-5p] %d{yyyy-MM-dd HH:mm:ss,SSS} [%c:%l] %m%n
##log4j.appender.R.layout.ConversionPattern=[%c] %m%n

Answer 3

log4j.logger.org.hibernate==ERROR  有两个等号

Answer 4

log4j.appender.A1=org.apache.log4j.FileAppender 

Answer 5

63 [http-8080-1] INFO org.hibernate.cfg.Environment - Hibernate 3.3.2.GA
63 [http-8080-1] INFO org.hibernate.cfg.Environment - hibernate.properties not found
78 [http-8080-1] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
94 [http-8080-1] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
438 [http-8080-1] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
438 [http-8080-1] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
641 [http-8080-1] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : cn/phdz/entity/SysMenu.hbm.xml
828 [http-8080-1] INFO org.hibernate.cfg.HbmBinder - Mapping class: cn.phdz.entity.SysMenu -> sys_menu
1000 [http-8080-1] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : cn/phdz/entity/TbEmployee.hbm.xml
1031 [http-8080-1] INFO org.hibernate.cfg.HbmBinder - Mapping class: cn.phdz.entity.TbEmployee -> tb_employee
1031 [http-8080-1] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : cn/phdz/entity/TbEducation.hbm.xml
1047 [http-8080-1] INFO org.hibernate.cfg.HbmBinder - Mapping class: cn.phdz.entity.TbEducation -> tb_education
1047 [http-8080-1] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
1297 [http-8080-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
1297 [http-8080-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
1297 [http-8080-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
1297 [http-8080-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://127.0.0.1:3306/phdzoa
1297 [http-8080-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root, password=****}
1735 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - RDBMS: MySQL, version: 5.1.30-community
1735 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.14 ( $Date: 2006-10-18 17:40:15 +0200 (Wed, 18 Oct 2006) $, $Revision: 5888 $ )
1875 [http-8080-1] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
1891 [http-8080-1] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
1906 [http-8080-1] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
1906 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
1922 [http-8080-1] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
1922 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
1922 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
1922 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
1922 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
1922 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
1922 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
1922 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
1938 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
1938 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
1953 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
1953 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
1953 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
2110 [http-8080-1] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
2985 [http-8080-1] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured

Answer 6

谢谢
因为现在还在调试阶段，所以输出到控制台
而且现在我是不想让hibernate输出这些内容，而不是输出到哪里

Answer 7

log4j.logger.org.hibernate.cfg=ERROR
log4j.logger.org.hibernate.connection=ERROR
log4j.logger.org.hibernate.transaction=ERROR
log4j.logger.org.hibernate.impl=ERROR加上试试.

Answer 8

加了，还是没用郁闷了……今天弄了一下午了
配置文件叫log4j.properties，放在WEB-INF\classes下，这没错吧？

Answer 9

看样子你的log4j的properties根本没起作用可能是因为你导入的jar里有一个log4j.xmllog4j以xml优先配置在加载程序的入口加上LogManager.resetConfiguration();

Answer 10

楼主的log4j配置绝对没有起作用，输出的格式和配置的格式更本不一样。
先检查一下，你的lib中有没有log4j的jar（我曾经有一次配log4j的日志输出格式，怎么配都不起作用，结果发现忘了加log4j.jar）
有的话，再按楼上的试试

Answer 11

我用的是log4j-1.2.15.jar，里面也没有log4j.xml，怪了，我试着改用XML配置试试看
大家再帮我看看，实在想不通为什么会无效

Answer 12

应该有作用的，我去掉log4j.properties后，就会有警告出来
log4j:WARN No appenders could be found for logger (com.opensymphony.xwork2.config.providers.XmlConfigurationProvider).
log4j:WARN Please initialize the log4j system properly.

Answer 13

写了个小测试
logger.debug("debug");
logger.info("info");
logger.warn("warn");
logger.error("error");
logger.fatal("fetal");我只要修改输出等级，这些都能起效，就是不知道为什么hibernate不起作用……

Answer 14

总算搞定了，虽然我到现在也不知道是什么原因，我只是把
log4j.appender.A1.layout.ConversionPattern=%n%d{yy-MM-dd hh:mm:ss} [%t] %c %x - %m%n
注释掉了一下，又还原了一下…………

Answer 15

禁止hibernate输出是要在hibernate配置文件中弄吧。。
<property name="hibernate.show_sql">false</property>