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