You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@servicemix.apache.org by ma...@uk.bnpparibas.com on 2008/01/11 12:16:13 UTC

Writing a ServiceMix component

hello all,

i need to write an application in which i need to listens to ,
let's say, 10 queues for incoming messages.
This message will be parsed , resulting in a set of SQL statements that
need to be inserted into the database.
I looked at ServiceMix as a possible solution for that (instead of having
a set of n threads sitting there and waiting to receive messages)..

Now, forgetting about fault tolerance and doing the easy way, i figured
out i'll need @least a component that listens to a queue and one that
insert data into the database.

I had a look at existing components, and i was able to find the one that
listens to queue but not one for inserting database....

So, unless someone knows of an existing one.. i think i'll have to write
my own.......

anyone could comment?

thanks and regards
marco

This communication is confidential, may be privileged and is meant only for the intended recipient. If you are
not the intended recipient, please notify the sender by reply and delete this message from your system. Any
unauthorised dissemination, distribution or copying hereof is prohibited.

BNP Paribas Fund Services UK Limited, BNP Paribas Trust Corporation UK Limited, BNP Paribas UK Limited,
BNP Paribas Commodity Futures Ltd and Investment Fund Services Limited are authorised and regulated by
the Financial Services Authority.

BNP Paribas, BNP Paribas Securities Services and BNP Paribas Private Bank are authorised by the CECEI
and AMF. BNP Paribas London Branch, BNP Paribas Securities Services London Branch and BNP Paribas
Private Bank London Branch are regulated by the Financial Services Authority for the conduct of their UK
business. BNP Paribas Securities Services London Branch is also a member of the London Stock Exchange.

Re: Writing a ServiceMix component

Posted by Andrea Zoppello <zo...@tiscali.it>.

Hi,

If you're interested, you could look at spagic-project here:

http://forge.objectweb.org/projects/spagic
http://spagic.org

it will provide an advanced jdbc component ( It's implemented as a 
lightweight lw component ) where you could:

1) Execute sql statements or call stored procedure

2) Map each parameters of an input normalizad message to your query, 
stored procedure, with xpath
extraction rules.

Andrea


marco.mistroni@uk.bnpparibas.com ha scritto:
> hello all,
>  
>         i need to write an application in which i need to listens to , 
> let's say, 10 queues for incoming messages.
> This message will be parsed , resulting in a set of SQL statements that 
> need to be inserted into the database.
> I looked at ServiceMix as a possible solution for that (instead of having 
> a set of n threads sitting there and waiting to receive messages)..
>
>
> Now, forgetting about fault tolerance and doing the easy way, i figured 
> out i'll need @least a component that listens to a queue and one that 
> insert data into the database.
>
> I had a look at existing components, and i was able to find the one that 
> listens to queue but not one for inserting database.... 
>
> So, unless someone knows of an existing one.. i think i'll have to write 
> my own.......
>
> anyone could comment?
>
>
> thanks and regards
>          marco
>
>
> This communication is confidential, may be privileged and is meant only for the intended recipient.  If you are 
> not the intended recipient, please notify the sender by reply and delete this message from your system.  Any 
> unauthorised dissemination, distribution or copying hereof is prohibited.
>
> BNP Paribas Fund Services UK Limited, BNP Paribas Trust Corporation UK Limited, BNP Paribas UK Limited, 
> BNP Paribas Commodity Futures Ltd and Investment Fund Services Limited are authorised and regulated by 
> the Financial Services Authority.
>
> BNP Paribas, BNP Paribas Securities Services and BNP Paribas Private Bank are authorised by the CECEI 
> and AMF.  BNP Paribas London Branch, BNP Paribas Securities Services London Branch and BNP Paribas 
> Private Bank London Branch are regulated by the Financial Services Authority for the conduct of their UK 
> business.  BNP Paribas Securities Services London Branch is also a member of the London Stock Exchange.
>
>
>

Re: Writing a ServiceMix component

Posted by ilango <il...@yahoo.com>.

Interesting, because I am working on similar lines. Have you got something working so far. I could brainstorm myself and come up with ideas?

Do you wish to share what you have done so far?

marco.mistroni@uk.bnpparibas.com wrote:
hello all,

Now, forgetting about fault tolerance and doing the easy way, i figured
out i'll need @least a component that listens to a queue and one that
insert data into the database.

I had a look at existing components, and i was able to find the one that
listens to queue but not one for inserting database....

So, unless someone knows of an existing one.. i think i'll have to write
my own.......

anyone could comment?

thanks and regards
marco

---------------------------------
Never miss a thing. Make Yahoo your homepage.