domenica 7 giugno 2009

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

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



...

See details in this gooole document or download test-wsdl-first-osgi.zip

3 commenti:

Thomas Gill ha detto...

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 ha detto...

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 ha detto...

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.