mule Connection to MySQL Database Using Anypoint Studio (Mule) Select Rows from MySQL Data Base in Anypoint Studio(Mule)

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Insert
> Step 2: And Like the video. BONUS: You can also share it!

Example

Step1 Message Flow: [![enter image description here][1]][1]

Step 2: Databse Connector Configuration

For this you need mysql-connector-java-5.1.40-bin.jar . Right click on Project -->build Path--> Add external archieve and add the jar(without jar it cannot be connected) Enter all the values correctly mentioned below screenshot. Then Click Test connection and should show connection successful

Query: select * from test.contact

where test =Schema name or database name and contact is table name. [![enter image description here][2]][2]

3) XML view

Use Object to JSON connector and leave the fields as it is

Use setpayload connector and enter the VALUE attribute as #[payload]

[![enter image description here][3]][3]

Final Step: Deploye the project , run as mule application. After running.. run the url either in POSTMAN or Chrome. http://localhost:8089/test

8089 is my local port. Whatever u mention run with that port.

[![enter image description here][4]][4]

Finally the Values are displayed in JSON format. Try to run Different Queries.

Am new to Mule. Found informative and posting it. [1]: https://i.stack.imgur.com/jt4tS.png [2]: https://i.stack.imgur.com/oNQJe.png [3]: https://i.stack.imgur.com/EI7U4.png [4]: https://i.stack.imgur.com/taq6z.png



Got any mule Question?