ODBC Adapter Limitations

Supported Types

Supported types vary depending on the destination database and ODBC driver.
This adapter reads and writes data based on the general method of ODBC. Depending on the used ODBC driver or the connected database, there are types for which read/write cannot be performed.
For more details on supported types, contact the database vendor.

Limitations Common to All Operations

Specification Limits

Notes

Read Table

Specification Limits

Execute Select SQL

Specification Limits

Write Table

Specification Limits

Execute Update SQL

Specification Limits

Major Exceptions

Exception name Cause Solution
java.sql.SQLException Exception during database processing. Refer to the specifications or manual of the database destination.