Page Comparison

The WSO2BAM_DATASOURCE, which is defined in the <PRODUCT<BAM_HOME>/repository/conf/bam-datasources.xml file is used to store the results of a Hive analysis job of WSO2 BAM, to a RDBMS.

To point WSO2 BAM to a RDBMS, you need to edit the default datasource configuration defined as shown below in the <BAM_HOME>/repository/conf/bam-datasources.xml file.

Info
Replace the `url`, `username`, `password` and `driverClassName` settings with your custom values and also the other values accordingly in the `<BAM_HOME>/repository/conf/bam-datasources.xml` file as shown in the below example.

...

Download the driver JAR file of the respective RDBMS type.
Copy the driver JAR file to the <PRODUCTBAM_HOME>/repository/components/lib/ directory.

Include the folder path of the RDBMS driver JAR file within the Hive auxiliary JAR properties in the the <PRODUCT BAM_HOME>/repository/conf/advanced/hive-site.xml xml (on Linux) as shown below. Windows users must use the <BAM_HOME>/repository/conf/advanced/or the hive-site-win.xml file instead.(on Windows).

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.

Versions Compared

Old Version 4

New Version Current

Key