[c3p0-users] Newbie- Trying to understand the Error Message

[Russ R. <rus...@gm...>]

Sorry if this is a simple question.....  I am attempting to understand
the error message since my test are passing but C3PO is throwing
exceptions.    Any suggestions would be greatly appreciated.

11:40:24,885  INFO GenericApplicationContext:1002 - Closing
org.springframework.context.support.GenericApplicationContext@16e1fb1:
startup date [Tue May 31 11:40:20 EDT 2011]; root of context hierarchy
11:40:24,885  INFO DefaultListableBeanFactory:422 - Destroying
singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1c5ddc9:
defining beans [** List of All Beans**]; root of factory hierarchy
11:40:24,885 DEBUG ActiveManagementCoordinator:133 - MBean:
com.mchange.v2.c3p0:type=PooledDataSource[2ue0rb8gjmbvcaiq6rcl|c3e82b]
unregistered.
11:40:24,885 DEBUG ThreadPoolAsynchronousRunner:578 -
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#17,5,main]
interrupted. Shutting down.
11:40:24,901 DEBUG ThreadPoolAsynchronousRunner:578 -
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#12,5,main]
interrupted. Shutting down.
11:40:24,901 DEBUG ThreadPoolAsynchronousRunner:578 -
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#4,5,main]
interrupted. Shutting down.
11:40:24,901 DEBUG ThreadPoolAsynchronousRunner:578 -
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#10,5,main]
interrupted. Shutting down.
11:40:24,901 DEBUG ThreadPoolAsynchronousRunner:578 -
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#16,5,main]
interrupted. Shutting down.
11:40:24,901 DEBUG ThreadPoolAsynchronousRunner:578 -
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#14,5,main]
interrupted. Shutting down.
11:40:24,901 DEBUG ThreadPoolAsynchronousRunner:578 -
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
interrupted. Shutting down.
11:40:24,901 DEBUG ThreadPoolAsynchronousRunner:578 -
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#6,5,main]
interrupted. Shutting down.
11:40:24,901 DEBUG ThreadPoolAsynchronousRunner:578 -
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
interrupted. Shutting down.
11:40:24,901 DEBUG ThreadPoolAsynchronousRunner:578 -
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#13,5,main]
interrupted. Shutting down.
11:40:24,901 DEBUG AbstractPoolBackedDataSource:417 -
com.mchange.v2.c3p0.ComboPooledDataSource@c3e82b has been closed.
java.lang.Exception: DEBUG STACK TRACE for PoolBackedDataSource.close().
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.close(AbstractPoolBackedDataSource.java:417)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.beans.factory.support.DisposableBeanAdapter.invokeCustomDestroyMethod(DisposableBeanAdapter.java:273)
	at org.springframework.beans.factory.support.DisposableBeanAdapter.destroy(DisposableBeanAdapter.java:199)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:487)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingleton(DefaultSingletonBeanRegistry.java:463)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:431)
	at org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1048)
	at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1022)
	at org.springframework.context.support.AbstractApplicationContext$3.run(AbstractApplicationContext.java:940)



My configuration is as follows:

<bean id="myDataSource"
class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
        <property name="driverClass">
            <value>oracle.jdbc.driver.OracleDriver</value>
        </property>
        <property name="jdbcUrl"><value>jdbc:oracle:thin:@[my database
server]:1521:[my database]</value></property>
        <property name="user"><value>****</value></property>
        <property name="password"><value>****</value></property>
        <property name="acquireIncrement">
            <value>3</value>
        </property>
        <property name="minPoolSize">
            <value>1</value>
        </property>
        <property name="maxPoolSize">
            <value>3</value>
        </property>
        <property name="maxStatementsPerConnection">
            <value>100</value>
        </property>
        <property name="numHelperThreads">
            <value>20</value>
        </property>
        <property name="acquireRetryAttempts" value="5"/>
        <property name="acquireRetryDelay" value="1000"/>
        <property name="maxConnectionAge" value="60000"/>
        <property name="testConnectionOnCheckout" value="true"/>
    </bean>

Thanks,

HD