1. Create a simple project as below.
2. Listener Configuration is below
3. Select configuration.
Note:
a. Download MySQL connector - https://dev.mysql.com/downloads/connector/j/.
b. Select Local file and add it.
c. The password is also mule.
4. Transform Configuration.
a. Create a json file with the below.
b. While adding metadata type, use the json file created in above step.
c. Drag and drop to match.
5. Logger Configuration.
6. Run the application.
Output:
Open http://localhost:8081/db in the browser to view the result from the table
3. Select configuration.
Note:
a. Download MySQL connector - https://dev.mysql.com/downloads/connector/j/.
b. Select Local file and add it.
c. The password is also mule.
4. Transform Configuration.
a. Create a json file with the below.
- [
- {
- "ID":1,
- "code1":"test1",
- "code2":"testing1",
- "airlineName":"testing1",
- "toAirport":"testing1",
- "fromAirport":"testing1",
- "takeOffDate":"2011/11/11",
- "price":100,
- "planeType":"testing1",
- "setatsAvailable":10,
- "totalSeats":250
- },
- {
- "ID":2,
- "code1":"test",
- "code2":"testing",
- "airlineName":"testing",
- "toAirport":"testing",
- "fromAirport":"testing",
- "takeOffDate":"2010/10/10",
- "price":100,
- "planeType":"testing",
- "setatsAvailable":10,
- "totalSeats":250
- }
- ]
b. While adding metadata type, use the json file created in above step.
c. Drag and drop to match.
5. Logger Configuration.
6. Run the application.
Output:
Open http://localhost:8081/db in the browser to view the result from the table
No comments:
Post a Comment