O'Reilly logo

Mule ESB Cookbook by Uchit Vyas, Azaz Desai, Abdul Samad, Dr. Zakir Laliwala

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required