Installation

The bin folder of a windows installation contains the following native dynamic link libraries and executable files:

The bin folder of a Linux installation contains the following script files:

If a case insensitive search is required, it must be guaranteed that the affected column has a case insensitive collation.

Look at the specific chapters for your database below.

MySQL is an Open Source database. For more information go to www.mysql.com. You can download the latest mysql JDBC driver (Connector/J) from www.mysql.com.

You have to use at least MySQL Version 5.1 and the database engine InnoDb.

The following table explains the fields you have to configure on System Database tab in the Axon.ivy Engine Configuration program:

The following table explains the additional creation parameters you have to configure on System Database tab in the Axon.ivy Engine Configuration program, if you want to create a new system database on a MySQL database system:

The following table shows information about the JDBC driver that Axon.ivy Engine uses to connect to MySQL database systems:

If you want to check the collation of a specified column you can use the following query:

SELECT character_set_name, collation_name FROM information_schema.columns WHERE table_schema = "AXON_IVY_SYSTEM_DATABASE" AND table_name = "iwa_case" AND column_name = "name"

If you need to change the collation look at the official MySQL reference for all supported character sets and collations. The simplest way is to use a case insensitive collation of the current character set. The following code will apply a new collation.

ALTER TABLE iwa_case MODIFY name VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci;

You can find more information about modifying the column in the MySQL reference.

If the Axon.ivy Engine Configuration creates a new database, the following parameters will be automatically applied. If you want to use different charset or collation create an empty database manually with your configuration and then use the Axon.ivy Engine Configuration to create the tables, views and indexes in that database.

Oracle database is a database management system from the Oracle Corporation. For more information go to www.oracle.com

You have to use at least Oracle 10g.

The following table explains the fields you have to configure on the System Database tab in the Axon.ivy Engine Configuration program:

ch.ivyteam.ivy.persistence.PersistencyException: java.sql.SQLException: 
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

Before you can create the system database tables on a Oracle Database you have to do the following steps:

The following table explains the additional creation parameters you have to configure on the System Database tab in the Axon.ivy Engine Configuration program if you want to create a new system database on Oracle database system:

The following table shows information about the JDBC driver Axon.ivy Engine uses to connect to Oracle database systems:

The character set is defined with the CREATE DATABASE statement which is part of the customer configuration (look at creation). We recommend to use AL32UTF8 (unicode) or at least WE8ISO8859P1, which supports Western European languages. By the use of AL32UTF8 all text fields like VARCHAR or CHAR supports unicode characters.

Oracle databases works with session parameters for sorting and comparing data. The concept is called Linguistic Sorting and Matching. In the Oracle Database Manager you can configure the initialization parameters. For case insensitive sorting and comparing you can set NLS_SORT to AMERICAN (select an appropriate language) and NLS_COMP to LINGUISTIC. At the moment, you can't override the NLS_LANGUAGE and NLS_TERRITORY which is set to AMERICAN.

Microsoft SQL Server is a database system from Microsoft. For more information go to www.microsoft.com. We support two different JDBC Drivers for Microsoft SQL Server. First, the official JDBC Driver from Microsoft that provides support for the latest SQL Server features like high availability with multi subnet fail-over. Second, the matured and long-time used jTDS JDBC Driver.

You have to use at least Microsoft SQL Server 2005.

The following table explains the fields you have to configure on the System Database tab in the Axon.ivy Engine Configuration program:

The following table explains the additional creation parameters you have to configure on the System Database tab in the Axon.ivy Engine Configuration program if you want to create a new system database on Microsoft SQL Server database system:

The following table shows information about the JDBC driver Axon.ivy Engine uses to connect to Microsoft SQL Server database systems:

MSSQL Server supports different (one byte-) character sets with the COLLATE parameter. If you need a unicode character set you have to modify the text fields to type NVARCHAR, NCHAR or NTEXT. First create a new column of this type, copy data from the old column, drop the old column and rename the new column to the old column.

If you want to check the collation of a specific column you can use the following query:

SELECT columns.collation_name FROM information_schema.columns WHERE table_name = 'iwa_case' AND column_name = 'name';

Probably you need to change the collation. Look at the official MSSQL reference for all supported character sets and collations. The simplest way is to use a case insensitive collation of the current character set. The following code will apply a new collation.

ALTER TABLE iwa_case ALTER COLUMN name VARCHAR(200) COLLATE Latin1_General_CS_AI;

If the Axon.ivy Engine Configuration creates a new database, the following parameters will be automatically applied. If you want to use different collation create an empty database manually with your configuration and then use the Axon.ivy Engine Configuration to create the tables, views and indexes in that database.

IBM calls its database products DB2. It is important to understand that DB2 for z/OS is not the same as DB2 for LUW (Linux, Unix, Windows) and not the same as DB2 for iSeries. This chapter describes DB2 for iSeries (formally AS400). For more information go to www.ibm.com.

You have to use at least DB2 for iSeries V6R1M0.

The following table explains the fields you have to configure on the System Database tab in the Axon.ivy Engine Configuration program:

The following table explains the additional creation parameters you have to configure on the System Database tab in the Axon.ivy Engine Configuration program if you want to create a new system database on a DB2 for iSeries database system:

The following table shows information about the JDBC driver used by Axon.ivy Engine to connect to DB2 database systems:

DB2 for iSeries (AS400) uses CCSID (coded character set identifier) for encoding definitions which can be configured on system level. To influence the sorting and comparing you can configure the additional connection properties in the engine config ui. The supported properties are listed in the IBM Toolbox for Java JDBC properties. Especially the sort properties sort, sort language and sort weight are interesting for case insensitive searches.

PostgreSQL is an Open Source database. For more information go to www.postgresql.org. You can download the latest PostgreSQL JDBC driver from jdbc.postgresql.org

You have to use at least PostgreSQL 8.3.

The following table explains the fields you have to configure on the System Database tab in the Axon.ivy Engine Configuration program:

The following table explains the additional creation parameters you have to configure on the System Database tab in the Axon.ivy Engine Configuration program if you want to create a new system database on PostgreSQL database system:

The following table shows information about the JDBC driver Axon.ivy Engine uses to connect to PostgreSQL database systems:

The character set can only be defined by the CREATE DATABASE statement.

If you want to know the collation of a column you can use the following query:

SELECT character_set_name, collation_name FROM information_schema.columns WHERE table_name = 'iwa_case' and column_name = 'name';

Maybe there is no collation defined, so PostgreSQL won't show you any value. Ask the DBMS for the default value:

SELECT datname, datcollate FROM pg_database;

Propably you need to change the collation. Look at the official PostgreSQL reference for all supported character sets and collations. Look also at Collation Support and ALTER TABLE for more information about collations in PostgreSQL.

ALTER TABLE iwa_case ALTER COLUMN name varchar(200) COLLATE "de_DE.utf8";

If the Axon.ivy Engine Configuration creates a new database, the following parameters will be automatically applied. If you want to use different charset or collation create an empty database manually with your configuration and then use the Axon.ivy Engine Configuration to create the tables, views and indexes in that database.