...
- Download the driver JAR file of the respective RDBMS type.
- Copy the driver JAR file to the <
PRODUCT_HOME>/repository/components/lib/
directory. Include the folder path of the RDBMS driver JAR file within the Hive auxiliary JAR properties in the
<
PRODUCT_HOME>/repository/conf/advanced/hive-site.xmlxml
(on Linux) as shown below. Windows users must use the<BAM_HOME>/repository/conf/advanced/hive-site-win.xml
file instead.Code Block language xml <property> <name>hive.aux.jars.path</name> <value>file://${CARBON_HOME}/repository/components/plugins/apache-cassandra_1.1.3.wso2v2.jar, file://${CARBON_HOME}/repository/components/plugins/guava_12.0.0.wso2v1.jar, file://${CARBON_HOME}/repository/components/plugins/json_2.0.0.wso2v1.jar, file://${CARBON_HOME}/repository/components/plugins/commons-dbcp_1.4.0.wso2v1.jar, file://${CARBON_HOME}/repository/components/plugins/commons-pool_1.5.6.wso2v1.jar, file://${CARBON_HOME}/repository/components/lib/mysql-connector-java-5.1.23-bin.jar </value> </property>
- Restart the server.