Oracle 10g Adapter Limitations

Sales and support for Oracle 10g Adapter are finished.

Supported Types

The types supported in this adapter are the following.

Displaying table list
- Tables that belong to the schema of the user specified in [User name] in the global resource are displayed.
- Synonym is not displayed.

NUMBER, FLOAT
- When the Precision of a query result is 0, the data is handled as BigDecimal. For example, even if Precision is set to the column specified in SUM function, 0 will be returned as a result, so the result of SUM function will be handled as BigDecimal.
SQL statement with functions
- SQL statement with SQL functions can be executed.
- Though the SQL statement with user-defined functions can be executed, the value of OUT parameter defined in the functions cannot be received.

CHAR
- When updating, if the column in which you checked [Schema definition/Key] is CHAR type, the key value of the input data has to be padded in the same size.
LOB
- When inserting/updating LOB type data with this adapter, data might be broken due to Oracle restrictions.
When the table name is enclosed with quotation marks, it is case-sensitive.

CHAR
- When a CHAR type column is specified in the WHERE clause of an UPDATE statement, and getting the value of the column with SQL parameter, the key value of the input data has to be padded in the same size.
LOB
- When inserting/updating LOB type data with this adapter, data might be broken due to Oracle restrictions.
SQL statement with functions
- SQL statement with SQL functions can be executed.
- Though the SQL statement with user-defined functions can be executed, the value of OUT parameter defined in the functions cannot be received.

A procedure of a schema that is different from the schema of the user specified in [User name] in the global resource cannot be used.

DATE
- It has to be formatted in the standard format of Oracle as [YYYY-MM-DD] beforehand.
TIMESTAMP
- It has to be formatted in the standard format of Oracle as [YYYY-MM-DD Hh24:MI:SS] beforehand.
When the table name is enclosed with quotation marks, it is case-sensitive.

Exception name		Cause	Solution
java.sql.SQLException	I/O Error: The Network Adapter could not establish the connection	Unable to connect to the database.	Check [Host name] or [Port number] of the global resource.
	Listener refused the connection with the following error: ORA-12505	The SID is invalid.	Check [SID] or [URL] of the global resource.
	ORA-01017: invalid username/password;	The user name or the password is incorrect.	Check [User name] or [Password] of the global resource.
	ORA-00942: table or view does not exist	The table or the view does not exist.	Specify the table or the view that exists in [Table name].
	ORA-00933: SQL command not properly ended	The table or view name might not be enclosed with quotation marks.	Check whether the table or view name specified in [Table name] is enclosed with quotation marks.
oracle.jdbc.xa.OracleXAException		Multiple XA global resources might be used, which refers to the same database, in a script of which transaction is enabled.	When referring to the same database in multiple processes with Oracle XA connection, use the same global resource.