hibernate 的log4j怎么写 才能输出sql语句 ？？ 在线等

Question

这是我的log4j文件
--------
#log4j.rootLogger=DEBUG, stdout,logfile,INFO
log4j.rootLogger=DEBUG,stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%nlog4j.logger.java.sql.PreparedStatement=DEBUGlog4j.appender.logfile=org.apache.log4j.RollingFileAppender
log4j.appender.logfile.File=${czqs.root}/WEB-INF/czqs.log
log4j.appender.logfile.MaxFileSize=1024KB
# Keep three backup files.
log4j.appender.logfile.MaxBackupIndex=3
# Pattern to output: date priority [category] - message
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] - %m%n
----------怎样才能使他输出sql语句 
怎样才能使他的输出少一点  感觉太多无用信息或我不想了解的信息 影响我观看  这是我的log4j输出
2011-11-02 23:44:53,921 DEBUG [com.opensymphony.xwork2.conversion.impl.XWorkConverter] - Class: ssh2.wq.fn.entity.Question
2011-11-02 23:44:53,921 DEBUG [com.opensymphony.xwork2.conversion.impl.XWorkConverter] - field-level type converter for property [qawnum] = none found
2011-11-02 23:44:53,921 DEBUG [com.opensymphony.xwork2.conversion.impl.XWorkConverter] - Property: qawnum.qawnum
2011-11-02 23:44:53,921 DEBUG [com.opensymphony.xwork2.conversion.impl.XWorkConverter] - Class: ssh2.wq.fn.entity.Question
2011-11-02 23:44:53,921 DEBUG [com.opensymphony.xwork2.conversion.impl.XWorkConverter] - global-level type converter for property [qawnum] = none found
2011-11-02 23:44:53,921 DEBUG [com.opensymphony.xwork2.conversion.impl.XWorkConverter] - falling back to default type converter [com.opensymphony.xwork2.conversion.impl.XWorkBasicConverter@1064b80]
2011-11-02 23:44:53,921 DEBUG [com.opensymphony.xwork2.conversion.impl.XWorkConverter] - Property: qsid
2011-11-02 23:44:53,921 DEBUG [com.opensymphony.xwork2.conversion.impl.XWorkConverter] - Class: ssh2.wq.fn.entity.Question
2011-11-02 23:44:53,921 DEBUG [com.opensymphony.xwork2.conversion.impl.XWorkConverter] - field-level type converter for property [qsid] = none found
2011-11-02 23:44:53,921 DEBUG [com.opensymphony.xwork2.conversion.impl.XWorkConverter] - Property: qsid.qsid
2011-11-02 23:44:53,921 DEBUG [com.opensymphony.xwork2.conversion.impl.XWorkConverter] - Class: ssh2.wq.fn.entity.Question

Answer 1

把log的级别从debug改成info既可

Answer 2

log4j.logger.java.sql.Connection = debug
log4j.logger.java.sql.PreparedStatement = debug, fileout 

Answer 3

"把log的级别从debug改成info既可"
可以怎样 输出信息少么 

Answer 4

能不能详细点  最好能给个log4j让我看看  

Answer 5

这个是在hibernate配置文件中配置的
<property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">
org.hibernate.dialect.MySQL5Dialect
                </prop>
                <prop key="hibernate.show_sql">
true
                </prop>
                <prop key="hibernate.format_sql">
true
                </prop>
            </props>
        </property>

Answer 6

在hibernate 配置文件中 加个参数 show_sql 值为 true 就可以看见sql语句了

Answer 7

是在 hibernate 配置文件中配置的吧, 不是在 log4j 里吧

Answer 8

给你个参考:
log4j.rootLogger=ERROR
log4j.logger.SafeFoodLogger=ERROR,file
log4j.additivity.SafeFoodLogger=true
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.SimpleLayout
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=../FoodSystem.log
log4j.appender.logfile.encoding=UTF-8
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss}[%c]-[%-5p]%m%n%n

Answer 9

我用的是SSH2  配置文件是 app.xml spring的
我看网上都说 hibernate 3.2之后版本的sql输出 都是在log4j中配置的  大家用ssh2时配置log4j的输出都怎么配的 我的输出太多了  

Answer 10

#log4j.rootLogger=debug, stdout
log4j.logger.net.sf.hibernate=warn### log just the SQL
log4j.logger.net.sf.hibernate.SQL=debug### log JDBC bind parameters ###
log4j.logger.net.sf.hibernate.type=info### log schema export/update ###
log4j.logger.net.sf.hibernate.tool.hbm2ddl=debug### log cache activity ###
#log4j.logger.net.sf.hibernate.cache=debugxml中：
<property name="hibernateProperties">
<props>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.format_sql">true</prop>
<!-- <prop key="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop> -->
</props>
</property>

Answer 11

spring 的配置文件中:
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref local="dataSource" />
</property>
<property name="mappingResources">
<list>
            </list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.Oracle9Dialect
</prop>
            <prop key="hibernate.show_sql">true</prop> 
               <prop key="hibernate.format_sql">true</prop>  
<prop key="hibernate.cache.use_second_level_cache">
true
</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>
<prop key="hibernate.cache.provider_class">
org.hibernate.cache.EhCacheProvider
</prop>
<prop key="net.sf.ehcache.configurationResourceName">
classpath:com/config/ehcache.xml
</prop>
</props>
</property>
</bean>

Answer 12

                <prop key="hibernate.show_sql">
                    true
                </prop>