I have seen a similar (if not the same error). When you use dbcpb & spring you must keep in mind that the properties will be set on the JDBC driver instance using reflection. In some cases this can be source of problems.
Anyway here is something that works for me (using managed datasource):
<bean id="myDataSource" class="org.apache.commons.dbcp.managed.BasicManagedDataSource" destroy-method="close">
<property name="driverClassName" value="${db.driver.class}"/>
<property name="url" value="${db.url}"/>
<property name="username" value="${db.user}"/>
<property name="password" value="${db.password}"/>
<property name="maxIdle" value="10"/>
<property name="maxActive" value="100"/>
<property name="maxWait" value="10000"/>
<property name="validationQuery" value="select 1 from dual"/>
<property name="testOnBorrow" value="false"/>
<property name="testWhileIdle" value="true"/>
<property name="timeBetweenEvictionRunsMillis" value="1200000"/>
<property name="minEvictableIdleTimeMillis" value="1800000"/>
<property name="numTestsPerEvictionRun" value="5"/>
<property name="defaultAutoCommit" value="false"/>
<property name="transactionManager" ref="transactionManager"/>
</bean>
I have tried that using version 10.2.0.2 oracle driver from springsource ebr and dbcp version 1.4.
db.url = jdbc:oracle:thin:@${IP}:${PORT}:${DB}
db.driver.class = oracle.jdbc.driver.OracleDriver
I have successfully deployed that inside karaf.
Partager