Another question about DB in JBoss fuse

[waldemarpires]

Hello all,

I would like to develop a set of containers that change information among them. One of these containers has to get the information and save it in a DB. In order to learn how to that, I was following this tutorial.

http://wei-meilin.blogspot.tw/2014/12/jboss-fuse-file-connector-with-split_20.html

The tutorial is really good and I could learn how to use the technologies. Running the example in a "Local Camel Context" in eclipse, it works.

However, my problem is to create a container in a remote jboss fuse via fabric8. And in order to do that, I was following another tutorial:

http://vimeo.com/104004136

And when a create a container with the uploaded profile, a error with the following message appears:

Provision Exception:

org.osgi.service.resolver.ResolutionException: Unable to resolve dummy/0.0.0: missing requirement [dummy/0.0.0] osgi.identity; osgi.identity=database; type=osgi.bundle; version="[1.0.0.SNAPSHOT,1.0.0.SNAPSHOT]" [caused by: Unable to resolve database/1.0.0.SNAPSHOT: missing requirement [database/1.0.0.SNAPSHOT] osgi.wiring.package; filter:="(&(osgi.wiring.package=org.apache.commons.dbcp)(version>=1.4.0)(!(version>=2.0.0)))" [caused by: Unable to resolve org.apache.commons.dbcp/1.4.0: missing requirement [org.apache.commons.dbcp/1.4.0] osgi.wiring.package; filter:="(osgi.wiring.package=org.apache.commons.pool)"]]

  at org.apache.felix.resolver.Candidates.populateResource(Candidates.java:285)

  at org.apache.felix.resolver.Candidates.populate(Candidates.java:153)

  at org.apache.felix.resolver.ResolverImpl.resolve(ResolverImpl.java:148)

  at io.fabric8.agent.DeploymentBuilder.resolve(DeploymentBuilder.java:226)

  at io.fabric8.agent.DeploymentAgent.doUpdate(DeploymentAgent.java:521)

  at io.fabric8.agent.DeploymentAgent$2.run(DeploymentAgent.java:252)

  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

  at java.util.concurrent.FutureTask.run(FutureTask.java:262)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

  at java.lang.Thread.run(Thread.java:745)

So, someone has a suggestion of how I can manage this error? I aready tried it:

Configuring a MySQL JDBC persistence store in JBoss Fuse

Thanks for the attention.

Neto

[bharadwaj]

Wrapping up   org.apache.commons.dbcp dependency in Karaf would solve you

problem.

Example :

wrap:mvn:org.apache.commons.dbcp/dbcp/4.1

[sbrandt]

Your Fuse container is missing the DBCP connection pool bundle. You can easily add it (wrapping should not be neccessary, dbcp is already an OSGi bundle): just download commons-dbcp-1.4.jar [1], copy it into the "deploy" folder and you're done.

[1] http://search.maven.org/remotecontent?filepath=commons-dbcp/commons-dbcp/1.4/commons-dbcp-1.4.jar

[bharadwaj]

Keeping it in deploy folder is not a best practice. I would prefer to wrap

it.

On Mon, Jan 26, 2015 at 6:30 PM, Sebastian Brandt <[e-mail]>

[sbrandt]

Yeah since op wants to use fabric, file drop is probably not a good way, but so is manual wrap.

I guess the dependency to mvn:commons-dbcp/commons-dbcp/1.4 should be added to the custom profile.

[abhishekkoneru6790]

wrapping would solve the issue.

If using fabric, dropping it into the deploy folder might not be a good practice..

osgi:install -s wrap:mvn:commons-dbcp/commons-dbcp/1.4

Make sure the jar is in the repo

Downloading the jar and putting it in the deploy folder would also do

[davsclaus]

You should add commons-dbcp to the list of bundles for the profile you install.

[waldemarpires]

Hi all,

Actually, I already did it. A stretch of my pom:

<properties>

  <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

  <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

  <fabric8.parentProfiles>feature-camel</fabric8.parentProfiles>

  <fabric8.profile>demo-filenjdbc</fabric8.profile>

  <fabric8.bundles>wrap:mvn:com.h2database/h2/1.4.181

  wrap:mvn:commons-dbcp/commons-dbcp/1.4

  wrap:mvn:org.springframework/spring-jdbc/3.2.8.RELEASE

  <!-- wrap:mvn:org.apache.commons/commons-dbcp2/2.0.1 -->

  </fabric8.bundles>

  <fabric8.features>camel-jdbc camel-spring camel-sql</fabric8.features>

  <fabric8.featureRepos>mvn:org.apache.camel.karaf/apache-camel/${version:camel}/xml/features</fabric8.featureRepos>

  <servicemix.osgi.export>

            org.apache.camel.demo.camel_jms_jdbc

        </servicemix.osgi.export>

        <servicemix.osgi.bundles />

        <servicemix.osgi.dynamic.import>*</servicemix.osgi.dynamic.import>

</properties>

I tried to use both:

wrap:mvn:commons-dbcp/commons-dbcp/1.4

and

wrap:mvn:org.apache.commons/commons-dbcp2/2.0.1

And the error is always the same.

error - org.osgi.service.resolver.ResolutionException: Unable to resolve dummy/0.0.0: missing requirement [dummy/0.0.0] osgi.identity; osgi.identity=database; type=osgi.bundle; version="[1.0.0.SNAPSHOT,1.0.0.SNAPSHOT]" [caused by: Unable to resolve database/1.0.0.SNAPSHOT: missing requirement [database/1.0.0.SNAPSHOT] osgi.wiring.package; filter:="(&(osgi.wiring.package=org.apache.commons.dbcp)(version>=1.4.0)(!(version>=2.0.0)))" [caused by: Unable to resolve org.apache.commons.dbcp/1.4.0: missing requirement [org.apache.commons.dbcp/1.4.0] osgi.wiring.package; filter:="(osgi.wiring.package=org.apache.commons.pool)"]]

My pom.xml is here, as well as my project.

sharecode/pom.xml at master · netuh/sharecode · GitHub

Thanks in advance.

Neto

[davsclaus]

Ah you need to install commons-pool also. You can add it to the fabric8.bundles list.

    mvn:commons-pool/commons-pool/1.6

[waldemarpires]

Thank you all.

Adding also the Claus Ibsen's suggestion.  I had another error, then I added

wrap:mvn:org.apache.camel/camel-jdbc/2.12.0.redhat-610379

and it works!! =)

[abhishekkoneru6790]

features:install camel-jdbc might also help

[rafaelcba]

Commons Pool2 is OSGI Friendly already!

mvn:org.apache.commons/commons-dbcp2/2.0.1

mvn:org.apache.commons/commons-pool2/2.2