Oracle 11g Adapter Limitations

Sales and inquiry support for Oracle 11g adapter has ended.

Supported Types

This adapter supports types as follows.

Type nameSupportRemarks
CHARLimited 
NCHARYes 
VARCHAR2Yes 
NVARCHAR2Yes 
LONGYes 
NUMBERLimited 
FLOATLimited 
DATELimited 
TIMESTAMPLimited 
TIMESTAMPTZLimitedTreated 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 I/O exception: The Network Adapter could not establish the connection. Cannot connect to the database. Check the [Hostname] and [Port number].
Listener refused the connection with the following error: ORA-12505 SID is wrong. Check the [SID].
ORA-01017: invalid username/password; Connected to the database but cannot login. Check [User name] or [Password].
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.