Other Information about Oracle Database and Drivers

A few helpful points about Oracle database and drivers.

  • Use ojdbc7.jar drivers file. You can download this file from the following location: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html
  • Maximum length for an Oracle table name or column name is 30 characters.
  • When OCI client is configured with 32-bit client, Oracle might display "No data found" error. To resolve the error, reduce the recovery batch size using the be.engine.cluster.recovery.batchsize property.

    For example, if you are getting "No data found" error when the batch size is 10000, a batch size of 5000 might resolve the error, that is,

    <property name="be.engine.cluster.recovery.batchsize" value="5000"/>