My Oracle Support Banner

ArrayIndexOutOfBoundsException When Using CLOBs With JDBC OCI in Conjunction With UCP / FCF /FAN (Doc ID 2205092.1)

Last updated on OCTOBER 17, 2022

Applies to:

JDBC - Version and later
Universal Connection Pool - Version and later
Information in this document applies to any platform.


A Java application is configured using the JDBC OCI driver with UCP (Universal Connection Pool).

This is set up to work with FCF (Fast Connection Failover).

When the application uses CLOB datatypes, the application fails with the following error:.

Caused by: java.lang.ArrayIndexOutOfBoundsException
  at oracle.jdbc.driver.DynamicByteArray.put(
  at oracle.jdbc.driver.ByteArray.put(
  at oracle.jdbc.driver.T2CPreparedStatement.updateData(
  at oracle.jdbc.driver.T2CStatement.t2cDefineExecuteFetch(Native Method)
  at oracle.jdbc.driver.T2CPreparedStatement.doDefineExecuteFetch(
  at oracle.jdbc.driver.T2CPreparedStatement.executeForRows(

The issue can be reproduced at will by configuring the database service similar to the following:

srvctl config service -db <DB NAME> -service <SERVICE NAME>
Service name: <SERVICE NAME>
Server pool:
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: true
Global: false
Commit Outcome: true
Failover type: TRANSACTION
Failover method:
TAF failover retries:
TAF failover delay:
Connection Load Balancing Goal: SHORT
Runtime Load Balancing Goal: SERVICE_TIME
TAF policy specification: NONE
Pluggable database name:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: <INSTANCE NAME>
Available instances: <INSTANCE NAME>


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.