Setting up JDBC Connector under Local Agent (Magic xpi 4.14)

Uploading the Connector

Once the required JAR files are copied, upload the JDBC connector to the Local Agent. For complete instructions on uploading the connector, refer to the page

How to Add a Connector to Local Agent.

Copying the Driver JAR Files

After uploading the JDBC Local Agent connector, copy the JDBC driver files to the <LocalAgent Installation>\addons\JDBC\runtime\java\lib folder. Click here, to refer to the list of supported databases and their corresponding JAR files.

After copying the driver files, restart the Local Agent service if it is already running.

Using MS-SQL with Integrated Security

If you are using MS-SQL database with the Integrated Security option, then an additional step is required.

· Go to the Local Agent root folder and locate the connectors.xml file.

· Open this file in a text editor like Notepad.

· This file will have an XML root element with name Connector as below

<Connector name="JDBC">

· Under this element add a child element AdditionalJvmOptions. This element should point to the path of the DLL file mssql-jdbc_auth-8.4.1.x64.dll

The element will look like below:

<AdditionalJvmOptions>-Djava.library.path=[your path to the dll]</AdditionalJvmOptions>

· After adding the element save the file. The updated connectors.xml file with the updated element will look as below:

<Connector name="JDBC">

<Version>1.14</Version>

<ConnectorHome>some path</ConnectorHome>

<MaxLoadPerInstance>10</MaxLoadPerInstance>

<AdditionalJvmOptions>-Djava.library.path=C:/LocalAgent/addons/JDBC/runtime/java/lib</AdditionalJvmOptions>

</Connector>

(Since version: 4.13.3)

Related Topics

List of Supported Databases