Description:
How to configure backingstore (SharedAll) for RMS server.

How to configure backingstore (SharedAll) for RMS server.

All Supported Platforms

1). Create SQL scripts to build the backingstore tables.

 

be-jdbcdeploy [-p property file] [-o schema output file] [-c CDDpath] EARfile

Example:  %BE_HOME%/bin/be-jdbcdeploy -p %BE_HOME%/bin/be-jdbcdeploy.tra -o sqlout -c c:\temp\project.cdd c:\temp\project.ear
 

2). Create backingstore tables.

 

- execute appropriate sql scipt from %BE_HOME%/bin folder to build the general tables

3). Execute SQL script created in Step 1 to create the project related tables.

4). Configure SharedAll on RMS, update RMS.cdd file.

<backing-store>
   <persistence-option>Shared All</persistence-option>
...
   <primary-connection>
         <uri>/Transports/TR_BackingStore_JDBCConnection.sharedjdbc</uri>
        

   <property-group comment="" name="BackingStore">
        <property name="tibco.clientVar.Webstudio/DB/driverName" type="string" value="oracle.jdbc.OracleDriver"/>
        <property name="tibco.clientVar.Webstudio/DB/url" type="string" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
        <property name="tibco.clientVar.Webstudio/DB/maxConnections" type="integer" value="5"/>
        <property name="tibco.clientVar.Webstudio/DB/userName" type="string" value="WS_USER"/>
        <property name="tibco.clientVar.Webstudio/DB/password" type="string" value="WS_USER"/>
        <property name="tibco.clientVar.Webstudio/DB/timeout" type="integer" value="0"/>
    </property-group>