2 Replies Latest reply on Nov 24, 2010 4:08 AM by davsclaus

    UnsupportedOperationException: Not supported by BasicDataSource for oracle

    jamhit

      Hello,

       

      Have any one encountered the error below while tryiing to make jdbc connection for oracle and if so, appreciate any feed back on suggestions to overcome. I am following the jpa-osgi example, but with oracle.

       

      fuse SMX esb version 4.3

      common-dbcp:1.2.2

      Oracle data source definition:

       

       

      <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"

       

       

      destroy-method="close">

       

       

      <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />

       

       

      <property name="url" value="jdbc:oracle:thin:@xxxxxxxx:xxxxxxx:xxxxxxx" />

       

       

      <property name="username" value="xxxxxxxxx" />

       

       

      <property name="password" value="xxxxxx" />

       

       

      </bean>

       

       

      Stack trace:

       

      Caused by: java.lang.UnsupportedOperationException: Not supported by BasicDataSource

      at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:899)185:org.apache.servicemix.bundles.commons-dbcp:1.2.2.5

      at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:43)195:com.springsource.org.hibernate:3.3.2.GA

      at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)195:com.springsource.org.hibernate:3.3.2.GA

      at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)195:com.springsource.org.hibernate:3.3.2.GA

      at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)195:com.springsource.org.hibernate:3.3.2.GA

      at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)195:com.springsource.org.hibernate:3.3.2.GA

      at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354)195:com.springsource.org.hibernate:3.3.2.GA

      at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:38)195:com.springsource.org.hibernate:3.3.2.GA

      at org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:70)196:org.springframework.orm:3.0.3.RELEASE

      at org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:55)196:org.springframework.orm:3.0.3.RELEASE

      at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:332)[196:org.springframework.orm:3.0.3.RELEASE

       

      Edited by: jamhit on Nov 23, 2010 6:25 AM