Connecting to a database with a webService (cxf) deployed (osgi) in Servicemix

Posted on 07/06/2009 by matteo

1) Install and start ServiceMix 4.0

2) Add necessary bundles

features/install cxf-osgi

osgi/install -s mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.commons-dbcp/1.2.2_3/

osgi/install -s wrap:mvn:org.springframework/spring-jdbc/2.5.6/

osgi/install -s wrap:mvn:mysql/mysql-connector-java/5.1.6

…

This entry was posted in Me and tagged Ope, OpenSource, Servicemix, SOA. Bookmark the permalink.

Thomas Gill says:

03/08/2009 at 20:54

Matteo – How do you install an Oracle driver in Servicemix. I have the oracle6.jar. Tried putting in lib dir and also

install file:///tmp/ojdbc6.jar

Trying to setup Master -Slave using JDBC for ActiveMQ
Matteo says:

03/08/2009 at 21:03

In smx4 try installing bundle from springsource

http://www.springsource.com/repository/app/bundle/version/detail?name=com.springsource.oracle.jdbc&version=10.2.0.2

if you cannot, please ask in servicemix forum, I’m not an expert in java/osgi..

Regards
Thomas Gill says:

04/08/2009 at 05:44

Thanks Matteo – The Spring version is a little old but works. I have the ActiveMQ tables created in DB and everything works. I tried with one Master alone and when running it is all good. But when the Master goes down the DB lock is not removed. Planning to start 2 Brokers and see how it behaves.