You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@karaf.apache.org by "Cheung, Pauline" <Pa...@windriver.com> on 2016/02/04 09:52:50 UTC
pax-jdbc-pool-aries
Hi,
I was looking at
https://ops4j1.jira.com/wiki/display/PAXJDBC/Pooling+and+XA+support+for+DataSourceFactory
and was trying to configure pax-jdbc-pool-aries with the same config file that worked with pax-jdbc-pool-dbcp
Using karaf 4.0.4, I installed the following:
karaf@root()> feature:install jndi jdbc jpa transaction
karaf@root()> featire:install pax-jdbc-mysql pax-jdbc-config pax-jdbc-pool-aries
And installed the following config file in /etc:
osgi.jdbc.driver.name=mysql-pool-xa
url=jdbc:mysql://host:3306/dbName?allowMultiQueries=true&user=user&password=password&zeroDateTimeBehavior=convertToNull
databaseName=wpmsuiteNonCache
user=user
password=password
dataSourceName=jdbc/dbName
pool.maxTotal=8
And I got the following error:
2016-02-04 00:46:26,871 | ERROR | 2b-2ad5107b3909) | AriesXaPooledDataSourceFactory | 88 - org.ops4j.pax.jdbc.pool.aries - 0.7.0 | Error creating pooled datasourceError setting property maxTotal:No setter in class org.apache.aries.transaction.jdbc.RecoverableDataSource for property maxTotal
java.lang.IllegalArgumentException: Error setting property maxTotal:No setter in class org.apache.aries.transaction.jdbc.RecoverableDataSource for property maxTotal
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:84)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.configure(BeanConfig.java:58)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
at org.ops4j.pax.jdbc.pool.aries.impl.ds.AriesXaPooledDataSourceFactory.createDataSource(AriesXaPooledDataSourceFactory.java:63)[88:org.ops4j.pax.jdbc.pool.aries:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:111)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:72)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceFactoryTracker.addingService(DataSourceFactoryTracker.java:40)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)[org.osgi.core-6.0.0.jar:]
at org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.updated(DataSourceConfigManager.java:74)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.updated(ManagedServiceFactoryTracker.java:159)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.provideConfiguration(ManagedServiceFactoryTracker.java:93)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.ConfigurationManager$UpdateConfiguration.run(ConfigurationManager.java:1753)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.UpdateThread.run0(UpdateThread.java:143)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:110)[7:org.apache.felix.configadmin:1.8.8]
at java.lang.Thread.run(Thread.java:745)[:1.8.0_66]
Caused by: java.lang.IllegalArgumentException: No setter in class org.apache.aries.transaction.jdbc.RecoverableDataSource for property maxTotal
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:66)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
... 18 more
2016-02-04 00:46:26,874 | ERROR | 2b-2ad5107b3909) | configadmin | 7 - org.apache.felix.configadmin - 1.8.8 | [org.osgi.service.cm.ManagedServiceFactory, id=128, bundle=55/mvn:org.ops4j.pax.jdbc/pax-jdbc-config/0.7.0]: Unexpected problem updating configuration org.ops4j.datasour
ce.900c6264-1260-4b03-952b-2ad5107b3909
java.lang.IllegalArgumentException: Error setting property maxTotal:No setter in class org.apache.aries.transaction.jdbc.RecoverableDataSource for property maxTotal
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:84)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.configure(BeanConfig.java:58)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
at org.ops4j.pax.jdbc.pool.aries.impl.ds.AriesXaPooledDataSourceFactory.createDataSource(AriesXaPooledDataSourceFactory.java:63)[88:org.ops4j.pax.jdbc.pool.aries:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:111)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:72)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceFactoryTracker.addingService(DataSourceFactoryTracker.java:40)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)[org.osgi.core-6.0.0.jar:]
at org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.updated(DataSourceConfigManager.java:74)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.updated(ManagedServiceFactoryTracker.java:159)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.provideConfiguration(ManagedServiceFactoryTracker.java:93)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.ConfigurationManager$UpdateConfiguration.run(ConfigurationManager.java:1753)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.UpdateThread.run0(UpdateThread.java:143)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:110)[7:org.apache.felix.configadmin:1.8.8]
at java.lang.Thread.run(Thread.java:745)[:1.8.0_66]
Caused by: java.lang.IllegalArgumentException: No setter in class org.apache.aries.transaction.jdbc.RecoverableDataSource for property maxTotal
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:66)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
... 18 more
If I removed the pool.maxTotal=8 config, than two datasources with the same name show up.
karaf@root()> ds-list
Name | Product | Version | URL | Status
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
jdbc/dbName | MySQL | 5.6.21 | jdbc:mysql://host:3306/ dbName?allowMultiQueries=true&user=user&password=password&zeroDateTimeBehavior=convertToNull | OK
jdbc/dbName | MySQL | 5.6.21 | jdbc:mysql://host:3306/ dbName?allowMultiQueries=true&user=user&password=password&zeroDateTimeBehavior=convertToNull | OK
How do I use pax-jdbc-pool-aries ?
Thanks,
Pauline
Re: pax-jdbc-pool-aries
Posted by Charlie Mordant <cm...@gmail.com>.
Hi,
Your pool.maxTotal parameter does not exists in Aries-tx, so you have to
remove it from your config file in order to use it. I think that you'll
have access to these parameters (prefixing them by 'pool.'):
https://access.redhat.com/documentation/en-US/Fuse_ESB_Enterprise/7.0/html/EIP_Transactions_Guide/XaTM-ConfigureTM.html
You'll also have to configure these 3 parameters:
pool.username=
pool.password=
pool.name=
Regards,
Charlie
2016-02-05 8:41 GMT+01:00 Christian Schneider <ch...@die-schneider.net>:
> Unfortunately there does not seem to be any documentation about aries
> transaction pool.
> Guillaume Nodet explained to me that aries transaction pool supports the
> transaction recovery feature of geronimo transaction manager.
> So that might be a reason to use it.
>
> I myself till now only ever used the dbcp2 pooling.
>
> Christian
>
> On 04.02.2016 20:24, Cheung, Pauline wrote:
>
> We are currently using dbcp2 and was curious about aries and how it works
> and if there are any advantages to using it.
>
>
>
> Is there any documentation on it?
>
>
>
> Thanks,
>
> Pauline
>
>
> --
> Christian Schneiderhttp://www.liquid-reality.de
>
> Open Source Architecthttp://www.talend.com
>
>
--
Charlie Mordant
Full OSGI/EE stack made with Karaf:
https://github.com/OsgiliathEnterprise/net.osgiliath.parent
Re: pax-jdbc-pool-aries
Posted by Christian Schneider <ch...@die-schneider.net>.
Unfortunately there does not seem to be any documentation about aries
transaction pool.
Guillaume Nodet explained to me that aries transaction pool supports the
transaction recovery feature of geronimo transaction manager.
So that might be a reason to use it.
I myself till now only ever used the dbcp2 pooling.
Christian
On 04.02.2016 20:24, Cheung, Pauline wrote:
>
> We are currently using dbcp2 and was curious about aries and how it
> works and if there are any advantages to using it.
>
> Is there any documentation on it?
>
> Thanks,
>
> Pauline
>
>
--
Christian Schneider
http://www.liquid-reality.de
Open Source Architect
http://www.talend.com
RE: pax-jdbc-pool-aries
Posted by "Cheung, Pauline" <Pa...@windriver.com>.
We are currently using dbcp2 and was curious about aries and how it works and if there are any advantages to using it.
Is there any documentation on it?
Thanks,
Pauline
From: Christian Schneider [mailto:cschneider111@gmail.com] On Behalf Of Christian Schneider
Sent: Thursday, February 04, 2016 3:37 AM
To: user@karaf.apache.org
Subject: Re: pax-jdbc-pool-aries
Pool aries works completely differently. You can not use the config for pool dbcp.
Out of curiosity why did you not just use the dbcp based pool?
Christian
On 04.02.2016 09:52, Cheung, Pauline wrote:
Hi,
I was looking at
https://ops4j1.jira.com/wiki/display/PAXJDBC/Pooling+and+XA+support+for+DataSourceFactory
and was trying to configure pax-jdbc-pool-aries with the same config file that worked with pax-jdbc-pool-dbcp
Using karaf 4.0.4, I installed the following:
karaf@root()> feature:install jndi jdbc jpa transaction
karaf@root()> featire:install pax-jdbc-mysql pax-jdbc-config pax-jdbc-pool-aries
It would be
And installed the following config file in /etc:
osgi.jdbc.driver.name=mysql-pool-xa
url=jdbc:mysql://host:3306/dbName?allowMultiQueries=true&user=user&password=password&zeroDateTimeBehavior=convertToNull
databaseName=wpmsuiteNonCache
user=user
password=password
dataSourceName=jdbc/dbName
pool.maxTotal=8
And I got the following error:
2016-02-04 00:46:26,871 | ERROR | 2b-2ad5107b3909) | AriesXaPooledDataSourceFactory | 88 - org.ops4j.pax.jdbc.pool.aries - 0.7.0 | Error creating pooled datasourceError setting property maxTotal:No setter in class org.apache.aries.transaction.jdbc.RecoverableDataSource for property maxTotal
java.lang.IllegalArgumentException: Error setting property maxTotal:No setter in class org.apache.aries.transaction.jdbc.RecoverableDataSource for property maxTotal
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:84)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.configure(BeanConfig.java:58)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
at org.ops4j.pax.jdbc.pool.aries.impl.ds.AriesXaPooledDataSourceFactory.createDataSource(AriesXaPooledDataSourceFactory.java:63)[88:org.ops4j.pax.jdbc.pool.aries:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:111)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:72)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceFactoryTracker.addingService(DataSourceFactoryTracker.java:40)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)[org.osgi.core-6.0.0.jar:]
at org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.updated(DataSourceConfigManager.java:74)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.updated(ManagedServiceFactoryTracker.java:159)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.provideConfiguration(ManagedServiceFactoryTracker.java:93)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.ConfigurationManager$UpdateConfiguration.run(ConfigurationManager.java:1753)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.UpdateThread.run0(UpdateThread.java:143)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:110)[7:org.apache.felix.configadmin:1.8.8]
at java.lang.Thread.run(Thread.java:745)[:1.8.0_66]
Caused by: java.lang.IllegalArgumentException: No setter in class org.apache.aries.transaction.jdbc.RecoverableDataSource for property maxTotal
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:66)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
... 18 more
2016-02-04 00:46:26,874 | ERROR | 2b-2ad5107b3909) | configadmin | 7 - org.apache.felix.configadmin - 1.8.8 | [org.osgi.service.cm.ManagedServiceFactory, id=128, bundle=55/mvn:org.ops4j.pax.jdbc/pax-jdbc-config/0.7.0]: Unexpected problem updating configuration org.ops4j.datasour
ce.900c6264-1260-4b03-952b-2ad5107b3909
java.lang.IllegalArgumentException: Error setting property maxTotal:No setter in class org.apache.aries.transaction.jdbc.RecoverableDataSource for property maxTotal
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:84)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.configure(BeanConfig.java:58)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
at org.ops4j.pax.jdbc.pool.aries.impl.ds.AriesXaPooledDataSourceFactory.createDataSource(AriesXaPooledDataSourceFactory.java:63)[88:org.ops4j.pax.jdbc.pool.aries:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:111)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:72)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.ops4j.pax.jdbc.config.impl.DataSourceFactoryTracker.addingService(DataSourceFactoryTracker.java:40)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)[org.osgi.core-6.0.0.jar:]
at org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)[org.osgi.core-6.0.0.jar:]
at org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.updated(DataSourceConfigManager.java:74)[55:org.ops4j.pax.jdbc.config:0.7.0]
at org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.updated(ManagedServiceFactoryTracker.java:159)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.provideConfiguration(ManagedServiceFactoryTracker.java:93)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.ConfigurationManager$UpdateConfiguration.run(ConfigurationManager.java:1753)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.UpdateThread.run0(UpdateThread.java:143)[7:org.apache.felix.configadmin:1.8.8]
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:110)[7:org.apache.felix.configadmin:1.8.8]
at java.lang.Thread.run(Thread.java:745)[:1.8.0_66]
Caused by: java.lang.IllegalArgumentException: No setter in class org.apache.aries.transaction.jdbc.RecoverableDataSource for property maxTotal
at org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:66)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
... 18 more
If I removed the pool.maxTotal=8 config, than two datasources with the same name show up.
karaf@root()> ds-list
Name | Product | Version | URL | Status
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
jdbc/dbName | MySQL | 5.6.21 | jdbc:mysql://host:3306/ dbName?allowMultiQueries=true&user=user&password=password&zeroDateTimeBehavior=convertToNull | OK
jdbc/dbName | MySQL | 5.6.21 | jdbc:mysql://host:3306/ dbName?allowMultiQueries=true&user=user&password=password&zeroDateTimeBehavior=convertToNull | OK
How do I use pax-jdbc-pool-aries ?
Thanks,
Pauline
--
Christian Schneider
http://www.liquid-reality.de
Open Source Architect
http://www.talend.com
Re: pax-jdbc-pool-aries
Posted by Christian Schneider <ch...@die-schneider.net>.
Pool aries works completely differently. You can not use the config for
pool dbcp.
Out of curiosity why did you not just use the dbcp based pool?
Christian
On 04.02.2016 09:52, Cheung, Pauline wrote:
>
> Hi,
>
> I was looking at
>
> https://ops4j1.jira.com/wiki/display/PAXJDBC/Pooling+and+XA+support+for+DataSourceFactory
>
> and was trying to configure pax-jdbc-pool-aries with the same config
> file that worked with pax-jdbc-pool-dbcp
>
> Using karaf 4.0.4, I installed the following:
>
> karaf@root()> feature:install jndi jdbc jpa transaction
>
> karaf@root()> featire:install pax-jdbc-mysql pax-jdbc-config
> pax-jdbc-pool-aries
>
> It would be
>
> And installed the following config file in /etc:
>
> osgi.jdbc.driver.name=mysql-pool-xa
>
> url=jdbc:mysql://host:3306/dbName?allowMultiQueries=true&user=user&password=password&zeroDateTimeBehavior=convertToNull
>
> databaseName=wpmsuiteNonCache
>
> user=user
>
> password=password
>
> dataSourceName=jdbc/dbName
>
> pool.maxTotal=8
>
> And I got the following error:
>
> 2016-02-04 00:46:26,871 | ERROR | 2b-2ad5107b3909) |
> AriesXaPooledDataSourceFactory | 88 - org.ops4j.pax.jdbc.pool.aries
> - 0.7.0 | Error creating pooled datasourceError setting property
> maxTotal:No setter in class
> org.apache.aries.transaction.jdbc.RecoverableDataSource for property
> maxTotal
>
> java.lang.IllegalArgumentException: Error setting property maxTotal:No
> setter in class
> org.apache.aries.transaction.jdbc.RecoverableDataSource for property
> maxTotal
>
> at
> org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:84)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
>
> at
> org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.configure(BeanConfig.java:58)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
>
> at
> org.ops4j.pax.jdbc.pool.aries.impl.ds.AriesXaPooledDataSourceFactory.createDataSource(AriesXaPooledDataSourceFactory.java:63)[88:org.ops4j.pax.jdbc.pool.aries:0.7.0]
>
> at
> org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:111)[55:org.ops4j.pax.jdbc.config:0.7.0]
>
> at
> org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:72)[55:org.ops4j.pax.jdbc.config:0.7.0]
>
> at
> org.ops4j.pax.jdbc.config.impl.DataSourceFactoryTracker.addingService(DataSourceFactoryTracker.java:40)[55:org.ops4j.pax.jdbc.config:0.7.0]
>
> at
> org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)[org.osgi.core-6.0.0.jar:]
>
> at
> org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)[org.osgi.core-6.0.0.jar:]
>
> at
> org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)[org.osgi.core-6.0.0.jar:]
>
> at
> org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)[org.osgi.core-6.0.0.jar:]
>
> at
> org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)[org.osgi.core-6.0.0.jar:]
>
> at
> org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)[org.osgi.core-6.0.0.jar:]
>
> at
> org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.updated(DataSourceConfigManager.java:74)[55:org.ops4j.pax.jdbc.config:0.7.0]
>
> at
> org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.updated(ManagedServiceFactoryTracker.java:159)[7:org.apache.felix.configadmin:1.8.8]
>
> at
> org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.provideConfiguration(ManagedServiceFactoryTracker.java:93)[7:org.apache.felix.configadmin:1.8.8]
>
> at
> org.apache.felix.cm.impl.ConfigurationManager$UpdateConfiguration.run(ConfigurationManager.java:1753)[7:org.apache.felix.configadmin:1.8.8]
>
> at
> org.apache.felix.cm.impl.UpdateThread.run0(UpdateThread.java:143)[7:org.apache.felix.configadmin:1.8.8]
>
> at
> org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:110)[7:org.apache.felix.configadmin:1.8.8]
>
> at java.lang.Thread.run(Thread.java:745)[:1.8.0_66]
>
> Caused by: java.lang.IllegalArgumentException: No setter in class
> org.apache.aries.transaction.jdbc.RecoverableDataSource for property
> maxTotal
>
> at
> org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:66)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
>
> ... 18 more
>
> 2016-02-04 00:46:26,874 | ERROR | 2b-2ad5107b3909) |
> configadmin | 7 - org.apache.felix.configadmin -
> 1.8.8 | [org.osgi.service.cm.ManagedServiceFactory, id=128,
> bundle=55/mvn:org.ops4j.pax.jdbc/pax-jdbc-config/0.7.0]: Unexpected
> problem updating configuration org.ops4j.datasour
>
> ce.900c6264-1260-4b03-952b-2ad5107b3909
>
> java.lang.IllegalArgumentException: Error setting property maxTotal:No
> setter in class
> org.apache.aries.transaction.jdbc.RecoverableDataSource for property
> maxTotal
>
> at
> org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:84)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
>
> at
> org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.configure(BeanConfig.java:58)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
>
> at
> org.ops4j.pax.jdbc.pool.aries.impl.ds.AriesXaPooledDataSourceFactory.createDataSource(AriesXaPooledDataSourceFactory.java:63)[88:org.ops4j.pax.jdbc.pool.aries:0.7.0]
>
> at
> org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.createDs(DataSourceRegistration.java:111)[55:org.ops4j.pax.jdbc.config:0.7.0]
>
> at
> org.ops4j.pax.jdbc.config.impl.DataSourceRegistration.<init>(DataSourceRegistration.java:72)[55:org.ops4j.pax.jdbc.config:0.7.0]
>
> at
> org.ops4j.pax.jdbc.config.impl.DataSourceFactoryTracker.addingService(DataSourceFactoryTracker.java:40)[55:org.ops4j.pax.jdbc.config:0.7.0]
>
> at
> org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:941)[org.osgi.core-6.0.0.jar:]
>
> at
> org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:870)[org.osgi.core-6.0.0.jar:]
>
> at
> org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)[org.osgi.core-6.0.0.jar:]
>
> at
> org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)[org.osgi.core-6.0.0.jar:]
>
> at
> org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:318)[org.osgi.core-6.0.0.jar:]
>
> at
> org.osgi.util.tracker.ServiceTracker.open(ServiceTracker.java:261)[org.osgi.core-6.0.0.jar:]
>
> at
> org.ops4j.pax.jdbc.config.impl.DataSourceConfigManager.updated(DataSourceConfigManager.java:74)[55:org.ops4j.pax.jdbc.config:0.7.0]
>
> at
> org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.updated(ManagedServiceFactoryTracker.java:159)[7:org.apache.felix.configadmin:1.8.8]
>
> at
> org.apache.felix.cm.impl.helper.ManagedServiceFactoryTracker.provideConfiguration(ManagedServiceFactoryTracker.java:93)[7:org.apache.felix.configadmin:1.8.8]
>
> at
> org.apache.felix.cm.impl.ConfigurationManager$UpdateConfiguration.run(ConfigurationManager.java:1753)[7:org.apache.felix.configadmin:1.8.8]
>
> at
> org.apache.felix.cm.impl.UpdateThread.run0(UpdateThread.java:143)[7:org.apache.felix.configadmin:1.8.8]
>
> at
> org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:110)[7:org.apache.felix.configadmin:1.8.8]
>
> at java.lang.Thread.run(Thread.java:745)[:1.8.0_66]
>
> Caused by: java.lang.IllegalArgumentException: No setter in class
> org.apache.aries.transaction.jdbc.RecoverableDataSource for property
> maxTotal
>
> at
> org.ops4j.pax.jdbc.pool.common.impl.BeanConfig.trySetProperty(BeanConfig.java:66)[89:org.ops4j.pax.jdbc.pool.common:0.7.0]
>
> ... 18 more
>
> If I removed the pool.maxTotal=8 config, than two datasources with the
> same name show up.
>
> karaf@root()> ds-list
>
> Name | Product | Version | URL | Status
>
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> jdbc/dbName | MySQL | 5.6.21 | jdbc:mysql://host:3306/
> dbName?allowMultiQueries=true&user=user&password=password&zeroDateTimeBehavior=convertToNull
> | OK
>
> jdbc/dbName | MySQL | 5.6.21 | jdbc:mysql://host:3306/
> dbName?allowMultiQueries=true&user=user&password=password&zeroDateTimeBehavior=convertToNull
> | OK
>
> How do I use pax-jdbc-pool-aries ?
>
> Thanks,
>
> Pauline
>
--
Christian Schneider
http://www.liquid-reality.de
Open Source Architect
http://www.talend.com