Repository Database Servers

Oracle Waveset supports the following repository database servers:

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

  ---

  Note –

  IBM DB2 9.0 is no longer available for download.

  ---

• Microsoft SQL Server 2005, 2008

• MySQL Enterprise Server 5.0.60 SP1, 5.1.30

  ---

  Note –

  • If you use MySQL Enterprise Server 5.1.30 as your Oracle Waveset 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. Oracle Waveset 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.

  • Oracle Waveset 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.

  • Oracle Waveset only supports SQL Server 2008 using SQL Server 2005 JDBC (version 1.2 and 2.0) drivers. SQL Server 2008 does not work with SQL Server 2000 drivers.

  • 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 11g Release 1, and 11g Release 2

  ---

  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 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 Oracle Waveset 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 Oracle Waveset to work properly.

  ---