My Oracle Support Banner

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:

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


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.


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

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