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

Supported types vary by DBM of the database to connect and JDBC driver.
JDBC adapter, data extraction/storage are done in common method of JDBC. Types that cannot be extracted/stored may exist according to the DBM of the database to connect and JDBC driver.

Please contact the vendor of the database being used about information on supported types.

Common to all processing

Specification Limits

None

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

Exception name	Cause	Actions
java.lang.ClassNotFoundException	JDBC driver was not found.	Please check your JDBC driver class name and location.
java.sql.SQLException	Exception in database processing.	Refer to specifications and manuals of the connected data source.
InvalidPropertyConfigurationException The required item of the client information property of the resource is not specified.	The required item of the client information property of the resource selected in [Destination] is not specified.	Specify the required item of the client information property of the resource.