Hi Freeman,
I have added the classpath in xbeans.xml of SA zip and the earlier error
seems to be resolved. Many thanks for the help.
SA has started without any issues but I am getting one of the below
exceptions when querying DB2 8.x database:
1. Caused by: java.sql.SQLException:
com.mchange.v2.c3p0.ComboPooledDataSource [
java.beans.IntrospectionException:
java.lang.reflect.InvocationTargetException
[numThreadsAwaitingCheckoutDefaultUser] ] has been closed() -- you can no
longer use it.
at
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.assertCpds(AbstractPoolBackedDataSource.java:447)[c3p0-0.9.1.2.jar:0.9.1.2]
at
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager(AbstractPoolBackedDataSource.java:459)[c3p0-0.9.1.2.jar:0.9.1.2]
at
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)[c3p0-0.9.1.2.jar:0.9.1.2]
at
org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:200)[spring-2.5.6.jar:2.5.6]
Below is my datasource bean definition:
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close" lazy-init="default" autowire="default"
dependency-check="default">
<property name="driverClass" value="com.ibm.db2.jcc.DB2Driver"/>
<property name="jdbcUrl" value="jdbc:db2://server:port/DB"/>
<property name="user" value="username"/>
<property name="password" value="password"/>
<property name="initialPoolSize" value="2"/>
<property name="minPoolSize" value="5"/>
<property name="maxPoolSize" value="10"/>
<property name="acquireIncrement" value="1"/>
<property name="acquireRetryDelay" value="60000"/>
<property name="debugUnreturnedConnectionStackTraces" value="true"/>
<property name="maxIdleTime" value="30"/>
<property name="unreturnedConnectionTimeout" value="300000"/>
<property name="checkoutTimeout" value="300000"/>
<property name="idleConnectionTestPeriod" value="600000"/>
<property name="numThreadsAwaitingCheckoutDefaultUser" value="10"/>
</bean>
2.
21:24:41,112 | ERROR | rovider-thread-3 | DefaultComponent |
172 - servicemix-common - 2011.02.0 | Error processing exchange
org.apache.servicemix.jbi.runtime.impl.InOnlyImpl@168cd47
java.lang.Error: SQLWarning chain holds value that is not a SQLWarning
at java.sql.SQLWarning.getNextWarning(SQLWarning.java:184)[:1.6.0_34]
at
org.springframework.jdbc.core.JdbcTemplate.handleWarnings(JdbcTemplate.java:1220)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:592)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721)
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:732)
at
org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:759)
I am getting different error when i delete the data folder and restart smx4.
I think it is not even getting the db connection. Could you please suggest?
--
View this message in context:
http://servicemix.396122.n5.nabble.com/Failed-to-convert-property-value-to-required-type-org-aopalliance-aop-Advice-for-property-advice-tp5714672p5714685.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
