Protocol Violation: [ 6, 7, 5, ] when the query exceeds 1300 columns (Doc ID 2086201.1)

Last updated on MARCH 08, 2017

Applies to:

JDBC - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

A JDBC application fails with Protocol Violation exception when the SQL query select list exceeds 1300 columns. 

To replicate this issue the 12.1.0.2 JDBC driver should be patched for Bug 20222015 which resolves the JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION: 128


At the database level one has to either set the following parameters

ALTER system SET "_FIX_CONTROL"='17376322:OFF' scope=both
or
should have the patch for bug 20315685

 

Sample stack:

  

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms