You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@servicemix.apache.org by Artur Karazniewicz <ka...@aster.pl> on 2007/07/31 17:23:52 UTC
New JDBC components for ServiceMix
Guys,
I plan to start implementation of new JDBC components for ServiceMix. I know
that for the
time being we have simple JDBC component, but to be honest - it's really
simple and in my
experience we should provide something more sophisticated (I plan to provide
support for selects, updates/inserts, stored procedures and database
polling). Just want to check if, maybe,
someone is working on something like this right now? If yes please let me
know, I want to avoid
duplicated work, also would like, with pleasure, offer my help working on
this. If no, please,
could You judge - that would be better to develop LW component, like current
JDBC (but more powerful) or would You prefer JBI component? What are Your
thoughts.
regards
Artur
--
View this message in context: http://www.nabble.com/New-JDBC-components-for-ServiceMix-tf4193713s12049.html#a11926363
Sent from the ServiceMix - Dev mailing list archive at Nabble.com.
Re: New JDBC components for ServiceMix
Posted by Gianfranco Boccalon <gb...@tiscali.it>.
In Spagic (www.spagic.org), an integration platform that uses
ServiceMix, we implemented a quite sophisticated JDBC component (it's a
lightweight component).
If you want to know more about it, you can see the document
"Spagic_Studio_Components.zip" released in the Spagic documentation.
Best Regards
Gianfranco Boccalon
Artur Karazniewicz ha scritto:
> Guys,
>
> I plan to start implementation of new JDBC components for ServiceMix. I know
> that for the
> time being we have simple JDBC component, but to be honest - it's really
> simple and in my
> experience we should provide something more sophisticated (I plan to provide
> support for selects, updates/inserts, stored procedures and database
> polling). Just want to check if, maybe,
> someone is working on something like this right now? If yes please let me
> know, I want to avoid
> duplicated work, also would like, with pleasure, offer my help working on
> this. If no, please,
> could You judge - that would be better to develop LW component, like current
> JDBC (but more powerful) or would You prefer JBI component? What are Your
> thoughts.
>
> regards
> Artur
>
Re: New JDBC components for ServiceMix
Posted by Andrea Zoppello <zo...@tiscali.it>.
Hi,
If you need an Advanced JDBC Component take a look at spagic advanced
jdbc component.
1) You could have query with parameters, and for each paramater choose
how you want to be populated
starting from input message
2) You could execute stored procedure.
Andrea
splatch ha scritto:
> Last time I improved ehcache component for FUSE 3.3.1.2 (from some attach in
> jira). I think I could implement JDBC component. Now I've many service units
> based on spring-jdbc, but it's hard to write and test new units because
> configuration is complex.
>
> The biggest query - what component should return? Flat XML or populated
> object? Maybe it should be able to use user defined strategy? What do you
> think? Component with only one parameter (sq query) its too simple, does it?
>
> Regards,
> Luke
>
>
>
> Reda wrote:
>
>> Ciao
>>
>> Any news regarding a jbi component for JDBC?
>>
>> Thanks
>> Matteo
>>
>>
>> gnodet wrote:
>>
>>>> That would be a great addition !
>>>> A JBI component please :-)
>>>> Lightweight components are kinda deprecated and have lots of problems
>>>> with classloaders. A standard JBI component should be quite easy to
>>>> write,
>>>> although servicemix-common is not much documented.
>>>>
>>>> On 7/31/07, Artur Karazniewicz <ka...@aster.pl> wrote:
>>>>
>>>> Guys,
>>>>
>>>> I plan to start implementation of new JDBC components for ServiceMix. I
>>>> know
>>>> that for the
>>>> time being we have simple JDBC component, but to be honest - it's really
>>>> simple and in my
>>>> experience we should provide something more sophisticated (I plan to
>>>> provide
>>>> support for selects, updates/inserts, stored procedures and database
>>>> polling). Just want to check if, maybe,
>>>> someone is working on something like this right now? If yes please let
>>>> me
>>>> know, I want to avoid
>>>> duplicated work, also would like, with pleasure, offer my help working
>>>> on
>>>> this. If no, please,
>>>> could You judge - that would be better to develop LW component, like
>>>> current
>>>> JDBC (but more powerful) or would You prefer JBI component? What are
>>>> Your
>>>> thoughts.
>>>>
>>>> regards
>>>> Artur
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/New-JDBC-components-for-ServiceMix-tf4193713s12049.html#a11926363
>>>> Sent from the ServiceMix - Dev mailing list archive at Nabble.com.
>>>>
>>>>
>>>>
>>> --
>>> Cheers,
>>> Guillaume Nodet
>>> ------------------------
>>> Principal Engineer, IONA
>>> Blog: http://gnodet.blogspot.com/
>>>
>>>
>>>
>>
>
>
Re: New JDBC components for ServiceMix
Posted by splatch <l....@pocztowy.pl>.
Last time I improved ehcache component for FUSE 3.3.1.2 (from some attach in
jira). I think I could implement JDBC component. Now I've many service units
based on spring-jdbc, but it's hard to write and test new units because
configuration is complex.
The biggest query - what component should return? Flat XML or populated
object? Maybe it should be able to use user defined strategy? What do you
think? Component with only one parameter (sq query) its too simple, does it?
Regards,
Luke
Reda wrote:
>
> Ciao
>
> Any news regarding a jbi component for JDBC?
>
> Thanks
> Matteo
>
>
> gnodet wrote:
>>
>>>That would be a great addition !
>>> A JBI component please :-)
>>> Lightweight components are kinda deprecated and have lots of problems
>>> with classloaders. A standard JBI component should be quite easy to
>>> write,
>>> although servicemix-common is not much documented.
>>
>>> On 7/31/07, Artur Karazniewicz <ka...@aster.pl> wrote:
>>>
>>> Guys,
>>>
>>> I plan to start implementation of new JDBC components for ServiceMix. I
>>> know
>>> that for the
>>> time being we have simple JDBC component, but to be honest - it's really
>>> simple and in my
>>> experience we should provide something more sophisticated (I plan to
>>> provide
>>> support for selects, updates/inserts, stored procedures and database
>>> polling). Just want to check if, maybe,
>>> someone is working on something like this right now? If yes please let
>>> me
>>> know, I want to avoid
>>> duplicated work, also would like, with pleasure, offer my help working
>>> on
>>> this. If no, please,
>>> could You judge - that would be better to develop LW component, like
>>> current
>>> JDBC (but more powerful) or would You prefer JBI component? What are
>>> Your
>>> thoughts.
>>>
>>> regards
>>> Artur
>>> --
>>> View this message in context:
>>> http://www.nabble.com/New-JDBC-components-for-ServiceMix-tf4193713s12049.html#a11926363
>>> Sent from the ServiceMix - Dev mailing list archive at Nabble.com.
>>>
>>>
>>
>>
>> --
>> Cheers,
>> Guillaume Nodet
>> ------------------------
>> Principal Engineer, IONA
>> Blog: http://gnodet.blogspot.com/
>>
>>
>
>
--
View this message in context: http://www.nabble.com/New-JDBC-components-for-ServiceMix-tp11926363p19433372.html
Sent from the ServiceMix - Dev mailing list archive at Nabble.com.
Re: New JDBC components for ServiceMix
Posted by Bruce Snyder <br...@gmail.com>.
On Dec 25, 2007 7:57 AM, Matteo Redaelli <ma...@libero.it> wrote:
>
> Ciao
>
> Any news regarding a jbi component for JDBC?
JDBC can be used today by simply deploying POJOs (Plain Old Java
Objects) via the servicemix-bean component. You can create anything
you want in a POJO. Therefore, accessing a datastore via JDBC is as
simple as writing Java code.
Bruce
--
perl -e 'print unpack("u30","D0G)U8V4\@4VYY9&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
);'
Apache ActiveMQ - http://activemq.org/
Apache Camel - http://activemq.org/camel/
Apache ServiceMix - http://servicemix.org/
Apache Geronimo - http://geronimo.apache.org/
Blog: http://bruceblog.org/
Re: New JDBC components for ServiceMix
Posted by Matteo Redaelli <ma...@libero.it>.
Ciao
Any news regarding a jbi component for JDBC?
Thanks
Matteo
gnodet wrote:
>
>>That would be a great addition !
>> A JBI component please :-)
>> Lightweight components are kinda deprecated and have lots of problems
>> with classloaders. A standard JBI component should be quite easy to
>> write,
>> although servicemix-common is not much documented.
>
>> On 7/31/07, Artur Karazniewicz <ka...@aster.pl> wrote:
>>
>> Guys,
>>
>> I plan to start implementation of new JDBC components for ServiceMix. I
>> know
>> that for the
>> time being we have simple JDBC component, but to be honest - it's really
>> simple and in my
>> experience we should provide something more sophisticated (I plan to
>> provide
>> support for selects, updates/inserts, stored procedures and database
>> polling). Just want to check if, maybe,
>> someone is working on something like this right now? If yes please let me
>> know, I want to avoid
>> duplicated work, also would like, with pleasure, offer my help working on
>> this. If no, please,
>> could You judge - that would be better to develop LW component, like
>> current
>> JDBC (but more powerful) or would You prefer JBI component? What are Your
>> thoughts.
>>
>> regards
>> Artur
>> --
>> View this message in context:
>> http://www.nabble.com/New-JDBC-components-for-ServiceMix-tf4193713s12049.html#a11926363
>> Sent from the ServiceMix - Dev mailing list archive at Nabble.com.
>>
>>
>
>
> --
> Cheers,
> Guillaume Nodet
> ------------------------
> Principal Engineer, IONA
> Blog: http://gnodet.blogspot.com/
>
>
--
View this message in context: http://www.nabble.com/New-JDBC-components-for-ServiceMix-tp11926363s12049p14495628.html
Sent from the ServiceMix - Dev mailing list archive at Nabble.com.
Re: New JDBC components for ServiceMix
Posted by Guillaume Nodet <gn...@gmail.com>.
That would be a great addition !
A JBI component please :-)
Lightweight components are kinda deprecated and have lots of problems
with classloaders. A standard JBI component should be quite easy to
write,
although servicemix-common is not much documented.
On 7/31/07, Artur Karazniewicz <ka...@aster.pl> wrote:
>
> Guys,
>
> I plan to start implementation of new JDBC components for ServiceMix. I know
> that for the
> time being we have simple JDBC component, but to be honest - it's really
> simple and in my
> experience we should provide something more sophisticated (I plan to provide
> support for selects, updates/inserts, stored procedures and database
> polling). Just want to check if, maybe,
> someone is working on something like this right now? If yes please let me
> know, I want to avoid
> duplicated work, also would like, with pleasure, offer my help working on
> this. If no, please,
> could You judge - that would be better to develop LW component, like current
> JDBC (but more powerful) or would You prefer JBI component? What are Your
> thoughts.
>
> regards
> Artur
> --
> View this message in context: http://www.nabble.com/New-JDBC-components-for-ServiceMix-tf4193713s12049.html#a11926363
> Sent from the ServiceMix - Dev mailing list archive at Nabble.com.
>
>
--
Cheers,
Guillaume Nodet
------------------------
Principal Engineer, IONA
Blog: http://gnodet.blogspot.com/