You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@servicemix.apache.org by Mark Lui <ml...@alodar.com> on 2006/05/09 09:22:59 UTC
Is a JDBC Binding Component needed?
I am not sure if my question was clear from my original post so here it
is again:
Does anyone on this list know if a JDBC Binding Component needs to be
written to provide database communication with the ServiceMix bus? Or
is the support currently provided by one of the components?
Thanks,
Mark
--
Mark Lui
mlui@alodar.com
310-737-7835
Re: Is a JDBC Binding Component needed?
Posted by Guillaume Nodet <gn...@gmail.com>.
There is no time line defined, so if you want to work on it, feel free ;)
The JDBC BC could act as a provider (processing incoming queries
QUID), or a consumer when polling the database.
This S part could be implemented by flagging / deleting rows (in a
single table) that have been processed, using the database as a short
term storage.
A real need is to be able to parameterize the queries by using data in
the jbi message: this could be handled using o.a.servicemix.expression
package.
Btw, you can also take a look at the xsql component at Codehaus (but
it uses Oracle libraries and thus can not be used at Apache).
See http://cvs.codehaus.org/viewrep/servicemix/trunk/sandbox/core/src/main/java/org/servicemix/components/xsql/XSQLComponent.java?r=1067
Cheers,
Guillaume Nodet
On 5/10/06, Mark Lui <ml...@alodar.com> wrote:
> Adrian,
>
> Thanks for the response. I will definitely take a look at the
> JdbcComponent.
>
> Typically JDBC Component (adapter) needs to support SQUID:
>
> S - Signal (notification)
> Q - Query (which you are supporting)
> U - Update
> I - Insert
> D - Delete
>
> I work for a small System Integration company and we are interested in
> creating an open source Integration demo of which JDBC support is a key
> requirement. What is current time line for this component? And let me
> know if you need any help.
>
> Thanks,
>
> Mark
>
> Adrian Co wrote:
> > Hi,
> >
> > I've just committed the initial spike for a JdbcComponent
> > (org.apache.servicemix.components.jdbc.JdbcComponent ). Basically, its
> > a version of a one I used for a demo using SM. I'm not sure of the
> > functionalities to include, so feel free to provide comments. :-)
> >
> > As of the moment, the components is able to accept a "<sql> query
> > </sql>" message, and return the result set or update count in the
> > following format:
> > <sqlResult><resultSet><row/><row/>...</resultSet><sqlResult> or
> > <sqlResult><updateCount/></sqlResult>.
> >
> > It also has a responseRequired setting, which when set to true, will
> > always create a response even if the query returns an empty set, but
> > when set to false, will only return a response if there are rows in
> > the resultSet.
> >
> > Regards,
> > Adrian Co
> >
> > Mark Lui wrote:
> >
> >> I am not sure if my question was clear from my original post so here
> >> it is again:
> >>
> >> Does anyone on this list know if a JDBC Binding Component needs to be
> >> written to provide database communication with the ServiceMix bus?
> >> Or is the support currently provided by one of the components?
> >>
> >> Thanks,
> >>
> >> Mark
> >>
> >
> >
>
> --
>
> Mark Lui
> mlui@alodar.com
> 310-737-7835
>
Re: Is a JDBC Binding Component needed?
Posted by Mark Lui <ml...@alodar.com>.
Adrian,
Thanks for the response. I will definitely take a look at the
JdbcComponent.
Typically JDBC Component (adapter) needs to support SQUID:
S - Signal (notification)
Q - Query (which you are supporting)
U - Update
I - Insert
D - Delete
I work for a small System Integration company and we are interested in
creating an open source Integration demo of which JDBC support is a key
requirement. What is current time line for this component? And let me
know if you need any help.
Thanks,
Mark
Adrian Co wrote:
> Hi,
>
> I've just committed the initial spike for a JdbcComponent
> (org.apache.servicemix.components.jdbc.JdbcComponent ). Basically, its
> a version of a one I used for a demo using SM. I'm not sure of the
> functionalities to include, so feel free to provide comments. :-)
>
> As of the moment, the components is able to accept a "<sql> query
> </sql>" message, and return the result set or update count in the
> following format:
> <sqlResult><resultSet><row/><row/>...</resultSet><sqlResult> or
> <sqlResult><updateCount/></sqlResult>.
>
> It also has a responseRequired setting, which when set to true, will
> always create a response even if the query returns an empty set, but
> when set to false, will only return a response if there are rows in
> the resultSet.
>
> Regards,
> Adrian Co
>
> Mark Lui wrote:
>
>> I am not sure if my question was clear from my original post so here
>> it is again:
>>
>> Does anyone on this list know if a JDBC Binding Component needs to be
>> written to provide database communication with the ServiceMix bus?
>> Or is the support currently provided by one of the components?
>>
>> Thanks,
>>
>> Mark
>>
>
>
--
Mark Lui
mlui@alodar.com
310-737-7835
Re: Is a JDBC Binding Component needed?
Posted by Simon Carni <sc...@siol.net>.
Hi,
I was thinking about developing (in near future :-)) an iBatis
(http://ibatis.apache.org/) component. Would this be interesting?
Cheers,
Simon
"Adrian Co" <ac...@exist.com> wrote in message
news:44608B3A.6020100@exist.com...
> Hi,
>
> I've just committed the initial spike for a JdbcComponent
> (org.apache.servicemix.components.jdbc.JdbcComponent ). Basically, its a
> version of a one I used for a demo using SM. I'm not sure of the
> functionalities to include, so feel free to provide comments. :-)
>
> As of the moment, the components is able to accept a "<sql> query </sql>"
> message, and return the result set or update count in the following
> format: <sqlResult><resultSet><row/><row/>...</resultSet><sqlResult> or
> <sqlResult><updateCount/></sqlResult>.
>
> It also has a responseRequired setting, which when set to true, will
> always create a response even if the query returns an empty set, but when
> set to false, will only return a response if there are rows in the
> resultSet.
>
> Regards,
> Adrian Co
>
> Mark Lui wrote:
>
>> I am not sure if my question was clear from my original post so here it
>> is again:
>>
>> Does anyone on this list know if a JDBC Binding Component needs to be
>> written to provide database communication with the ServiceMix bus? Or is
>> the support currently provided by one of the components?
>>
>> Thanks,
>>
>> Mark
>>
>
>
Re: Is a JDBC Binding Component needed?
Posted by Adrian Co <ac...@exist.com>.
Hi,
I've just committed the initial spike for a JdbcComponent
(org.apache.servicemix.components.jdbc.JdbcComponent ). Basically, its a
version of a one I used for a demo using SM. I'm not sure of the
functionalities to include, so feel free to provide comments. :-)
As of the moment, the components is able to accept a "<sql> query
</sql>" message, and return the result set or update count in the
following format:
<sqlResult><resultSet><row/><row/>...</resultSet><sqlResult> or
<sqlResult><updateCount/></sqlResult>.
It also has a responseRequired setting, which when set to true, will
always create a response even if the query returns an empty set, but
when set to false, will only return a response if there are rows in the
resultSet.
Regards,
Adrian Co
Mark Lui wrote:
> I am not sure if my question was clear from my original post so here
> it is again:
>
> Does anyone on this list know if a JDBC Binding Component needs to be
> written to provide database communication with the ServiceMix bus? Or
> is the support currently provided by one of the components?
>
> Thanks,
>
> Mark
>