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:

Symptoms

A Java application is configured using the 12.1.0.2 JDBC OCI driver with 12.1.0.2 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(DynamicByteArray.java:939)
  at oracle.jdbc.driver.ByteArray.put(ByteArray.java:624)
  at oracle.jdbc.driver.T2CPreparedStatement.updateData(T2CPreparedStatement.java:3017)
  at oracle.jdbc.driver.T2CStatement.t2cDefineExecuteFetch(Native Method)
  at oracle.jdbc.driver.T2CPreparedStatement.doDefineExecuteFetch(T2CPreparedStatement.java:1910)
  at oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.java:1116)



STEPS
-----------------------
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
Edition:
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>

Cause

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