Pre-Requisites
- Windows 10 OS.
- MySQL 8.0 server and Command-Line Client.
- JDBC driver for MySQL (http://dev.mysql.com/downloads/connector/j/). Download it to your local machine.
- WSO2 Integration Studio 8.0.0.
Implementation Steps
DB Creation (Run the below commands in MySQL command-line client to create a database and table for this demo)->
- Create Database Students
- Use Students
- CREATE TABLE Students (StudentID int, FirstName varchar(255), LastName varchar(255), Result varchar(255))
Service Implementation in Integration Studio
1. Create a new Maven Multi-Module project on Getting Started page.