Prerequisites for Creating a Connection
You must satisfy the following prerequisites to create a connection with the MySQL Adapter:
-
Ensure that you have write permissions on the database.
-
Ensure that you have the required permissions to run stored procedures and packages and SQL statements against the MySQL Database.
-
Know the database hostname or IP address and the port number.
-
Know the database name.
-
Know the username and password for connecting to the database.
-
Download the
mysql-connector-java-commercial-5.1.22-bin.jar
or the relevantmysql-connector
JAR based on your MySQL database version to the host on which the connectivity agent is installed.For example, perform the following steps ifmysql-connector-java-commercial-5.1.22-bin.jar
is the JAR required for your environment.-
Download the
mysql-connector-java-commercial-5.1.22-bin.jar
from the MySQL Database site. Check the Oracle Integration Adapters Certification matrix to identify the certified versions of the MySQL Database. -
Copy the JAR file to
agenthome/thirdparty/lib
. -
Restart the connectivity agent.
If you do not download and install this JAR file, you receive a
Check agent status
error when testing the connection on the Connections page in Oracle Integration.
-