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

    UnsupportedOperationException: Not supported by BasicDataSource for oracle

    Hitha Alex Newbie

      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