Your choice will determines the available features.
The Microsoft JDBC Driver 4.1 for SQL Server provides the sqljdbc41.jar class library file.
The Microsoft JDBC Drivers 6.0 and 4.2 for SQL Server provide sqljdbc41.jar, and sqljdbc42.jar class library files. The Microsoft JDBC Driver 6.2 for SQL Server provides mssql-jdbc-6.2.2.jre7.jar, and mssql-jdbc-6.2.2.jre8.jar class library files. The Microsoft JDBC Driver 6.4 for SQL Server provides mssql-jdbc-6.4.0.jre7.jar, mssql-jdbc-6.4.0.jre8.jar, and mssql-jdbc-6.4.0.jre9.jar class library files. The Microsoft JDBC Driver 7.0 for SQL Server provides mssql-jdbc-7.0.0.jre8.jar, and mssql-jdbc-7.0.0.jre10.jar class library files. The Microsoft JDBC Driver 7.2 for SQL Server provides mssql-jdbc-7.2.2.jre8.jar, and mssql-jdbc-7.2.2.jre11.jar class library files. The Microsoft JDBC Driver 7.4 for SQL Server provides mssql-jdbc-7.4.1.jre8.jar, mssql-jdbc-7.4.1.jre11.jar, and mssql-jdbc-7.4.1.jre12.jar class library files. The Microsoft JDBC Driver 8.2 for SQL Server provides mssql-jdbc-8.2.2.jre8.jar, mssql-jdbc-8.2.2.jre11.jar, and mssql-jdbc-8.2.2.jre13.jar class library files. The Microsoft JDBC Driver 8.4 for SQL Server provides mssql-jdbc-8.4.1.jre8.jar, mssql-jdbc-8.4.1.jre11.jar, and mssql-jdbc-8.4.1.jre14.jar class library files. The Microsoft JDBC Driver 9.2 for SQL Server provides mssql-jdbc-9.2.1.jre8.jar, mssql-jdbc-9.2.1.jre11.jar, and mssql-jdbc-9.2.1.jre15.jar class library files. The Microsoft JDBC Driver 9.4 for SQL Server provides mssql-jdbc-9.4.1.jre8.jar, mssql-jdbc-9.4.1.jre11.jar, and mssql-jdbc-9.4.1.jre16.jar class library files. The Microsoft JDBC Driver 10.2 for SQL Server provides mssql-jdbc-10.2.0.jre8.jar, mssql-jdbc-10.2.0.jre11.jar, and mssql-jdbc-10.2.0.jre17.jar class library files. The Microsoft JDBC Driver provides different Jars to be used in correspondence with your preferred Java Runtime Environment (JRE) settings, as under:
Before you connect to a SQL Server database, SQL Server must first be installed on either your local computer or a server, and the JDBC driver must be installed on your local computer. The Connector Server now has MySQL JDBC driver.This section provides quickstart instructions to make a simple connection to a SQL Server database using the Microsoft JDBC Driver for SQL Server. New bundle status will change from 'Installed' to 'Fragment (com.ca.jcs.jdbc)' Right click and invoke 'Refresh Imports' from popup menu. New bundle 'JCS :: JDBC :: MySQL JDBC Driver v5.0.8' will appear, search for it and select it Select 'Local Connector Server' > 'OK': Browse to the location and select jdbcMysqlConnectorLibsOsgi.jar file VAPP-14.3.0 (192.168.0.30):/opt/CA/IdentityManager/ConnectorServer/jcs/resources/jdbc >Ĩ) Copy resulting fragment bundle file jdbcMysqlConnectorLibsOsgi.jar to the machine/location where you can select it from Connector Server Consoleĩ) Open Connector Server Console in your browser and logon using 'admin' user. 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.
Please provide the full path of a folder that contains this file:īuilding fragment bundle with following options: Ĭreated /opt/CA/IdentityManager/ConnectorServer/jcs/resources/jdbc/jdbcMysqlConnectorLibsOsgi.jar VAPP-14.3.0 (192.168.0.30):/opt/CA/IdentityManager/ConnectorServer/jcs/resources/jdbc > chmod a+x jdbc_mysql_post_install VAPP-14.3.0 (192.168.0.30):/opt/CA/IdentityManager/ConnectorServer/jcs/resources/jdbc > unzip jdbc_mysql_post_install.zip The following example is from vApp: VAPP-14.3.0 (192.168.0.30):~ > cd /opt/CA/IdentityManager/ConnectorServer/jcs/resources/jdbc/ Windows: C:\Program Files (x86)\CA\Identity Manager\Connector Server\jcs\resources\jdbcĥ) Extract the files from the above archiveĦ) Linux: change permissions of the jdbc_mysql_post_install script:
Linux: /opt/CA/IdentityManager/ConnectorServer/jcs/resources/jdbc
On vApp use 'config' user.ġ) Download the mysql-connector-java-5.0.8.tar.gz or mysql-connector-java-5.0.8.zip archive from the following location: (from 'Archives')Ģ) Extract mysql-connector-java-5.0.8-bin.jar from the downloaded archiveģ) Copy the mysql-connector-java-5.0.8-bin.jar file to the machine where IM Connector Server is installedĤ) Copy the archive attached to to this KB article to the following location on the machine where IM Connector Server is installed: In order to deploy MySQL JDBC driver in the IM Connector Server please follow the below steps.