Previous Topic: Deploying and Configuring State ManagerNext Topic: Copying the JDBC Drivers


Running Database Scripts

Adapter is shipped with scripts that are required to create necessary tables in the database. To create the required database tables:

  1. Navigate to the following location:

    For MS SQL Server:

    state_manager_installation_dir/dbscripts/mssql

    For MySQL:

    state_manager_installation_dir/dbscripts/mysql

    For Oracle:

    state_manager_installation_dir/dbscripts/oracle

  2. Run the arcot-db-config-for-adapter-statemanager-2.2.9.sql file on the database.

    This command creates the ARTSTOKENS table in your database. This table contains the token information, such as the token ID, time when the token was issued and last used, and the timestamp of communication with the RiskMinder Server.