单元测试中使用jdcblogger观察打印的sql

单元测试中使用jdcblogger观察打印的sql

1.log4j:
#log  hibernate execute sql
log4j.logger.net.sourceforge.jdbclogger=DEBUG

2.添加一个配置文件名为jdbclogger.properties，里面添加一行：
jdbclogger.driver=org.postgresql.Driver


3.pom.xml

<repository>
    <id>jdbclogger</id>
    <name>JDBC Logger private repo</name>
    <url>http://jdbclogger.sourceforge.net/m2-repo/</url>
    <releases>
        <enabled>true</enabled>
    </releases>
    <snapshots>
        <enabled>false</enabled>
    </snapshots>
</repository>


<dependency>
    <groupId>net.sourceforge.jdbclogger</groupId>
    <artifactId>jdbclogger</artifactId>
    <version>0.6</version>
</dependency>


jdbclogger依赖三个jar，可以看情况选择使用：
<dependency>
    <groupId>net.sourceforge.jdbclogger</groupId>
    <artifactId>jdbclogger-core</artifactId>
    <version>0.6</version>
</dependency>

<dependency>
    <groupId>net.sourceforge.jdbclogger</groupId>
    <artifactId>jdbclogger-oracle</artifactId>
    <version>0.6</version>
</dependency>

<dependency>
    <groupId>net.sourceforge.jdbclogger</groupId>
    <artifactId>jdbclogger-spring</artifactId>
    <version>0.6</version>
</dependency>

4.application-test.xml：
<!-- For Test Environment -->

<bean id="dataSource"
	class="org.springframework.jdbc.datasource.DriverManagerDataSource">
	<property name="driverClassName" value="org.postgresql.Driver" />
	<property name="url" value="jdbc:postgresql://localhost/hopsurf_empty" />
	<property name="username" value="root" />
	<property name="password" value="passed" />
</bean>

<bean id="jdbcLoggerConfig"
	class="net.sourceforge.jdbclogger.spring.JdbcLoggerBeanPostProcessor">
	<property name="targetDriverClassNames">
		<list>
			<value>org.postgresql.Driver</value>
		</list>
	</property>
</bean>

评论

2 楼 highriver 2009-06-24  

我不清楚后者会不会连sql中的变量一并打印出来，jdbclogger可以。

1 楼 ▄︻┳═一 2009-06-24  

log4j.logger.java.sql=DEBUG
也能打出sql
不知道jdbclogger有啥优点？