ansaurus

Question

Problem with dbUnit: java.sql.SQLException: Closed Statement

Answer 1

A:

I guess some of your tests close the database connection when they clean up. The next test tries to use this connection again for the import and fails.

tangens 2009-10-21 15:10:30

I don't close connection explicitly in any of the test. All of them use use jdbcTemplate from Spring DAO library, so I don't need to operate with connections manually. Connections are closed in import function, but this function is the same for all tests.

dbf 2009-10-21 15:13:47

Which datasource do you use? Is it the `SingleConnectionDataSource`?

tangens 2009-10-21 16:21:17

Datasource description from my Spring config:<bean id="DataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" lazy-init="true" singleton="true"> <property name="driverClassName" value="${jdbc.driver.class}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> <property name="poolPreparedStatements" value="true"/> <property name="maxOpenPreparedStatements" value="20"/> </bean>

dbf 2009-10-21 17:40:36

ansaurus

tags:

views:

answers:

Problem with dbUnit: java.sql.SQLException: Closed Statement

related questions