My Oracle Support Banner

java.sql.SQLException: Protocol violation: [ 6, 7, 5, ] When Column Size Exceeds 1300 (Doc ID 2088417.1)

Last updated on MAY 25, 2023

Applies to:

JDBC - Version 12.1.0.2.0 to 12.1.0.2.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

JDBC 12.1.0.2 application fails with Protocol Violation exception when the SQL query column exceeds 1300 columns.

Changes

To replicate this issue 12.1.0.2 JDBC driver should be patched for <Bug 20222015> JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION: 128 WITH JDBC DRIVER.

At the database level one has to set ALTER system SET "_FIX_CONTROL"='17376322:OFF' scope=both, or should have <Patch 20315685> applied.

Cause

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
Symptoms
Changes
Cause
Solution
References


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