Table with Nchar/NVarchar Not Selectable Via Jdbc Thin Driver 11.2 Over Gateway (Doc ID 1263500.1)

Last updated on MARCH 08, 2017

Applies to:

JDBC - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
This problem can occur on any platform.

Symptoms


Table with NVARCHAR/NCHAR columns cannot be retrieved from foreign databases using JDBC and Oracle Gateway.

Using the JDBC 11.1.X thin driver results in:
Exception: Bigger type length than Maximum

Using the JDBC 11.2.X thin driver results in:
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space

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