Adding MySQL JDBC driver to IM Connector Server
search cancel

Adding MySQL JDBC driver to IM Connector Server


Article ID: 220590


Updated On:


CA Identity Manager CA Identity Suite


The following KB article explains how to add MySQL JDBC driver to Connector Xpress:

This allows to successfully deploy JDBC dynamic namespace (endpoint type) for MySQL. However, an attempt to acquire MySQL endpoint in the created namespace fails with this error:

JDBC: Cannot create JDBC driver of class '' for connect URL 'jdbc:mysql://XXX.XXX.XXX.XXX:3306/testdb?characterEncoding=latin1' 


Release : 14.x



OOTB IM Connector Server does not have MySQL JDBC driver


In order to deploy MySQL JDBC driver in the IM Connector Server please follow the below steps. On vApp use 'config' user.

1) Download the mysql-connector-java-5.0.8.tar.gz or archive from the following location: (from 'Archives')

2) Extract mysql-connector-java-5.0.8-bin.jar from the downloaded archive

3) Copy the mysql-connector-java-5.0.8-bin.jar file to the machine where IM Connector Server is installed

4) Copy the archive attached to to this KB article to the following location on the machine where IM Connector Server is installed:

Linux: /opt/CA/IdentityManager/ConnectorServer/jcs/resources/jdbc

Windows: C:\Program Files (x86)\CA\Identity Manager\Connector Server\jcs\resources\jdbc

5) Extract the files from the above archive

6) Linux: change permissions of the jdbc_mysql_post_install script:

chmod a+x jdbc_mysql_post_install

7) Run the script:

Linux: jdbc_mysql_post_install 

Windows: jdbc_mysql_post_install.bat

The following example is from vApp:

config@vm1 VAPP-14.3.0 ( > cd /opt/CA/IdentityManager/ConnectorServer/jcs/resources/jdbc/
config@vm1 VAPP-14.3.0 ( > unzip
  inflating: jdbc_mysql_post_install
  inflating: jdbc_mysql_post_install.bat
config@vm1 VAPP-14.3.0 ( > chmod a+x jdbc_mysql_post_install
config@vm1 VAPP-14.3.0 ( > ./jdbc_mysql_post_install

* ----------------------------------------------------------------------
* Provide location of required libraries
* ----------------------------------------------------------------------

Please provide the full path of a folder that contains this file:



* ----------------------------------------------------------------------
* Create JDBC MySQL OSGi fragment bundle
* ----------------------------------------------------------------------

Building fragment bundle with following options: [-manifestfile, /opt/CA/IdentityManager/ConnectorServer/jcs/resources/jdbc/, -fragmentjarname, /opt/CA/IdentityManager/ConnectorServer/jcs/resources/jdbc/jdbcMysqlConnectorLibsOsgi.jar, -jardir, /home/config/]
Created /opt/CA/IdentityManager/ConnectorServer/jcs/resources/jdbc/jdbcMysqlConnectorLibsOsgi.jar

The generated bundle fragment is now ready to be installed using the Connector Server Management UI.

config@vm1 VAPP-14.3.0 ( >

8) Copy resulting fragment bundle file jdbcMysqlConnectorLibsOsgi.jar to the machine/location where you can select it from Connector Server Console

9) Open Connector Server Console in your browser and logon using 'admin' user. URL:

http://<CS machine>:20080
https://<CS machine>:20443

10) Add a new bundle:

      - Select 'Bundles' tab
      - 'Bundles / + Add'
      - Browse to the location and select jdbcMysqlConnectorLibsOsgi.jar file
      - Select 'Local Connector Server' > 'OK':

      - New bundle 'JCS :: JDBC :: MySQL JDBC Driver v5.0.8' will appear, search for it and select it
      - Right click and invoke 'Refresh Imports' from popup menu.
        New bundle status will change from 'Installed' to 'Fragment ('

The Connector Server now has MySQL JDBC driver.

Attachments get_app