Thunderbus DB Agent Adapter Limitations

Supported Types
Common to all processing
Read Table
Execute Select SQL
Main exceptions

Supported Types

Thunderbus DB Agent adapter can only retrieve values in string, number, date and time. Values in other types are retrieved as null. Types to be supported differ depending on the database to be connected to Thunderbus DB Agent and the JDBC driver to be used.

Common to all processing

Specification Limits

Default value of [Fetch size] is "500".

Notes

Thunderbus Agent and the target database must be connected.
Thunderbus Server and Thunderbus Agent must be connected.
DataSpiderServer and Thunderbus Server must be connected.

Read Table

Specification Limits

According to DBMS, some features may not be available.

Execute Select SQL

Specification Limits

According to DBMS, some features may not be available.

Main exceptions

Message	Cause	Actions
The host is unknown.	Specified host is not found.	Check the [Host name] in global resource.
The port number is not correct.	The specified host is recognized, but the port number is not correct.	Check the [Port number] in global resource
The agent does not exist.	Agent is not found in the specified agent ID.	Check [Agent ID] in global resource.
The setting does not exist.	The specified setting name is not found.	Check [Setting name] in global resource.
The user name or the password is not correct.	User name or password is wrong.	Check [User name] or [Password] in global resource.