Page Comparison

...

1. Install the MySQL server.

2. Download the JDBC driver for MySQL from here and copy it to your <EI_HOME>/lib directory.

   Note
   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'.

3. Create the following database: Employees

4. Create the Employee table inside the Employees database:
   

   Code Block
   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));

...

Be sure to download the JDBC driver for MySQL from here and copy it to your <EI_HOME>/lib directory.

...

Creating the data service

...