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
[EMAIL PROTECTED]
310-737-7835
