Thanks Christian,
It seemed the reason why the pax-jdbc datasource wasn't picked up by JPA
Blueprint was that I had given it the wrong name...
I had forgotten the "jdbc/" prefix that I use in my persistence.xml. It is
now picked up as it should.
There is, however, an error in the documentation in the link you gave me.
It says:
---
Method Arguments
The argument passed to createDataSource(),
createConnectionPoolDataSource(), createXADataSource() supports the
following properties:
- DataSourceFactory.JDBC_DATABASE_NAME (mandatory)
- DataSourceFactory.JDBC_USER
- DataSourceFactory.JDBC_PASSWORD
*An SQLException is thrown if any other properties are set* or if a
mandatory property is missing.
--
But I need to pass properties directly to the jdbc driver. In my case
"createDatabase=create" so that the database is created if it doesn't
already exists. I therefore set this property in my org.ops4j.datasource
configuration as follows:
osgi.jdbc.driver.name=derby-pool-xa
databaseName=historyDB
dataSourceName=jdbc/filetransferhistory
createDatabase=create
The "createDatabase" property is passed to the driver so that the database
is created. So, it is OK to pass other properties as well - they get passed
along.
However, I do still have a problem getting the Derby database to be
created. When trying to create a new database I get:
Caused by: java.sql.SQLException: Auto-commit can not be set while enrolled
in a transaction
at
org.apache.commons.dbcp2.managed.ManagedConnection.setAutoCommit(ManagedConnection.java:223)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.setAutoCommit(DelegatingConnection.java:167)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.setAutoCommit(DelegatingConnection.java:167)
at
org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.setAutoCommit(ConfiguringConnectionDecorator.java:116)
at
org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1297)
at
org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:1017)
at
org.apache.openjpa.jdbc.schema.SchemaTool.buildSchema(SchemaTool.java:573)
at
org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:481)
at
org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:368)
at
org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:343)
at
org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:507)
... 46 more
It works if I instead use "derby" or "derby-pool" DataSourceFactory. I
tried to provide a <non-jta-datasource> for this purpose but it is never
being used. I thought this was the reason why a <non-jta-datasource> should
be provided. Not sure whether this is a problem with JPA blueprint or if
its a problem in OpenJPA. Maybe I should ask on the OpenJPA mailing list?
/Bengt
2016-07-08 17:48 GMT+02:00 Christian Schneider <[email protected]>:
> The available properties depend on the DataSourceFactory.
>
> See this doc for the options you can use:
> https://ops4j1.jira.com/wiki/display/PAXJDBC/Apache+Derby+Driver+Adapter
>
> Christian
>
>
> On 08.07.2016 16:39, Bengt Rodehav wrote:
>
> Unfortunately I spoke to soon...
>
> Using pax-jdbc a DataSource service is created but it isn't picked by
> Blueprint JPA. It was the one I created with my Blueprint that was used. I
> have:
>
> *karaf@root()> service:list DataSource*
> *[javax.sql.DataSource]*
> *----------------------*
> * dataSourceName = filetransferhistory*
> * felix.fileinstall.filename =
> file:/C:/dev/karaf/connect/head/apache-karaf-4.0.5/etc/org.ops4j.datasource-filetransferhistory.cfg*
> * osgi.jdbc.driver.name <http://osgi.jdbc.driver.name> = derby-pool-xa*
> * osgi.jndi.service.name <http://osgi.jndi.service.name> =
> filetransferhistory*
> * service.bundleid = 162*
> * service.factoryPid = org.ops4j.datasource*
> * service.id <http://service.id> = 338*
> * service.pid = org.ops4j.datasource.c55c28be-f6f8-4e00-8448-92dfa20bedb5*
> * service.scope = singleton*
> * url = jdbc:derby:historyDB;createDatabase=create*
> *Provided by :*
> * OPS4J Pax JDBC Config (162)*
>
>
> *[javax.sql.DataSource] *
> *----------------------*
> * osgi.jndi.service.name <http://osgi.jndi.service.name> =
> jdbc/filetransferhistory*
> * osgi.service.blueprint.compname = derbyDataSource*
> * service.bundleid = 204*
> * service.id <http://service.id> = 358*
> * service.scope = bundle*
> *Provided by :*
> * Connect :: filetransfer-history-datasource (204)*
> *Used by:*
> * Apache Aries JPA container (38)*
>
> It's the last one above that is being picked up and used to publish an
> EnityManager service. My blueprint looks like this:
>
> *<?xml version="1.0" encoding="UTF-8"?>*
> *<blueprint xmlns="http://www.osgi.org/xmlns/blueprint/v1.0.0
> <http://www.osgi.org/xmlns/blueprint/v1.0.0>"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance
> <http://www.w3.org/2001/XMLSchema-instance>"*
> * xsi:schemaLocation="http://www.osgi.org/xmlns/blueprint/v1.0.0
> <http://www.osgi.org/xmlns/blueprint/v1.0.0>" default-activation="lazy">*
>
>
> * <bean id="derbyDataSource"
> class="org.apache.derby.jdbc.EmbeddedDataSource"> *
> * <property name="databaseName" value="historyDB" />*
> * <property name="createDatabase" value="create" />*
> * </bean>*
>
> * <service ref="derbyDataSource" interface="javax.sql.DataSource">*
> * <service-properties>*
> * <entry key="osgi.jndi.service.name <http://osgi.jndi.service.name>"
> value="jdbc/filetransferhistory" />*
> * </service-properties>*
> * </service>*
>
> *</blueprint>*
>
> It works but it is not an XA data source.
>
> I don't understand what other difference there is between the service
> published by pax-jdbc(338) and the one published by blueprint(358).
>
> I install the folllowing pax-jdbc features:
>
> - pax-jdbc-derby
> - pax-jdbc-pool-dbcp2
> - pax-jdbc-config
>
> I also have a configuration file
> called org.ops4j.datasource-filetransferhistory.cfg with content:
>
> *osgi.jdbc.driver.name <http://osgi.jdbc.driver.name>=derby-pool-xa*
> *url=jdbc:derby:historyDB;createDatabase=create*
>
> *dataSourceName=filetransferhistory *
>
> I have the following data source factories:
>
> *karaf@root()> service:list DataSourceFactory*
> *[org.osgi.service.jdbc.DataSourceFactory]*
> *-----------------------------------------*
> * osgi.jdbc.driver.class = org.apache.derby.jdbc.EmbeddedDriver*
> * osgi.jdbc.driver.name <http://osgi.jdbc.driver.name> = derby*
> * service.bundleid = 163*
> * service.id <http://service.id> = 331*
> * service.scope = singleton*
> *Provided by :*
> * OPS4J Pax JDBC Apache Derby Driver Adapter (163)*
> *Used by:*
> * OPS4J Pax JDBC Pooling Support using Commons-DBCP2 (165)*
>
> *[org.osgi.service.jdbc.DataSourceFactory]*
> *-----------------------------------------*
> * osgi.jdbc.driver.class = org.apache.derby.jdbc.EmbeddedDriver-pool*
> * osgi.jdbc.driver.name <http://osgi.jdbc.driver.name> = derby-pool*
> * pooled = true*
> * service.bundleid = 165*
> * service.id <http://service.id> = 336*
> * service.scope = singleton*
> *Provided by :*
> * OPS4J Pax JDBC Pooling Support using Commons-DBCP2 (165)*
>
> *[org.osgi.service.jdbc.DataSourceFactory]*
> *-----------------------------------------*
> * osgi.jdbc.driver.class = org.apache.derby.jdbc.EmbeddedDriver-pool-xa*
> * osgi.jdbc.driver.name <http://osgi.jdbc.driver.name> = derby-pool-xa*
> * pooled = true*
> * service.bundleid = 165*
> * service.id <http://service.id> = 337*
> * service.scope = singleton*
> * xa = true*
> *Provided by :*
> * OPS4J Pax JDBC Pooling Support using Commons-DBCP2 (165)*
> *Used by:*
> * OPS4J Pax JDBC Config (162)*
>
> Everything looks fine to me but I get no EntityManager created with the
> pax-jdbc data sources...
>
> One thing I noticed is that in my Blueprint, I do not use the "url"
> property. Instead I set the two properties "databaseName" and
> "createDatabase". If I try to use the "url" property in my Blueprint I get
> the following error:
>
> *2016-07-08 16:20:42,297 | ERROR | lixDispatchQueue | container
> | ? ? | FrameworkEvent ERROR
> - org.apache.aries.jpa.container*
> *org.osgi.framework.ServiceException: Service factory exception:
> org.osgi.service.blueprint.container.ComponentDefinitionException: Unable
> to find property descriptor url on class
> org.apache.derby.jdbc.EmbeddedDataSource*
> * at
> org.apache.felix.framework.ServiceRegistrationImpl.getFactoryUnchecked(ServiceRegistrationImpl.java:352)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.ServiceRegistrationImpl.getService(ServiceRegistrationImpl.java:247)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.ServiceRegistry.getService(ServiceRegistry.java:344)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.Felix.getService(Felix.java:3699)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.BundleContextImpl.getService(BundleContextImpl.java:470)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.aries.jpa.container.impl.DataSourceTracker.addingService(DataSourceTracker.java:85)[38:org.apache.aries.jpa.container:2.3.0]*
> * at
> org.apache.aries.jpa.container.impl.DataSourceTracker.addingService(DataSourceTracker.java:37)[38:org.apache.aries.jpa.container:2.3.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.track(AbstractTracked.java:229)[org.osgi.core-6.0.0.jar:]*
> * at
> org.osgi.util.tracker.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:901)[org.osgi.core-6.0.0.jar:]*
> * at
> org.apache.felix.framework.util.EventDispatcher.invokeServiceListenerCallback(EventDispatcher.java:991)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.util.EventDispatcher.fireEventImmediately(EventDispatcher.java:839)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.util.EventDispatcher.fireServiceEvent(EventDispatcher.java:546)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.Felix.fireServiceEvent(Felix.java:4557)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.Felix.registerService(Felix.java:3549)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:348)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.aries.blueprint.container.BlueprintContainerImpl.registerService(BlueprintContainerImpl.java:492)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.ServiceRecipe.register(ServiceRecipe.java:193)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BlueprintContainerImpl.registerServices(BlueprintContainerImpl.java:746)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BlueprintContainerImpl.doRun(BlueprintContainerImpl.java:413)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BlueprintContainerImpl.run(BlueprintContainerImpl.java:276)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BlueprintExtender.createContainer(BlueprintExtender.java:300)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BlueprintExtender.createContainer(BlueprintExtender.java:269)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BlueprintExtender.createContainer(BlueprintExtender.java:265)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BlueprintExtender.modifiedBundle(BlueprintExtender.java:255)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.util.tracker.hook.BundleHookBundleTracker$Tracked.customizerModified(BundleHookBundleTracker.java:500)[46:org.apache.aries.util:1.1.1]*
> * at
> org.apache.aries.util.tracker.hook.BundleHookBundleTracker$Tracked.customizerModified(BundleHookBundleTracker.java:433)[46:org.apache.aries.util:1.1.1]*
> * at
> org.apache.aries.util.tracker.hook.BundleHookBundleTracker$AbstractTracked.track(BundleHookBundleTracker.java:725)[46:org.apache.aries.util:1.1.1]*
> * at
> org.apache.aries.util.tracker.hook.BundleHookBundleTracker$Tracked.bundleChanged(BundleHookBundleTracker.java:463)[46:org.apache.aries.util:1.1.1]*
> * at
> org.apache.aries.util.tracker.hook.BundleHookBundleTracker$BundleEventHook.event(BundleHookBundleTracker.java:422)[46:org.apache.aries.util:1.1.1]*
> * at
> org.apache.felix.framework.util.SecureAction.invokeBundleEventHook(SecureAction.java:1179)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.util.EventDispatcher.createWhitelistFromHooks(EventDispatcher.java:731)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.util.EventDispatcher.fireBundleEvent(EventDispatcher.java:486)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.Felix.fireBundleEvent(Felix.java:4541)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.Felix.startBundle(Felix.java:2172)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.felix.framework.BundleImpl.start(BundleImpl.java:998)[org.apache.felix.framework-5.4.0.jar:]*
> * at
> org.apache.karaf.bundle.command.Start.executeOnBundle(Start.java:38)[73:org.apache.karaf.bundle.core:4.0.5]*
> * at
> org.apache.karaf.bundle.command.BundlesCommand.doExecute(BundlesCommand.java:64)[73:org.apache.karaf.bundle.core:4.0.5]*
> * at
> org.apache.karaf.bundle.command.BundlesCommand.execute(BundlesCommand.java:54)[73:org.apache.karaf.bundle.core:4.0.5]*
> * at
> org.apache.karaf.shell.impl.action.command.ActionCommand.execute(ActionCommand.java:83)[97:org.apache.karaf.shell.core:4.0.5]*
> * at
> org.apache.karaf.shell.impl.console.osgi.secured.SecuredCommand.execute(SecuredCommand.java:67)[97:org.apache.karaf.shell.core:4.0.5]*
> * at
> org.apache.karaf.shell.impl.console.osgi.secured.SecuredCommand.execute(SecuredCommand.java:87)[97:org.apache.karaf.shell.core:4.0.5]*
> * at
> org.apache.felix.gogo.runtime.Closure.executeCmd(Closure.java:480)[97:org.apache.karaf.shell.core:4.0.5]*
> * at
> org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:406)[97:org.apache.karaf.shell.core:4.0.5]*
> * at
> org.apache.felix.gogo.runtime.Pipe.run(Pipe.java:108)[97:org.apache.karaf.shell.core:4.0.5]*
> * at
> org.apache.felix.gogo.runtime.Closure.execute(Closure.java:182)[97:org.apache.karaf.shell.core:4.0.5]*
> * at
> org.apache.felix.gogo.runtime.Closure.execute(Closure.java:119)[97:org.apache.karaf.shell.core:4.0.5]*
> * at
> org.apache.felix.gogo.runtime.CommandSessionImpl.execute(CommandSessionImpl.java:94)[97:org.apache.karaf.shell.core:4.0.5]*
> * at
> org.apache.karaf.shell.impl.console.ConsoleSessionImpl.run(ConsoleSessionImpl.java:270)[97:org.apache.karaf.shell.core:4.0.5]*
> * at java.lang.Thread.run(Thread.java:745)[:1.8.0_74]*
> *Caused by:
> org.osgi.service.blueprint.container.ComponentDefinitionException:
> org.osgi.service.blueprint.container.ComponentDefinitionException: Unable
> to find property descriptor url on class
> org.apache.derby.jdbc.EmbeddedDataSource*
> * at
> org.apache.aries.blueprint.container.ServiceRecipe.createService(ServiceRecipe.java:310)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.ServiceRecipe.internalGetService(ServiceRecipe.java:252)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.ServiceRecipe.getService(ServiceRecipe.java:365)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.ServiceRecipe$TriggerServiceFactory.getService(ServiceRecipe.java:541)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.felix.framework.ServiceRegistrationImpl.getFactoryUnchecked(ServiceRegistrationImpl.java:347)[org.apache.felix.framework-5.4.0.jar:]*
> * ... 51 more*
> *Caused by:
> org.osgi.service.blueprint.container.ComponentDefinitionException: Unable
> to find property descriptor url on class
> org.apache.derby.jdbc.EmbeddedDataSource*
> * at
> org.apache.aries.blueprint.container.BeanRecipe.getPropertyDescriptor(BeanRecipe.java:976)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BeanRecipe.setProperty(BeanRecipe.java:958)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BeanRecipe.setProperties(BeanRecipe.java:929)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BeanRecipe.setProperties(BeanRecipe.java:910)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BeanRecipe.internalCreate2(BeanRecipe.java:844)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.BeanRecipe.internalCreate(BeanRecipe.java:811)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.di.AbstractRecipe$1.call(AbstractRecipe.java:79)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at java.util.concurrent.FutureTask.run(FutureTask.java:266)[:1.8.0_74]*
> * at
> org.apache.aries.blueprint.di.AbstractRecipe.create(AbstractRecipe.java:88)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.di.RefRecipe.internalCreate(RefRecipe.java:62)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.di.AbstractRecipe.create(AbstractRecipe.java:106)[24:org.apache.aries.blueprint.core:1.6.1]*
> * at
> org.apache.aries.blueprint.container.ServiceRecipe.createService(ServiceRecipe.java:285)[24:org.apache.aries.blueprint.core:1.6.1]*
> * ... 55 more*
>
> So, maybe the "url" property can't be used for pax-jdbc-derby?
>
>
> /Bengt
>
>
>
> --
> Christian Schneiderhttp://www.liquid-reality.de
>
> Open Source Architecthttp://www.talend.com
>
>
