Object has been closed

[silly_me]

hi All,

I'm using MS-SQL server as the backend db with Spring 1.2.1 using the ibatis 2.0 data mapping layer.

I'm getting this error: "Object has been closed"

My transaction setting is:

	<bean id="baseTransactionProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"
		  abstract="true">
		<property name="transactionManager"><ref bean="transactionManager"/></property>
		<property name="transactionAttributes">
			<props>
				<prop key="insert*">PROPAGATION_REQUIRED</prop>
				<prop key="update*">PROPAGATION_REQUIRED</prop>
				<prop key="*">PROPAGATION_REQUIRED</prop>
			</props>
		</property>
	</bean>

I'm using the Commons DBCP BasicDataSource with the following settings:

# ---------- Data Source Pool Configuration --------------
emod.jdbc.datasource.initialSize=5
emod.jdbc.datasource.maxActive=20
emod.jdbc.datasource.maxIdle=10
emod.jdbc.datasource.maxWait=20000
emod.jdbc.datasource.poolPreparedStatements=false

I'm using the branded OEM DataDirect jdbc drivers. Interestingly, when I revert to using the Inet sprinta2000.jar driver, I don't encounter this error.. any ideas?

Thanks

[Rod Johnson]

Please post the stack trace--at least as far as the Spring transaction layer.

[silly_me]

Here's the stack trace from my junit test.

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC connection for transaction; nested exception is java.sql.SQLException: [sebl][SQLServer JDBC Driver]Object has been closed.
java.sql.SQLException: [sebl][SQLServer JDBC Driver]Object has been closed.
	at com.siebel.sem.jdbc.base.BaseExceptions.createException(Unknown Source)
	at com.siebel.sem.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.siebel.sem.jdbc.base.BaseConnection.getMetaData(Unknown Source)
	at org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConnection.java:222)
	at org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor.doGetNativeConnection(SimpleNativeJdbcExtractor.java:159)
	at org.springframework.jdbc.support.nativejdbc.NativeJdbcExtractorAdapter.getNativeConnection(NativeJdbcExtractorAdapter.java:87)
	at com.siebel.sem.emod.server.datasource.EmodDelegateDataSource.getConnection(EmodDelegateDataSource.java:68)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:170)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:234)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:217)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:50)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
	at $Proxy0.addSchedule(Unknown Source)
	at com.siebel.sem.emod.server.dao.test.ScheduleDaoTest.testAddSchedule(ScheduleDaoTest.java:52)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at junit.framework.TestCase.runTest(TestCase.java:154)
	at junit.framework.TestCase.runBare(TestCase.java:127)
	at junit.framework.TestResult$1.protect(TestResult.java:106)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.framework.TestResult.run(TestResult.java:109)
	at junit.framework.TestCase.run(TestCase.java:118)
	at junit.framework.TestSuite.runTest(TestSuite.java:208)
	at junit.framework.TestSuite.run(TestSuite.java:203)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)