4.11 Testing the Database Object Installation

Test scripts for each database are located in the following directories:

Table 4-4 Location of Database Scripts

Database

Test SQL Scripts Location

IBM DB2 Universal Database

UNIX/Linux: install-dir/lib/dirxml/rules/jdbc/sql/db2_udb/test

Windows: install-dir\DirXMLUtilities\jdbc\sql\db2_udb\test

Informix Dynamic Server

UNIX/Linux: The test scripts are located in the following directories:

  • install-dir/lib/dirxml/rules/jdbc/sql/informix_ids/test/log

  • install-dir/lib/dirxml/rules/jdbc/sql/informix_ids/test/no_log

Windows: The test scripts are located in the following directories:

  • install-dir\DirXMLUtilities\jdbc\sql\informix_ids\log\test

  • install-dir\DirXMLUtilities\jdbc\sql\informix_ids\no_log\test

Informix: Informix ANSI test scripts are located in the log subdirectory.

Microsoft SQL Server

UNIX/Linux: The test scripts are located in the following directories:

  • install-dir/lib/dirxml/rules/jdbc/sql/mssql/3or4/test

  • install-dir/lib/dirxml/rules/jdbc/sql/mssql/5/test

Windows: install-dir\DirXMLUtilities\jdbc\sql\mssql\test

MySQL

UNIX/Linux: The test scripts are located in the following directories:

  • install-dir/lib/dirxml/rules/jdbc/sql/mysql/3or4/test

  • install-dir/lib/dirxml/rules/jdbc/sql/mysql/5/test

Windows: install-dir\DirXMLUtilities\jdbc\sql\mysql\test

Oracle

UNIX/Linux: install-dir/lib/dirxml/rules/jdbc/sql/oracle/test

Windows: install-dir\DirXMLUtilities\jdbc\sql\oracle\test

PostgreSQL

UNIX/Linux: install-dir /lib/dirxml/rules/jdbc/sql/postgres/test

Windows: install-dir \DirXMLUtilities\jdbc\sql\postgres\test

Sybase Adaptive Server Enterprise

UNIX/Linux: install-dir /lib/dirxml/rules/jdbc/sql/sybase_ase/test

Windows: install-dir \DirXMLUtilities\jdbc\sql\sybase_ase\test

You should try the test scripts before starting the sample driver.

If you encounter issues while testing, see the following sections: