Repository Database Servers

Identity Manager supports the following repository database servers:

• IBM DB2 Universal Database for Linux, UNIX®, and Windows (Version 8.1, 8.2, 9.1 using a type 4 driver, 9.5 using a type 4 driver)

• Microsoft SQL Server 2005, 2008

• MySQL Enterprise^TM Server 5.0.60 SP1, 5.1.30

  ---

  Note –

  • If you use MySQL Enterprise Server 5.1.30 as your Identity Manager repository, you might need to change to your my.cnf file. Due to recent changes in MySQL's InnoDB code, the default binary logging format is now STATEMENT. Identity Manager uses a READ-COMMITTED transaction isolation level, so binary logging in STATEMENT mode produces an error similar to the following: (ID-20460).

    com.waveset.util.IOException: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'

    If you enable binary logging, set the mode to MIXED by adding the following line to your my.cnf file:

    binlog_format=mixed

    With this configuration change, you can use 5.1.30 as your repository without the binary logging exception. For more details, see MySQL bug #40360.

  • Identity Manager supports MySQL Enterprise Server 5.0.60 SP1 and 5.1.30 as a repository database in both development and production deployments. All other MySQL versions are only supported in a development deployment.

  • Identity Manager only supports SQL Server 2008 using SQL Server 2005 JDBC drivers. SQL Server 2008 does not work with SQL Server 2000 drivers, and the SQL Server 2008 JDBC drivers are currently not released.

  • Microsoft JDBC Version 1.2 drivers have Java assertions in the methods that connect to different database servers. These drivers assert Java when connecting to SQL Server 2000 if you enable Java assertions in the com.microsoft.sqlserver.jdbc package.

  ---

• Oracle Database 9i, 10g Release 1, 10g Release 2, and 11g

  ---

  Note –

  Oracle RAC (Real Application Cluster) is supported in a two-node active-passive configuration. That is, a configuration where the active_instance_count parameter is set to 1. Used in conjunction with connection failover for the JDBC^TM driver, this configuration provides failover capability for the repository. (Refer to the Oracle documentation for instructions about how to configure this database server in your environment)

  Oracle RAC is not currently supported in any other configuration.

  ---

  ---

  Caution –

  If you are using an Oracle repository, the Identity Manager 8.0 repository DDL uses data types that are not properly handled by older Oracle JDBC drivers. The JDBC drivers in ojdbc14.jar do not properly read all of the columns in the log table.

  You must upgrade to the Oracle JDBC drivers for JDK 5 drivers for Identity Manager to work properly.

  ---