Oracle 12c Adapter Limitations

Supported Types

This adapter supports types as follows.

Type nameSupportRemarks
CHARLimited 
NCHARLimited 
VARCHAR2Yes 
NVARCHAR2Limited 
LONGYes 
NUMBERLimited 
FLOATLimited 
DATELimited 
TIMESTAMPLimited 
TIMESTAMP WITH TIME ZONELimitedTreated as String data.
RAWYes 
LONG RAWYes 
BLOBYes 
CLOBYes 
NCLOBYes 

Common to all processing

Specification Limits

Read Table

Specification Limits

Execute Select SQL

Specification Limits

Write table

Specification Limits

Execute Update SQL

Specification Limits

Execute Stored Procedure

Specification Limits

Write by Loader

Specification Limits

Main exceptions

Exception name Cause Actions
java.sql.SQLException ORA-01017: Username/password is invalid. Logon denied. Connected to the database but cannot login. Check [User name] and [Password].
java.sql.SQLRecoverableException ORA-12514, TNS:listener does not currently know of service requested in connect descriptor SID is wrong. Check the [SID].
The Network Adapter could not establish the connection Cannot connect to the database. Check the [Hostname] and [Port number].
java.sql.SQLSyntaxErrorException ORA-00942: table or view does not exist. table or view does not exist. Please check that the specified table or view exists.
ORA-00933: SQL command did not end properly. Check whether the name of the specified table or view is enclosed with quotation marks. Check whether the name of the specified table or view is enclosed with quotation marks.
oracle.jdbc.xa.OracleXAException Multiple XA Global resources all referring the same database are possibly used in a transaction enabled script. Do not use more than one global resource among the multiple operations which are all performed referring the same Oracle database to which an XA connection has been opened.