JDBC Throws Protocol Violation When Running a Query to DBLink Having Different Charactersets (Doc ID 2698430.1)

Last updated on MARCH 06, 2022

Applies to:

Symptoms

JDBC Thin Driver throws the Protocol Violation error when executing a specific query;

(* Numbers and stacks reported with the Exception are different up to environments and SQL queries)

This particular issue has the following characteristics;

- Two or more Database (DB) instances are linked by DBLink and charactersets are different between source DB and target DB.
- Not depended on JDBC version. The issue occurs higher with JDBC versions also.
- May not occur if changing JDBC Fetch size.
- May not occur if making a small change to SQL query, for example Columns, Order by, Hint and so on.

In one case, the issue started to occur in a DB upgraded from version 11g to 12c. In other case, the issue occurs in a newly installed DB.

Cause

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