Installing database

All sample projects, being discussed in the Technical Articles section, are using Sakila sample database which is available for download from the MySQL's website. The database requires MySQL server, version 5. The detailed instructions on how to quickly make it up and running can be found here.

Setting up the data source being used by sample projects

The sample projects described in the Technical Articles section are using the Sakila JDBC data source, created from the sample Sakila database. In order to be able to run the projects this data source must configured properly. The configuration steps, shown below, are the same for each of the sample projects.

• Start the MySql server on which you've installed the Sakila database.

• Start the Inforama Studio an open a project you wish to run.

• Go to Options->Set Classpath..., press the Add Jar button and choose a jar file containing MySql JDBC Driver. The driver can be downloaded from here.

Setting MySql Jdbc Driver

• Go to Data->Connections/Data Sources..., choose the Sakila data source, press the modify button and amend the connection properties.

Setting up Sakila data source

• Press the Test Connection button in order to check if the connection can be established.