• If necessary, you can download the MySQL JDBC Driver from this location.  Make sure that the driver version is appropriate for your Java and MySQL versions.

           Download Connector/J

• The MySQL JDBC Driver is implemented in a file with a name similar to mysql-connector-java-5.1.36-bin.jar (the specific file name may vary according to the version being used).  You may need to copy the file to the /jar directory of your JSM instance and restart the Java Service Manager before using the driver with Transformation Maps in LANSA Composer.

• Refer to relevant MySQL resources for more information on the JDBC drivers available for MySQL and the keywords and values that can be specified in the JDBC connection string.  Following are some useful references.

           MySQL Downloads

           MySQL Connectors

           Download Connector/J

           Connector/J Reference

           Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J

           ConnectionStrings.com - Forgot that connection string? Get it here!