My Oracle Support Banner

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

Last updated on AUGUST 07, 2020

Applies to:

JDBC - Version 12.2.0.0.0 and later
Oracle Database - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

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 make a query to target DB directly (not using DBLink).
- 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

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
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.