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

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

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:camel-osgi="http://activemq.apache.org/camel/schema/osgi"
xmlns:osgi="http://www.springframework.org/schema/osgi"
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">

<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!

venerdì 5 giugno 2009

ISTAT is moving from SAS to R

"Istat [..] helps to develop 'R Project', a statistical open source application. "We have donated software libraries to R, and are moving away from using SAS, the proprietary alternative to R. We contributed to the statistical application Adamsoft, which is being developed at the Caspur computing-lab, just two kilometres away from our institute."

Vaccari says adopting open source requires institutes to make adjustments in their organisational culture. "It changes how people work, from 'I'm important because I'm a bottleneck, to I'm important because I share things'."

Read it!