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.