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 22.214.171.124.0 and later
Oracle Database - Version 126.96.36.199 to 188.8.131.52 [Release 12.2]
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 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.
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