You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@karaf.apache.org by Alex Soto <al...@envieta.com> on 2019/12/03 20:12:53 UTC

Pax-JDBC, Derby, XA Datasource Error

Hello, 

Using PAX-JDBC version 1.3.0 I am unable to configure XA data source.
The error I am getting is: 

	Error creating pooled datasource: not supported - use a driver adapter org.ops4j.pax.jdbc.<subprotocol>


My data source config file is:


osgi.jdbc.driver.name = derby
dataSourceName=responder
url = jdbc:derby:data/derby-data/test;create=true

user=XXX
password=XXX
databaseName=responder

ops4j.preHook=responderDB

#Pool Config
pool=dbcp2
xa=true
jdbc.pool.maxTotal=8
jdbc.pool.minIdle=2
jdbc.pool.maxIdle=4


Entire Stack trace is:


2019-12-03T15:06:26,678 | ERROR | features-3-thread-1 | DbcpXAPooledDataSourceFactory    | 218 - org.ops4j.pax.jdbc.pool.dbcp2 - 1.3.0 | Error creating pooled datasource: not supported - use a driver adapter org.ops4j.pax.jdbc.<subprotocol>
java.sql.SQLException: not supported - use a driver adapter org.ops4j.pax.jdbc.<subprotocol>
	at org.ops4j.pax.jdbc.impl.DriverDataSourceFactory.createXADataSource(DriverDataSourceFactory.java:53) ~[?:?]
	at org.ops4j.pax.jdbc.pool.dbcp2.impl.DbcpXAPooledDataSourceFactory.create(DbcpXAPooledDataSourceFactory.java:74) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.PoolingWrapper.createDataSource(PoolingWrapper.java:44) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:139) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:83) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$0(DataSourceConfigManager.java:85) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870) ~[?:?]
	at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256) ~[?:?]
	at org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$1(DataSourceConfigManager.java:81) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870) ~[?:?]
	at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256) ~[?:?]
	at org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:88) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$2(DataSourceConfigManager.java:80) ~[?:?]
	at org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870) ~[?:?]
	at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256) ~[?:?]
	at org.osgi.util.tracker.AbstractTracked.track(AbstractTracked.java:229) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:901) ~[?:?]
	at org.apache.felix.framework.EventDispatcher.invokeServiceListenerCallback(EventDispatcher.java:990) ~[?:?]
	at org.apache.felix.framework.EventDispatcher.fireEventImmediately(EventDispatcher.java:838) ~[?:?]
	at org.apache.felix.framework.EventDispatcher.fireServiceEvent(EventDispatcher.java:545) ~[?:?]
	at org.apache.felix.framework.Felix.fireServiceEvent(Felix.java:4595) ~[?:?]
	at org.apache.felix.framework.Felix.registerService(Felix.java:3587) ~[?:?]
	at org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:348) ~[?:?]
	at org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:355) ~[?:?]
	at org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:55) ~[?:?]
	at org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:48) ~[?:?]
	at org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:60) ~[?:?]
	at org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:32) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870) ~[?:?]
	at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256) ~[?:?]
	at org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318) ~[?:?]
	at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261) ~[?:?]
	at org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator.start(Activator.java:59) ~[?:?]
	at org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:697) ~[?:?]
	at org.apache.felix.framework.Felix.activateBundle(Felix.java:2240) ~[?:?]
	at org.apache.felix.framework.Felix.startBundle(Felix.java:2146) ~[?:?]
	at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:998) ~[?:?]
	at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:984) ~[?:?]
	at org.apache.karaf.features.internal.service.BundleInstallSupportImpl.startBundle(BundleInstallSupportImpl.java:165) ~[?:?]
	at org.apache.karaf.features.internal.service.FeaturesServiceImpl.startBundle(FeaturesServiceImpl.java:1153) ~[?:?]
	at org.apache.karaf.features.internal.service.Deployer.deploy(Deployer.java:1036) ~[?:?]
	at org.apache.karaf.features.internal.service.FeaturesServiceImpl.doProvision(FeaturesServiceImpl.java:1062) ~[?:?]
	at org.apache.karaf.features.internal.service.FeaturesServiceImpl.lambda$doProvisionInThread$13(FeaturesServiceImpl.java:998) ~[?:?]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:?]
	at java.lang.Thread.run(Thread.java:748) [?:?]


Any idea what this error means?

Best regards,
Alex soto





Re: Pax-JDBC, Derby, XA Datasource Error

Posted by Alex Soto <al...@envieta.com>.
Actually, here the various combinations I tried:

XA    |  javax.persistence.transactionType |  Error   
——---—|—————————————————————————————————————————————
True  |  JTA                               | not supported - use a driver adapter org.ops4j.pax.jdbc.<subprotocol>        
False |  JTA                               | Explicitly joining a JTA transaction requires a JTA transaction be currently active
True  |  RESOURCE_LOCAL                    | not supported - use a driver adapter org.ops4j.pax.jdbc.<subprotocol>
False |  RESOURCE_LOCAL                    | no errors



Best regards,
Alex soto




> On Dec 4, 2019, at 8:48 AM, Alex Soto <al...@envieta.com> wrote:
> 
> Hi JB:
> 
> I have added to my features.xml:
> 
> <feature>transaction</feature>
> 
> My Karaf version is: 4.2.6 
> 
> Best regards,
> Alex soto
> 
> 
> 
> 
>> On Dec 4, 2019, at 8:26 AM, jb@nanthrax.net wrote:
>> 
>> Hi
>> 
>> Do you have a transaction manager like narayana or transx installed in Karaf ?
>> 
>> Regards
>> JB
>> 
>> 
>> 
>> Le 4 déc. 2019 14:23, Alex Soto <al...@envieta.com> a écrit :
>> Yes,
>> 
>> Everything works as soon as I comment out the the line `xa=true`
>> 
>> 
>> Best regards,
>> Alex soto
>> 
>> 
>> 
>> 
>> On Dec 3, 2019, at 10:16 PM, Jean-Baptiste Onofré <jb...@nanthrax.net> wrote:
>> 
>> Hi Alex,
>> 
>> do you have jdbc and pax-jdbc-derby features installed ?
>> 
>> I guess your config file looks like
>> etc/org.ops4j.datasource-responder.cfg right ?
>> 
>> Regards
>> JB
>> 
>> On 03/12/2019 21:12, Alex Soto wrote:
>> Hello, 
>> 
>> Using PAX-JDBC version 1.3.0 I am unable to configure XA data source.
>> The error I am getting is: 
>> 
>> Error creating pooled datasource: not supported - use a driver adapter
>> org.ops4j.pax.jdbc.<subprotocol>
>> 
>> 
>> My data source config file is:
>> 
>> 
>>    osgi.jdbc.driver.name = derby
>>    dataSourceName=responder
>>    url = jdbc:derby:data/derby-data/test;create=true
>> 
>>    user=XXX
>>    password=XXX
>>    databaseName=responder
>> 
>>    ops4j.preHook=responderDB
>> 
>>    #Pool Config
>>    pool=dbcp2
>>    xa=true
>>    jdbc.pool.maxTotal=8
>>    jdbc.pool.minIdle=2
>>    jdbc.pool.maxIdle=4
>> 
>> 
>> 
>> Entire Stack trace is:
>> 
>> 
>>    2019-12-03T15:06:26,678 | ERROR | features-3-thread-1 |
>>    DbcpXAPooledDataSourceFactory    | 218 -
>>    org.ops4j.pax.jdbc.pool.dbcp2 - 1.3.0 | Error creating
>>    pooled datasource: not supported - use a driver adapter
>>    org.ops4j.pax.jdbc.<subprotocol>
>>    java.sql.SQLException: not supported - use a driver adapter
>>    org.ops4j.pax.jdbc.<subprotocol>
>>    at
>>    org.ops4j.pax.jdbc.impl.DriverDataSourceFactory.createXADataSource(DriverDataSourceFactory.java:53)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.dbcp2.impl.DbcpXAPooledDataSourceFactory.create(DbcpXAPooledDataSourceFactory.java:74)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.PoolingWrapper.createDataSource(PoolingWrapper.java:44)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:139)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:83)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$0(DataSourceConfigManager.java:85)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$1(DataSourceConfigManager.java:81)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:88)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$2(DataSourceConfigManager.java:80)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.track(AbstractTracked.java:229) ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:901)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.EventDispatcher.invokeServiceListenerCallback(EventDispatcher.java:990)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.EventDispatcher.fireEventImmediately(EventDispatcher.java:838)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.EventDispatcher.fireServiceEvent(EventDispatcher.java:545)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.Felix.fireServiceEvent(Felix.java:4595)
>>    ~[?:?]
>>    at org.apache.felix.framework.Felix.registerService(Felix.java:3587)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:348)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:355)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:55)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:48)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:60) ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:32) ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator.start(Activator.java:59) ~[?:?]
>>    at
>>    org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:697)
>>    ~[?:?]
>>    at org.apache.felix.framework.Felix.activateBundle(Felix.java:2240)
>>    ~[?:?]
>>    at org.apache.felix.framework.Felix.startBundle(Felix.java:2146) ~[?:?]
>>    at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:998)
>>    ~[?:?]
>>    at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:984)
>>    ~[?:?]
>>    at
>>    org.apache.karaf.features.internal.service.BundleInstallSupportImpl.startBundle(BundleInstallSupportImpl.java:165)
>>    ~[?:?]
>>    at
>>    org.apache.karaf.features.internal.service.FeaturesServiceImpl.startBundle(FeaturesServiceImpl.java:1153)
>>    ~[?:?]
>>    at
>>    org.apache.karaf.features.internal.service.Deployer.deploy(Deployer.java:1036)
>>    ~[?:?]
>>    at
>>    org.apache.karaf.features.internal.service.FeaturesServiceImpl.doProvision(FeaturesServiceImpl.java:1062)
>>    ~[?:?]
>>    at
>>    org.apache.karaf.features.internal.service.FeaturesServiceImpl.lambda$doProvisionInThread$13(FeaturesServiceImpl.java:998)
>>    ~[?:?]
>>    at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:?]
>>    at
>>    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>>    [?:?]
>>    at
>>    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>>    [?:?]
>>    at java.lang.Thread.run(Thread.java:748) [?:?]
>> 
>> 
>> 
>> Any idea what this error means?
>> 
>> Best regards,
>> Alex soto
>> 
>> 
>> 
>> 
>> 
>> -- 
>> Jean-Baptiste Onofré
>> jbonofre@apache.org
>> http://blog.nanthrax.net
>> Talend - http://www.talend.com
>> 
>> 
> 


Re: Pax-JDBC, Derby, XA Datasource Error

Posted by Alex Soto <al...@envieta.com>.
Hi JB:

I have added to my features.xml:

<feature>transaction</feature>

My Karaf version is: 4.2.6 

Best regards,
Alex soto




> On Dec 4, 2019, at 8:26 AM, jb@nanthrax.net wrote:
> 
> Hi
> 
> Do you have a transaction manager like narayana or transx installed in Karaf ?
> 
> Regards
> JB
> 
> 
> 
> Le 4 déc. 2019 14:23, Alex Soto <al...@envieta.com> a écrit :
> Yes,
> 
> Everything works as soon as I comment out the the line `xa=true`
> 
> 
> Best regards,
> Alex soto
> 
> 
> 
> 
> On Dec 3, 2019, at 10:16 PM, Jean-Baptiste Onofré <jb@nanthrax.net <ma...@nanthrax.net>> wrote:
> 
> Hi Alex,
> 
> do you have jdbc and pax-jdbc-derby features installed ?
> 
> I guess your config file looks like
> etc/org.ops4j.datasource-responder.cfg right ?
> 
> Regards
> JB
> 
> On 03/12/2019 21:12, Alex Soto wrote:
> Hello, 
> 
> Using PAX-JDBC version 1.3.0 I am unable to configure XA data source.
> The error I am getting is: 
> 
> Error creating pooled datasource: not supported - use a driver adapter
> org.ops4j.pax.jdbc.<subprotocol>
> 
> 
> My data source config file is:
> 
> 
>    osgi.jdbc.driver.name = derby
>    dataSourceName=responder
>    url = jdbc:derby:data/derby-data/test;create=true
> 
>    user=XXX
>    password=XXX
>    databaseName=responder
> 
>    ops4j.preHook=responderDB
> 
>    #Pool Config
>    pool=dbcp2
>    xa=true
>    jdbc.pool.maxTotal=8
>    jdbc.pool.minIdle=2
>    jdbc.pool.maxIdle=4
> 
> 
> 
> Entire Stack trace is:
> 
> 
>    2019-12-03T15:06:26,678 | ERROR | features-3-thread-1 |
>    DbcpXAPooledDataSourceFactory    | 218 -
>    org.ops4j.pax.jdbc.pool.dbcp2 - 1.3.0 | Error creating
>    pooled datasource: not supported - use a driver adapter
>    org.ops4j.pax.jdbc.<subprotocol>
>    java.sql.SQLException: not supported - use a driver adapter
>    org.ops4j.pax.jdbc.<subprotocol>
>    at
>    org.ops4j.pax.jdbc.impl.DriverDataSourceFactory.createXADataSource(DriverDataSourceFactory.java:53)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.pool.dbcp2.impl.DbcpXAPooledDataSourceFactory.create(DbcpXAPooledDataSourceFactory.java:74)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.PoolingWrapper.createDataSource(PoolingWrapper.java:44)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:139)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:83)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$0(DataSourceConfigManager.java:85)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$1(DataSourceConfigManager.java:81)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:88)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$2(DataSourceConfigManager.java:80)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.AbstractTracked.track(AbstractTracked.java:229) ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:901)
>    ~[?:?]
>    at
>    org.apache.felix.framework.EventDispatcher.invokeServiceListenerCallback(EventDispatcher.java:990)
>    ~[?:?]
>    at
>    org.apache.felix.framework.EventDispatcher.fireEventImmediately(EventDispatcher.java:838)
>    ~[?:?]
>    at
>    org.apache.felix.framework.EventDispatcher.fireServiceEvent(EventDispatcher.java:545)
>    ~[?:?]
>    at
>    org.apache.felix.framework.Felix.fireServiceEvent(Felix.java:4595)
>    ~[?:?]
>    at org.apache.felix.framework.Felix.registerService(Felix.java:3587)
>    ~[?:?]
>    at
>    org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:348)
>    ~[?:?]
>    at
>    org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:355)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:55)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:48)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:60) ~[?:?]
>    at
>    org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:32) ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>    ~[?:?]
>    at
>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>    ~[?:?]
>    at
>    org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator.start(Activator.java:59) ~[?:?]
>    at
>    org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:697)
>    ~[?:?]
>    at org.apache.felix.framework.Felix.activateBundle(Felix.java:2240)
>    ~[?:?]
>    at org.apache.felix.framework.Felix.startBundle(Felix.java:2146) ~[?:?]
>    at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:998)
>    ~[?:?]
>    at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:984)
>    ~[?:?]
>    at
>    org.apache.karaf.features.internal.service.BundleInstallSupportImpl.startBundle(BundleInstallSupportImpl.java:165)
>    ~[?:?]
>    at
>    org.apache.karaf.features.internal.service.FeaturesServiceImpl.startBundle(FeaturesServiceImpl.java:1153)
>    ~[?:?]
>    at
>    org.apache.karaf.features.internal.service.Deployer.deploy(Deployer.java:1036)
>    ~[?:?]
>    at
>    org.apache.karaf.features.internal.service.FeaturesServiceImpl.doProvision(FeaturesServiceImpl.java:1062)
>    ~[?:?]
>    at
>    org.apache.karaf.features.internal.service.FeaturesServiceImpl.lambda$doProvisionInThread$13(FeaturesServiceImpl.java:998)
>    ~[?:?]
>    at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:?]
>    at
>    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>    [?:?]
>    at
>    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>    [?:?]
>    at java.lang.Thread.run(Thread.java:748) [?:?]
> 
> 
> 
> Any idea what this error means?
> 
> Best regards,
> Alex soto
> 
> 
> 
> 
> 
> -- 
> Jean-Baptiste Onofré
> jbonofre@apache.org <ma...@apache.org>
> http://blog.nanthrax.net
> Talend - http://www.talend.com
> 
> 


Re: Pax-JDBC, Derby, XA Datasource Error

Posted by jb...@nanthrax.net.
Hi

  

Do you have a transaction manager like narayana or transx installed in Karaf ?

  

Regards

JB

  

  

  

Le 4 déc. 2019 14:23, Alex Soto <al...@envieta.com> a écrit :  

> Yes,

>

>  
>

>

> Everything works as soon as I comment out the the line `xa=true`

>

>  
>

>

>  
>

>

> Best regards,  
> Alex soto  
>  
>  
>  
>

>

>  
>

>

>> On Dec 3, 2019, at 10:16 PM, Jean-Baptiste Onofré
<[jb@nanthrax.net](mailto:jb@nanthrax.net)> wrote:

>>

>>  
>

>>

>> Hi Alex,  
>  
> do you have jdbc and pax-jdbc-derby features installed ?  
>  
> I guess your config file looks like  
> etc/org.ops4j.datasource-responder.cfg right ?  
>  
> Regards  
> JB  
>  
> On 03/12/2019 21:12, Alex Soto wrote:  
>

>>

>>> Hello,  
>  
> Using PAX-JDBC version 1.3.0 I am unable to configure XA data source.  
> The error I am getting is:  
>  
> Error creating pooled datasource: not supported - use a driver adapter  
> org.ops4j.pax.jdbc.<subprotocol>  
>  
>  
> My data source config file is:  
>  
>  
>  osgi.jdbc.driver.name = derby  
>  dataSourceName=responder  
>  url = jdbc:derby:data/derby-data/test;create=true  
>  
>  user=XXX  
>  password=XXX  
>  databaseName=responder  
>  
>  ops4j.preHook=responderDB  
>  
>  #Pool Config  
>  pool=dbcp2  
>  xa=true  
>  jdbc.pool.maxTotal=8  
>  jdbc.pool.minIdle=2  
>  jdbc.pool.maxIdle=4  
>  
>  
>  
> Entire Stack trace is:  
>  
>  
>  2019-12-03T15:06:26,678 | ERROR | features-3-thread-1 |  
>  DbcpXAPooledDataSourceFactory | 218 -  
>  org.ops4j.pax.jdbc.pool.dbcp2 - 1.3.0 | Error creating  
>  pooled datasource: not supported - use a driver adapter  
>  org.ops4j.pax.jdbc.<subprotocol>  
>  java.sql.SQLException: not supported - use a driver adapter  
>  org.ops4j.pax.jdbc.<subprotocol>  
>  at  
>
org.ops4j.pax.jdbc.impl.DriverDataSourceFactory.createXADataSource(DriverDataSourceFactory.java:53)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.pool.dbcp2.impl.DbcpXAPooledDataSourceFactory.create(DbcpXAPooledDataSourceFactory.java:74)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.PoolingWrapper.createDataSource(PoolingWrapper.java:44)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:139)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:83)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$0(DataSourceConfigManager.java:85)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)  
>  ~[?:?]  
>  at  
>
org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)  
>  ~[?:?]  
>  at  
>
org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)  
>  ~[?:?]  
>  at  
>  org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)  
>  ~[?:?]  
>  at  
>
org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)  
>  ~[?:?]  
>  at  
>  org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)  
>  ~[?:?]  
>  at  
>  org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$1(DataSourceConfigManager.java:81)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)  
>  ~[?:?]  
>  at  
>
org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)  
>  ~[?:?]  
>  at  
>
org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)  
>  ~[?:?]  
>  at  
>  org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)  
>  ~[?:?]  
>  at  
>
org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)  
>  ~[?:?]  
>  at  
>  org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)  
>  ~[?:?]  
>  at  
>  org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:88)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$2(DataSourceConfigManager.java:80)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)  
>  ~[?:?]  
>  at  
>
org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)  
>  ~[?:?]  
>  at  
>
org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)  
>  ~[?:?]  
>  at  
>  org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)  
>  ~[?:?]  
>  at  
>  org.osgi.util.tracker.AbstractTracked.track(AbstractTracked.java:229)
~[?:?]  
>  at  
>
org.osgi.util.tracker.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:901)  
>  ~[?:?]  
>  at  
>
org.apache.felix.framework.EventDispatcher.invokeServiceListenerCallback(EventDispatcher.java:990)  
>  ~[?:?]  
>  at  
>
org.apache.felix.framework.EventDispatcher.fireEventImmediately(EventDispatcher.java:838)  
>  ~[?:?]  
>  at  
>
org.apache.felix.framework.EventDispatcher.fireServiceEvent(EventDispatcher.java:545)  
>  ~[?:?]  
>  at  
>  org.apache.felix.framework.Felix.fireServiceEvent(Felix.java:4595)  
>  ~[?:?]  
>  at org.apache.felix.framework.Felix.registerService(Felix.java:3587)  
>  ~[?:?]  
>  at  
>
org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:348)  
>  ~[?:?]  
>  at  
>
org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:355)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:55)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:48)  
>  ~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:60)
~[?:?]  
>  at  
>
org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:32)
~[?:?]  
>  at  
>
org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)  
>  ~[?:?]  
>  at  
>
org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)  
>  ~[?:?]  
>  at  
>  org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)  
>  ~[?:?]  
>  at  
>
org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)  
>  ~[?:?]  
>  at  
>  org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)  
>  ~[?:?]  
>  at  
>  org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)  
>  ~[?:?]  
>  at  
>  org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator.start(Activator.java:59)
~[?:?]  
>  at  
>
org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:697)  
>  ~[?:?]  
>  at org.apache.felix.framework.Felix.activateBundle(Felix.java:2240)  
>  ~[?:?]  
>  at org.apache.felix.framework.Felix.startBundle(Felix.java:2146) ~[?:?]  
>  at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:998)  
>  ~[?:?]  
>  at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:984)  
>  ~[?:?]  
>  at  
>
org.apache.karaf.features.internal.service.BundleInstallSupportImpl.startBundle(BundleInstallSupportImpl.java:165)  
>  ~[?:?]  
>  at  
>
org.apache.karaf.features.internal.service.FeaturesServiceImpl.startBundle(FeaturesServiceImpl.java:1153)  
>  ~[?:?]  
>  at  
>
org.apache.karaf.features.internal.service.Deployer.deploy(Deployer.java:1036)  
>  ~[?:?]  
>  at  
>
org.apache.karaf.features.internal.service.FeaturesServiceImpl.doProvision(FeaturesServiceImpl.java:1062)  
>  ~[?:?]  
>  at  
>
org.apache.karaf.features.internal.service.FeaturesServiceImpl.lambda$doProvisionInThread$13(FeaturesServiceImpl.java:998)  
>  ~[?:?]  
>  at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:?]  
>  at  
>
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)  
>  [?:?]  
>  at  
>
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)  
>  [?:?]  
>  at java.lang.Thread.run(Thread.java:748) [?:?]  
>  
>  
>  
> Any idea what this error means?  
>  
> Best regards,  
> Alex soto  
>  
>  
>  
>  
>

>>

>>  
> \--  
> Jean-Baptiste Onofré  
> [jbonofre@apache.org](mailto:jbonofre@apache.org)  
> http://blog.nanthrax.net  
> Talend - http://www.talend.com  
>

>

>  
>

  


Re: Pax-JDBC, Derby, XA Datasource Error

Posted by Alex Soto <al...@envieta.com>.
Yes,

Everything works as soon as I comment out the the line `xa=true`


Best regards,
Alex soto




> On Dec 3, 2019, at 10:16 PM, Jean-Baptiste Onofré <jb...@nanthrax.net> wrote:
> 
> Hi Alex,
> 
> do you have jdbc and pax-jdbc-derby features installed ?
> 
> I guess your config file looks like
> etc/org.ops4j.datasource-responder.cfg right ?
> 
> Regards
> JB
> 
> On 03/12/2019 21:12, Alex Soto wrote:
>> Hello, 
>> 
>> Using PAX-JDBC version 1.3.0 I am unable to configure XA data source.
>> The error I am getting is: 
>> 
>> Error creating pooled datasource: not supported - use a driver adapter
>> org.ops4j.pax.jdbc.<subprotocol>
>> 
>> 
>> My data source config file is:
>> 
>> 
>>    osgi.jdbc.driver.name = derby
>>    dataSourceName=responder
>>    url = jdbc:derby:data/derby-data/test;create=true
>> 
>>    user=XXX
>>    password=XXX
>>    databaseName=responder
>> 
>>    ops4j.preHook=responderDB
>> 
>>    #Pool Config
>>    pool=dbcp2
>>    xa=true
>>    jdbc.pool.maxTotal=8
>>    jdbc.pool.minIdle=2
>>    jdbc.pool.maxIdle=4
>> 
>> 
>> 
>> Entire Stack trace is:
>> 
>> 
>>    2019-12-03T15:06:26,678 | ERROR | features-3-thread-1 |
>>    DbcpXAPooledDataSourceFactory    | 218 -
>>    org.ops4j.pax.jdbc.pool.dbcp2 - 1.3.0 | Error creating
>>    pooled datasource: not supported - use a driver adapter
>>    org.ops4j.pax.jdbc.<subprotocol>
>>    java.sql.SQLException: not supported - use a driver adapter
>>    org.ops4j.pax.jdbc.<subprotocol>
>>    at
>>    org.ops4j.pax.jdbc.impl.DriverDataSourceFactory.createXADataSource(DriverDataSourceFactory.java:53)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.dbcp2.impl.DbcpXAPooledDataSourceFactory.create(DbcpXAPooledDataSourceFactory.java:74)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.PoolingWrapper.createDataSource(PoolingWrapper.java:44)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:139)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:83)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$0(DataSourceConfigManager.java:85)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$1(DataSourceConfigManager.java:81)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:88)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$2(DataSourceConfigManager.java:80)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.track(AbstractTracked.java:229) ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:901)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.EventDispatcher.invokeServiceListenerCallback(EventDispatcher.java:990)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.EventDispatcher.fireEventImmediately(EventDispatcher.java:838)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.EventDispatcher.fireServiceEvent(EventDispatcher.java:545)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.Felix.fireServiceEvent(Felix.java:4595)
>>    ~[?:?]
>>    at org.apache.felix.framework.Felix.registerService(Felix.java:3587)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:348)
>>    ~[?:?]
>>    at
>>    org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:355)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:55)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:48)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:60) ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:32) ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>>    ~[?:?]
>>    at
>>    org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>>    ~[?:?]
>>    at
>>    org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator.start(Activator.java:59) ~[?:?]
>>    at
>>    org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:697)
>>    ~[?:?]
>>    at org.apache.felix.framework.Felix.activateBundle(Felix.java:2240)
>>    ~[?:?]
>>    at org.apache.felix.framework.Felix.startBundle(Felix.java:2146) ~[?:?]
>>    at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:998)
>>    ~[?:?]
>>    at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:984)
>>    ~[?:?]
>>    at
>>    org.apache.karaf.features.internal.service.BundleInstallSupportImpl.startBundle(BundleInstallSupportImpl.java:165)
>>    ~[?:?]
>>    at
>>    org.apache.karaf.features.internal.service.FeaturesServiceImpl.startBundle(FeaturesServiceImpl.java:1153)
>>    ~[?:?]
>>    at
>>    org.apache.karaf.features.internal.service.Deployer.deploy(Deployer.java:1036)
>>    ~[?:?]
>>    at
>>    org.apache.karaf.features.internal.service.FeaturesServiceImpl.doProvision(FeaturesServiceImpl.java:1062)
>>    ~[?:?]
>>    at
>>    org.apache.karaf.features.internal.service.FeaturesServiceImpl.lambda$doProvisionInThread$13(FeaturesServiceImpl.java:998)
>>    ~[?:?]
>>    at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:?]
>>    at
>>    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>>    [?:?]
>>    at
>>    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>>    [?:?]
>>    at java.lang.Thread.run(Thread.java:748) [?:?]
>> 
>> 
>> 
>> Any idea what this error means?
>> 
>> Best regards,
>> Alex soto
>> 
>> 
>> 
>> 
> 
> -- 
> Jean-Baptiste Onofré
> jbonofre@apache.org
> http://blog.nanthrax.net
> Talend - http://www.talend.com


Re: Pax-JDBC, Derby, XA Datasource Error

Posted by Jean-Baptiste Onofré <jb...@nanthrax.net>.
Hi Alex,

do you have jdbc and pax-jdbc-derby features installed ?

I guess your config file looks like
etc/org.ops4j.datasource-responder.cfg right ?

Regards
JB

On 03/12/2019 21:12, Alex Soto wrote:
> Hello, 
> 
> Using PAX-JDBC version 1.3.0 I am unable to configure XA data source.
> The error I am getting is: 
> 
> Error creating pooled datasource: not supported - use a driver adapter
> org.ops4j.pax.jdbc.<subprotocol>
> 
> 
> My data source config file is:
> 
> 
>     osgi.jdbc.driver.name = derby
>     dataSourceName=responder
>     url = jdbc:derby:data/derby-data/test;create=true
> 
>     user=XXX
>     password=XXX
>     databaseName=responder
> 
>     ops4j.preHook=responderDB
> 
>     #Pool Config
>     pool=dbcp2
>     xa=true
>     jdbc.pool.maxTotal=8
>     jdbc.pool.minIdle=2
>     jdbc.pool.maxIdle=4
> 
> 
> 
> Entire Stack trace is:
> 
> 
>     2019-12-03T15:06:26,678 | ERROR | features-3-thread-1 |
>     DbcpXAPooledDataSourceFactory    | 218 -
>     org.ops4j.pax.jdbc.pool.dbcp2 - 1.3.0 | Error creating
>     pooled datasource: not supported - use a driver adapter
>     org.ops4j.pax.jdbc.<subprotocol>
>     java.sql.SQLException: not supported - use a driver adapter
>     org.ops4j.pax.jdbc.<subprotocol>
>     at
>     org.ops4j.pax.jdbc.impl.DriverDataSourceFactory.createXADataSource(DriverDataSourceFactory.java:53)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.pool.dbcp2.impl.DbcpXAPooledDataSourceFactory.create(DbcpXAPooledDataSourceFactory.java:74)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.PoolingWrapper.createDataSource(PoolingWrapper.java:44)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:139)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:83)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$0(DataSourceConfigManager.java:85)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$1(DataSourceConfigManager.java:81)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:143)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper.track(ServiceTrackerHelper.java:88)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.lambda$null$2(DataSourceConfigManager.java:80)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.config.impl.ServiceTrackerHelper$1.addingService(ServiceTrackerHelper.java:134)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.AbstractTracked.track(AbstractTracked.java:229) ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:901)
>     ~[?:?]
>     at
>     org.apache.felix.framework.EventDispatcher.invokeServiceListenerCallback(EventDispatcher.java:990)
>     ~[?:?]
>     at
>     org.apache.felix.framework.EventDispatcher.fireEventImmediately(EventDispatcher.java:838)
>     ~[?:?]
>     at
>     org.apache.felix.framework.EventDispatcher.fireServiceEvent(EventDispatcher.java:545)
>     ~[?:?]
>     at
>     org.apache.felix.framework.Felix.fireServiceEvent(Felix.java:4595)
>     ~[?:?]
>     at org.apache.felix.framework.Felix.registerService(Felix.java:3587)
>     ~[?:?]
>     at
>     org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:348)
>     ~[?:?]
>     at
>     org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:355)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:55)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator$1.createService(Activator.java:48)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:60) ~[?:?]
>     at
>     org.ops4j.pax.jdbc.pool.common.impl.AbstractTransactionManagerTracker.addingService(AbstractTransactionManagerTracker.java:32) ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)
>     ~[?:?]
>     at
>     org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)
>     ~[?:?]
>     at
>     org.ops4j.pax.jdbc.pool.dbcp2.impl.Activator.start(Activator.java:59) ~[?:?]
>     at
>     org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:697)
>     ~[?:?]
>     at org.apache.felix.framework.Felix.activateBundle(Felix.java:2240)
>     ~[?:?]
>     at org.apache.felix.framework.Felix.startBundle(Felix.java:2146) ~[?:?]
>     at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:998)
>     ~[?:?]
>     at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:984)
>     ~[?:?]
>     at
>     org.apache.karaf.features.internal.service.BundleInstallSupportImpl.startBundle(BundleInstallSupportImpl.java:165)
>     ~[?:?]
>     at
>     org.apache.karaf.features.internal.service.FeaturesServiceImpl.startBundle(FeaturesServiceImpl.java:1153)
>     ~[?:?]
>     at
>     org.apache.karaf.features.internal.service.Deployer.deploy(Deployer.java:1036)
>     ~[?:?]
>     at
>     org.apache.karaf.features.internal.service.FeaturesServiceImpl.doProvision(FeaturesServiceImpl.java:1062)
>     ~[?:?]
>     at
>     org.apache.karaf.features.internal.service.FeaturesServiceImpl.lambda$doProvisionInThread$13(FeaturesServiceImpl.java:998)
>     ~[?:?]
>     at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:?]
>     at
>     java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>     [?:?]
>     at
>     java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>     [?:?]
>     at java.lang.Thread.run(Thread.java:748) [?:?]
> 
> 
> 
> Any idea what this error means?
> 
> Best regards,
> Alex soto
> 
> 
> 
> 

-- 
Jean-Baptiste Onofré
jbonofre@apache.org
http://blog.nanthrax.net
Talend - http://www.talend.com