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