log4jdbc用于打印于SQL 同时打出绑定参数的值:
log4jdbc: http://code.google.com/p/log4jdbc/
另外一个对log4jdbc的扩展: http://code.google.com/p/log4jdbc-remix/
在官网首页已经将用法讲的很清楚了
JDBC 4 support was added with the JDK 1.6 release and adds many additional features over and above JDBC 3. However, the log4jdbc JDBC 4 driver can wrap a JDBC 3 or older driver and it's recommended that if you use JDK 1.6 or above, that you use the log4jdbc JDBC 4 driver that is compiled with JDK 1.6.
log4jdbc3-1.2.jar for JDBC 3 support in JDK 1.4 , JDK 1.5
log4jdbc4-1.2.jar for JDBC 4 support in JDK 1.6 , JDK 1.7
Set your JDBC driver class to net.sf.log4jdbc.DriverSpy in your application's configuration.
Driver Class Database Type
oracle.jdbc.driver.OracleDriver Older Oracle Driver
oracle.jdbc.OracleDriver Newer Oracle Driver
com.sybase.jdbc2.jdbc.SybDriver Sybase
net.sourceforge.jtds.jdbc.Driver jTDS SQL Server & Sybase driver
com.microsoft.jdbc.sqlserver.SQLServerDriver Microsoft SQL Server 2000 driver
com.microsoft.sqlserver.jdbc.SQLServerDriver Microsoft SQL Server 2005 driver
weblogic.jdbc.sqlserver.SQLServerDriver Weblogic SQL Server driver
com.informix.jdbc.IfxDriver Informix
org.apache.derby.jdbc.ClientDriver Apache Derby client/server driver, aka the Java DB
org.apache.derby.jdbc.EmbeddedDriver Apache Derby embedded driver, aka the Java DB
com.mysql.jdbc.Driver MySQL
org.postgresql.Driver PostgresSQL
org.hsqldb.jdbcDriver HSQLDB pure Java database
org.h2.Driver H2 pure Java database
Prepend jdbc:log4 to the normal jdbc url that you are using.
jdbc:derby://localhost:1527//db-derby-10.2.2.0-bin/databases/MyDatabase改为:
jdbc:log4jdbc:derby://localhost:1527//db-derby-10.2.2.0-bin/databases/MyDatabase
Set up your loggers.
Each of these logs can be set at either DEBUG, INFO or ERROR level.
DEBUG includes the class name and line number (if available) at which the SQL was executed. Use DEBUG level with extra care, as this imposes an additional performance penalty when in use.
INFO includes the SQL (or other information as applicable.)
ERROR will show the stack traces in the log output when SQLExceptions occur.
jdbc.sqlonly Logs only SQL. SQL executed within a prepared statement is automatically shown with it's bind arguments replaced with the data bound at that position, for greatly increased readability. 1.0
jdbc.sqltiming Logs the SQL, post-execution, including timing statistics on how long the SQL took to execute. 1.0
jdbc.audit Logs ALL JDBC calls except for ResultSets. This is a very voluminous output, and is not normally needed unless tracking down a specific JDBC problem. 1.0
jdbc.resultset Even more voluminous, because all calls to ResultSet objects are logged. 1.0
jdbc.connection Logs connection open and close events as well as dumping all open connection numbers. This is very useful for hunting down connection leak problems. 1.2alpha1
使用很简单,将JDBC URL修改,同时修改驱动即可
<property name="connection.url">jdbc:log4jdbc:h2:tcp://localhost/~/dbname</property>
<property name="connection.driver_class">net.sf.log4jdbc.DriverSpy</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property name="dialect">org.hibernate.dialect.H2Dialect</property>
log4j中配置日志的输出
log4j.logger.jdbc.sqlonly=OFF
log4j.logger.jdbc.sqltiming=INFO
log4j.logger.jdbc.audit=OFF
log4j.logger.jdbc.resultset=OFF
log4j.logger.jdbc.connection=OFF
相关推荐
'记录SQL 在需要插入参数值的地方(例如,例如spring.jpa.properties.hibernate.show_sql=true所做的事情),log4jdbc可以使用替换为其实际值的占位符来记录SQL。 因此,而不是select name from User where id = ? ...
Spring项目配置文件(整合security、hibernate、fckeditor、jdbc、log4j)
一、 项目名称:ssh 项目原型:Struts2.3.20 + Spring4.1.6 + Hibernate4.3.9 ...同时使用了Struts2、Spring4、Hibernate4、log4j、slf4j、junit4、ehcache等库或框架,搭建一个最基本的项目原型。
org.hibernate.TransactionException: JDBC rollback failed
该资源使用了众多的java软件开发项目用到的基本内容,包含jsf,ajax技术,hibernate映射,log4j记录日志和dom4j解析xml以及使用的dwr使用的ajax技术以及基本的ajax应用,数据库使用的是mysql。演示的是用户注册系统,...
#hibernate.connection.driver_class weblogic.jdbc.mssqlserver4.Driver #hibernate.connection.url jdbc:weblogic:mssqlserver4:1E1:1433 ## Microsoft Driver (not recommended!) #hibernate.connection.driver_...
oracle的jdbc驱动程序,用这个版本的操作Clob,blob类型的数据很方便。 博文链接:https://zhenjw.iteye.com/blog/173419
distribution-3.3.2.GA-dist.zip+commons-lang-2.3.jar+slf4j-api-1.5.8.jar+log4j-1.2.16.jar+ojdbc14.jar+mysql-connector-java-5.0.7-bin.jar 包含hibernate配置所需的所有jar包和oracle,mysql的jdbc驱动包
4. 编辑spy.properties文件,把JDBC Driver Class Name作为RealDriverName的值,其它的属性一般不用指定. 5. 把spy.properties放到合适的目录下,一定要让App能够找着,如果是webapp就放在webapp/WEB-INF/classess...
hibernate,SQLserver和MySQL的JDBC, log4j和log4j的配置文件(已经写好的)
6.2 建立Log4j的开发环境 6.2.1 下载Log4j 6.2.2 配置Log4j 6.3 Log4j的使用方法 6.3.1 配置Log4j 6.3.2 配置根Logger 6.3.3 指定日志输出位置 6.3.4 指定日志输出格式 6.3.5 指定日志输出优先级 6.3.6 在代码中使用...
log4j-api-2.11.1.jar log4j-core-2.11.1.jar mysql-connector-java-8.0.13.jar ognl-3.1.21.jar spring-aop-4.3.1.RELEASE.jar spring-aspects-4.3.1.RELEASE.jar spring-jdbc-4.3.1.RELEASE.jar spring-orm-4.3.1....
log4j-1.2.11.jar (1.2.11) - Log4j Library - runtime, optional junit-3.8.1.jar (3.8.1) - JUnit test framework - buildtime dom4j-1.6.1.jar (1.6.1) - XML configuration & mapping parser - runtime, ...
6.2 建立Log4j的开发环境 6.2.1 下载Log4j 6.2.2 配置Log4j 6.3 Log4j的使用方法 6.3.1 配置Log4j 6.3.2 配置根Logger 6.3.3 指定日志输出位置 6.3.4 指定日志输出格式 6.3.5 指定日志输出优先级 6.3.6 在代码中使用...
第8篇为工具篇,内容包括在Java Web项目中常用的开源工具框架、主要有版本管理工具SVN、日志工具commons-logging与Log4J、报表图形引擎JFreeChart、PDF组件iText等;第9篇为实战篇,内容为两个典型的应用系统:论坛...
在《开发者突击:Java Web主流框架整合开发(J2EE+Struts+Hibernate+Spring)》架构讲解的过程中,穿插介绍了JDBC、Log4j、Sitemesh、JUnit技术。 随书附赠光盘内容包括《开发者突击:Java Web主流框架整合开发(J2EE+...
spring-expression-3.0.7.RELEASE.jar,spring-hibernate3.jar,spring-jms-3.0.7.RELEASE.jar,spring-tx-3.0.7.RELEASE.jar,spring-web-3.0.7.RELEASE.jar,sqljdbc4.jar,stax2-api-3.1.1.jar,velocity-1.7.jar,WHICH_...
6.2 建立Log4j的开发环境 6.2.1 下载Log4j 6.2.2 配置Log4j 6.3 Log4j的使用方法 6.3.1 配置Log4j 6.3.2 配置根Logger 6.3.3 指定日志输出位置 6.3.4 指定日志输出格式 6.3.5 指定日志输出优先级 6.3.6 在代码中使用...
### 技术简介 本项目采用SpringBoot作为框架。 * 数据持久层使用SpringBoot自带的Hibernate来维护PO...* 日志管理使用Log4j,通过使用Log4j,我们可以控制日志信息输送的目的地是控制台、文件,方便在开发环境中
logging.jar log4j-1.2.14.jar spring-dao.jar spring-hibernate3.jar spring-ibatis.jar spring-jdbc.jar spring-jdo.jar spring-jpa.jar spring-toplink.jar persistence.jar ...