Working with Databases (JDBC) in Mule Studio

In this blog post, I’ll give you some background information about JDBC, explain what Mule ESB and Studio do with JDBC, and demonstrate how can you use it in a simple example.

A little reference for JDBC:

JDBC, which stands for Java Database Connectivity, is basically an API that enables users to execute operations over a Data Source using the Java programming language. This API allows you to connect to almost any Data Source system,

Mule Tip: Including formatted SQL statements from external files in your application

November 18 2011

5 comments
motif

When developing a Mule Application the normal way to define an SQL statement is by declaring it directly in the connector, as shown in the following snippet.

However is possible that you’ll face a situation in which you have to use large and complex queries. For that scenario the previous approach is not adequate since you’ll end up with a configuration difficult to read. So the best thing to do is to externalize these queries in one or more files.

Mule Studio Beta Milestone 2 is here

motif

Selecting Multiple Rows Using a JDBC Inbound Endpoint

motif

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.

Technical Webinar tomorrow: Mule for ETL

motif

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?