Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Download the driver JAR file of the respective RDBMS type.
  2.  Copy the driver JAR file to the <PRODUCT_HOME>/repository/components/lib/ directory. 
  3. 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
    languagexml
    <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>
  4. Restart the server.