单元测试中使用jdcblogger观察打印的sql
单元测试中使用jdcblogger观察打印的sql1.log4j:
#loghibernate 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>
页:
[1]