Using the JDBC Endpoint to connect to the database

The JDBC Endpoint is used to communicate with the database. It's used for retrieving, updating, deleting, and inserting database records. We will see an example on how it works. In this example, we will retrieve data from the database and store it in a file on our local hard drive.

Getting ready

In this section, we will see how to use and configure the JDBC component in Mule Studio. In this example you will use three components: the JDBC Endpoint, the Object-to-String transformer, and the File Outbound Endpoint.

  1. We will use one JDBC Endpoint, a data source, and the File Outbound Endpoint. Retrieve the record from the MySQL database and store it on the local hard drive.
  2. To create a new project, go ...

Get Mule ESB Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.