Matteo Redaelli

Computer Science OpenSource Linux Africa Volontariato Ambiente Energia solare Mezzi Pubblici Piste ciclabili

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

Filed under: Me — Matteo @ 18:37
Tags: , , ,

See newer post at redaelli.org

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

Advertisements
 

Howto sharing (osgi style) a database connection in Servicemix4 / FuseEsb4

Filed under: Me — Matteo @ 13:58
Tags: ,

See newer post at redaelli.org

<?xml version=”1.0″ encoding=”UTF-8″?>
<beans xmlns=”http://www.springframework.org/schema/beans&#8221;
xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance&#8221;
xmlns:camel-osgi=”http://activemq.apache.org/camel/schema/osgi&#8221;
xmlns:osgi=”http://www.springframework.org/schema/osgi&#8221;
xsi:schemaLocation=”
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/osgi
http://www.springframework.org/schema/osgi/spring-osgi.xsd
http://activemq.apache.org/camel/schema/spring
http://activemq.apache.org/camel/schema/spring/camel-spring.xsd
http://activemq.apache.org/camel/schema/osgi
http://activemq.apache.org/camel/schema/osgi/camel-osgi.xsd”&gt;

<bean id=”moodleDS”>
<property name=”driverClassName” value=”com.mysql.jdbc.Driver” />
<property name=”url”
value=”jdbc:mysql://localhost:3306/moodle” />
<property name=”username” value=”root” />
<property name=”password” value=”” />
</bean>

<osgi:service id=”moodleDSOsgiService” ref=”moodleDS” interface=”javax.sql.DataSource” />

</beans>

See my Google Document for details!

 

Connecting to a database with a webService (cxf) deployed (jbi) in Servicemix 30 May 2009

Filed under: Me — Matteo @ 11:53
Tags: , , , ,

See the newer post at www.redaelli.org

Introduction

Apache ServiceMix at the moment doesn’t have a JBI component for connecting to a database (servicemiix-jdbc is in the roadmap): in the meanwhile you have to use servicemix-cxf or servicemix-bean.

This example (cxf-wsdl-first-jdbc.zip, cxf-wsdl-first.pdf)  is built on top of the example cxf-wsdl-first and can be deployed in apache servicemix 4.0 as JBI sa package.

(more…)