我有个项目是用ibatis的,输出的查询信息是这样
1)Preparing Statement: select base_code, typefrom t_base_code where base_name=?
2)Executing Statement: select base_code, from t_base_code where base_name=?
3)Parameters: [sandy]
4)[java.lang.String]
5)ResultSet
Header: [base_code]
Result: [MAS_IP]
Result: [MAS_USER]也就是1和2输出查询语句,3输出参数的值,4输出参数的类型,5则输出结果。配置是这样写的
log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG 但是在spring+hibernate+struts中我这样配置
log4j.logger.org.hibernate.hql=DEBUG
log4j.logger.org.hibernate.type=DEBUG
显示效果不好。谁能够给点参考
1)Preparing Statement: select base_code, typefrom t_base_code where base_name=?
2)Executing Statement: select base_code, from t_base_code where base_name=?
3)Parameters: [sandy]
4)[java.lang.String]
5)ResultSet
Header: [base_code]
Result: [MAS_IP]
Result: [MAS_USER]也就是1和2输出查询语句,3输出参数的值,4输出参数的类型,5则输出结果。配置是这样写的
log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG 但是在spring+hibernate+struts中我这样配置
log4j.logger.org.hibernate.hql=DEBUG
log4j.logger.org.hibernate.type=DEBUG
显示效果不好。谁能够给点参考
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
<prop key="show_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.jdbc.batch_size">20</prop>
</props>
</property>
但是还是不行啊
还可以设置 hibernate.format_sql = true
hibernate.use_sql_comments = true
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop> </props>
</property>