Errors when you use Oracle as the database

Symptom

java.lang.ArrayIndexOutOfBoundsException error reported when you use an Oracle database.

Cause

There is a problem with the Oracle jdbc drivers.

Solution

Choose the appropriate option to resolve the problem.

Use the Oracle 10.2g JDBC 4 drivers. The drivers work with oracle 9, 10 and 11.
If you are using the Oracle 11g drivers, manually edit the trc.properties file and set the following property oracle.increment.keys.off=1.
Note: Restart the server service.