The JDBC transport allows you to poll for messages in a table. However, by default the JDBC inbound endpoint splits the record set into individual MuleMessages, and the outbound endpoint only receives a single row at a time. If you want to select multiple rows at a time and process the rows in a single transaction, you can take the following steps.
(more…)

Are you trying to poll a database and transform the results to a certain plain text file? Do you need to pick up a data file, split it into individual records and insert those records into the database? Would you like to poll a source database and send the results to another database for insertion? (more…)