Defining the database configuration for MySQL

When the Transformation map (prepared as Java executable file) runs, it will use JDBC to establish the connection to the MySQL database on your network. This connection is initiated from the server computer on which the transformation map executes.

LANSA Composer prepares the JDBC connection according to the Database Configuration that you provide as a parameter to the Transformation Map. You must define the Database Configuration with the correct details necessary to establish the particular database connection to be used.

Example Database Configuration

The following sample values assume that you are using the MySQL JDBC driver to connect to the MySQL database:

Database driver class	Following is the class name used with the MySQL JDBC driver: com.mysql.jdbc.Driver
Database connection string	Following is a sample JDBC connection string to connect to the MySQL database named SAKIRA in the MySQL instance running on the server LOCALHOST: jdbc:mysql://localhost:3306/sakila?profileSQL=true

Refer also to:

Additional information and resources for MySQL