2.11 Configuring Non-PostgreSQL User Application Databases

To modify the existing User Application database schema for non-PostgreSQL databases, complete the following steps:

  1. In a command prompt, navigate to the Identity Manager deploy directory and enter the following command:

    unzip IDMProv.war WEB-INF/classes/hibernate.cfg.xml

  2. Use a text editor to open the WEB-INF/classes/hibernate.cfg.xml file.

  3. In the hibernate.cfg.xml file, find the dialect property.

  4. Update the value of the dialect property for your database, as follows:

    • Microsoft SQL Server 2008 com.netiq.persist.SQLServerDialect

    • MySQL 5.1 com.netiq.persist.MySQL5InnoDBDialect

    • Oracle 11g com.netiq.persist.Oracle10gDialect

  5. Save and close the file.

  6. In the command prompt, enter the following command:

    zip -u0 IDMProv.war WEB-INF/classes/hibernate.cfg.xml

  7. Delete the WEB-INF directory and all its contents.