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

highriver

单元测试中使用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>