If you look at the stack trace closely you see that :org.apache.aries.transaction.jdbc seems to handle the DSF. So it looks like there is a conflict between pax-jdbc-dbcp2 and aries transaction. Can you try uninstalling aries transaction jdbc? Do you have any idea why it is installed?
Christian 2016-06-30 20:18 GMT+02:00 dpravin <[email protected]>: > Hello, > > We are exploring to use pax-jdbc component/utility for managing database > connections. > > My environment is, > > Jboss Fuse 6.2.1 > pax-jdbc 0.9.0 > Oracle - 11.2.0.4.0 > > Installed following features from pax-jdbc, > > >features:install transaction jndi pax-jdbc-oracle pax-jdbc-pool-dbcp2 > pax-jdbc-config > > > I am trying to create a XA connection pool for Oracle database with > following properties, > > dataSourceName = abc > datasource.name=abc > osgi.jndi.service.name = abc > osgi.jdbc.driver.name = oracle-pool-xa > url = jdbc:oracle:thin:@//<<servername>>:1521/<<sid>> > user = user > password = pwd > pool.maxTotal = 3 > > I use following to get reference to data source in a Camel blueprint > > <reference id="abc" interface="javax.sql.DataSource" > availability="mandatory" filter="(datasource.name=abc)"/> > > I am getting following errors when I invoke a getConnection() on the > datasource, > > ****************************** > > Caused by: java.lang.UnsupportedOperationException > at > > org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:156)[307:org.apache.commons.dbcp2:2.1.0] > at > > org.tranql.connector.jdbc.AbstractLocalDataSourceMCF.getPhysicalConnection(AbstractLocalDataSourceMCF.java:72)[281:org.apache.aries.transaction.jdbc:2.1.1] > at > > org.tranql.connector.jdbc.AbstractLocalDataSourceMCF.createManagedConnection(AbstractLocalDataSourceMCF.java:66)[281:org.apache.aries.transaction.jdbc:2.1.1] > at > > org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:48)[282:org.apache.geronimo.components.geronimo-connector:3.1.1] > at > > org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)[282:org.apache.geronimo.components.geronimo-connector:3.1.1] > at > > org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:70)[282:org.apache.geronimo.components.geronimo-connector:3.1.1] > at > > org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:80)[282:org.apache.geronimo.components.geronimo-connector:3.1.1] > at > > org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:49)[282:org.apache.geronimo.components.geronimo-connector:3.1.1] > at > > org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:109)[282:org.apache.geronimo.components.geronimo-connector:3.1.1] > at > > org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43)[282:org.apache.geronimo.components.geronimo-connector:3.1.1] > at > > org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)[282:org.apache.geronimo.components.geronimo-connector:3.1.1] > at > > org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66)[282:org.apache.geronimo.components.geronimo-connector:3.1.1] > at > > org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:81)[282:org.apache.geronimo.components.geronimo-connector:3.1.1] > at > > org.tranql.connector.jdbc.TranqlDataSource.getConnection(TranqlDataSource.java:62)[281:org.apache.aries.transaction.jdbc:2.1.1] > at Proxybaa265ff_652c_44b3_9c20_b47e2464e11a.getConnection(Unknown > Source)[:] > > *************************** > > Appreciate if someone can help me resolve this issue. > > Thanks, > Pravin > > > > > > -- > View this message in context: > http://karaf.922171.n3.nabble.com/pax-jdbc-dbcp2-and-oracle-connection-pooling-tp4047028.html > Sent from the Karaf - User mailing list archive at Nabble.com. > -- -- Christian Schneider http://www.liquid-reality.de <https://owa.talend.com/owa/redir.aspx?C=3aa4083e0c744ae1ba52bd062c5a7e46&URL=http%3a%2f%2fwww.liquid-reality.de> Open Source Architect http://www.talend.com <https://owa.talend.com/owa/redir.aspx?C=3aa4083e0c744ae1ba52bd062c5a7e46&URL=http%3a%2f%2fwww.talend.com>
