Configuring Oracle

To configure and run Oracle as your RDBMS, you must do the following.

1. Open the <MB_HOME>/repository/conf/datasources/master-datasources.xml file. This is where datasources are configured to point to the databases used by the Message Broker. This file consists of commented out configurations for datasources. The datasource configuration for Oracle is among these. The changes made to this file must be done in both broker nodes.

2. Uncomment or add the following configuration into the master-datasources.xml file. Update the JDBC URL to correctly point to your database and enter the username and password for an Oracle database user with the proper permissions.
   

   <datasource>
          <name>ORACLE_DATA_SOURCE</name>
          <jndiConfig>
              <name>WSO2MBStoreDB</name>
          </jndiConfig>
          <definition type="RDBMS">
              <configuration>
                  <driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName>
                  <url>jdbc:oracle:thin:@localhost:1521/orcl</url>
                  <maxActive>100</maxActive>
                  <maxWait>60000</maxWait>
                  <minIdle>5</minIdle>
                  <testOnBorrow>true</testOnBorrow>
                  <validationQuery>SELECT 1</validationQuery>
                  <validationInterval>30000</validationInterval>
                  <username>scott</username>
                  <password>tiger</password>
              </configuration>
          </definition>
   </datasource>

    

3. Open the <MB_HOME>/repository/conf/broker.xml file. This is the root configuration file of Message Broker. The changes made to this file must be done in all the WSO2 Message Broker nodes.

4. In the broker.xml file we need to use the Oracle message store and Andes context store. To do this, uncomment or add the following configuration.
   

   ...
   <messageStore class="org.wso2.andes.store.rdbms.RDBMSMessageStoreImpl">
              <property name="dataSource">WSO2MBStoreDB</property>
   </messageStore>
   
   <contextStore class="org.wso2.andes.store.rdbms.RDBMSAndesContextStoreImpl">
              <property name="dataSource">WSO2MBStoreDB</property>
   </contextStore>