单元测试中使用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
4.application-test.xml:
<!-- For Test Environment -->
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>