changes.mady.by.user Rukshani Weerasinha
Saved on May 14, 2019
Follow the steps given below to set up a MySQL database for this tutorial.
Download the product installer from here, and run the installer.
Download the JDBC driver for MySQL from here and copy it to your . Unzip it, get the <MySQL_HOME>/mysql-connector-java-8.0.16.jar JAR, and place it in the <EI_HOME>/lib directory.
If the driver class does not exist in the relevant folders when you create the datasource, you will get an exception, such as 'Cannot load JDBC driver class com.mysql.jdbc.Driver'.
Cannot load JDBC driver class com.mysql.jdbc.Driver
Create a database named Employees.
CREATE DATABASE Employees;
Create the Employee table inside the Employees database:
CREATE TABLE Employees (EmployeeNumber int(11) NOT NULL, FirstName varchar(255) NOT NULL, LastName varchar(255) DEFAULT NULL, Email varchar(255) DEFAULT NULL, Salary varchar(255));
Powered by a free Atlassian Confluence Community License granted to WSO2, Inc.. Evaluate Confluence today.