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!

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!

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

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.

Http statistics with curl

With CURL and RRDTOOL it is possible to collect http request statistics.

Below you can find the 2 scripts

ICA-ATOM (QUBIT), THE OpenSource archival description software

I've collected some information about ICA-ATOM (based on QuBit). Please read my presentation from Google Docs

Ruby Wordlist Generator (ruby-wg)

After many years I've updated my Wordlist Generator project! I've seen in several forums that some people still use my old perl script wg.pl

The new ruby project is hosted at http://code.google.com/p/ruby-words-generators/

ruby-wg can be used to generate wordlist for the famous password cracker John the Ripper