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


Reply via email to