JDBC Adapter Limitations

• Supported Types
• Common to all processing
• Read Table
• Execute Select SQL
• Write table
• Execute Update SQL
• Execute Stored Procedure
• Main exceptions

Supported Types

Common to all processing

Specification Limits

Notes

• JDBC driver is required to be allocated correctly.


• To connect to multiple types of data sources, allocate all JDBC drivers required for each.
  Connecting to multiple types of databases is available, but loading the same class from multiple allocated JDBC driver is not. Thus, multiple JDBC version differs mainly cannot be allocated.

Read Table

Specification Limits

• According to DBMS, some features may not be available.


• If column names which need to be enclosed in double quotes are specified in the [Target] of [Schema definition], error will occur.
  However, this will not apply if all columns are selected.

Execute Select SQL

Specification Limits

• According to DBMS, some features may not be available.

Write table

Specification Limits

• According to DBMS, some features may not be available.


• If column names which need to be enclosed in double quotes are specified in the [Schema definition] of [Target] or as [Key], error will occur.


• Cannot get the key automatically.
  To update a row that matches the key value, select true in the key of schema definition.

Execute Update SQL

Specification Limits

• According to DBMS, some features may not be available.

Execute Stored Procedure

Specification Limits

• According to DBMS, some features may not be available.


• Parameters defined for stored procedures may not be retrieved correctly.

Main exceptions