Download to read offline
![Let’s start the server and point our browser to the configured url to trigger the flow, The output on console should be something like this: [[db_test].HTTP_Listener_Configuration.worker.0 1] org.mule.api.processor.LoggerMessageProcessor: 1 The «1» in the payload is a boolean value saying that everything was ok! So, we are ready to show the inserted record: As you can see, we have now our record!](https://image.slidesharecdn.com/muleesbdb2-160518085141/75/Mule-esb-How-to-make-CRUD-operations-to-a-MySql-Database-in-5-minutes-4-2048.jpg)
![Our next goal is to delete our newly created record. To do it, configure the db component in this way: Let’s start the server and point our browser to the configured url to trigger the flow, The output on console should be something like this: [[db_test].HTTP_Listener_Configuration.worker.0 1] org.mule.api.processor.LoggerMessageProcessor: 1 The «1» in the payload, again, is a boolean value saying that everything was ok! So, we are ready to show the the user table:](https://image.slidesharecdn.com/muleesbdb2-160518085141/75/Mule-esb-How-to-make-CRUD-operations-to-a-MySql-Database-in-5-minutes-5-2048.jpg)
GS
Uploaded byGennaro Spagnoli
PPTX, PDF366 views
Mule esb - How to make CRUD operations to a MySql Database in 5 minutes
This document provides steps to perform CRUD operations on a MySQL database using Mule ESB in 5 minutes. It describes creating a Mule flow connected to a MySQL database, performing a select query to check existing data, configuring components to insert a new record which is verified, and then deleting the inserted record which is also verified. The process demonstrates how to create, read, update and delete data from a MySQL database using Mule ESB components.
More Related Content
What's hot
Viewers also liked
Similar to Mule esb - How to make CRUD operations to a MySql Database in 5 minutes
More from Gennaro Spagnoli
Recently uploaded
Mule esb - How to make CRUD operations to a MySql Database in 5 minutes
- 1. Mule ESB How tomake CRUD operations to a MySql Database in 5 minutes Gennaro Spagnoli - 2016
- 2. Gennaro Spagnoli -2016 Let’s assume you have a fully configured MySql instance in local environment, and you can access to phpmyadmin administration tool. As a first step, we will be creating a flow with a configured database instance:
- 3. Gennaro Spagnoli -2016 Now let’s making a select query on our db administration tool to check the data already present on the db: Having done this, we’re now ready to configure the mule component in order to write some new data on the database:
- 4. Let’s start theserver and point our browser to the configured url to trigger the flow, The output on console should be something like this: [[db_test].HTTP_Listener_Configuration.worker.0 1] org.mule.api.processor.LoggerMessageProcessor: 1 The «1» in the payload is a boolean value saying that everything was ok! So, we are ready to show the inserted record: As you can see, we have now our record!
- 5. Our next goalis to delete our newly created record. To do it, configure the db component in this way: Let’s start the server and point our browser to the configured url to trigger the flow, The output on console should be something like this: [[db_test].HTTP_Listener_Configuration.worker.0 1] org.mule.api.processor.LoggerMessageProcessor: 1 The «1» in the payload, again, is a boolean value saying that everything was ok! So, we are ready to show the the user table: