Adapter type: toolkit_jdbc_objlist_input. Set these properties for the JDBC Input adapter in the ESP Studio adapter properties dialog.
If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.
| Property Label | Description |
|---|---|
| Date Format |
Propterty ID: objectlistDateFormat Type: string (Advanced) Specify the format for parsing date values. |
| Timestamp Format |
Property ID: objectlistTimestampFormat Type: string (Advanced) Specify the format for parsing timestamp values. |
| DB Type |
Property ID: dbType Type: string (Required) Specify the database type to which you want to connect. Valid values: ORACLE:THIN, ORACLE:OCI8, SQLSERVER, ASE, DB2:APP, DB2:NET, DB2:UN2, HANA, KDB. |
| Host |
Property ID: host Type: string (Required) Specify the server name or IP address of the database to which you are connecting. |
| Port |
Property ID: port Type: int (Required) Specify the port for the database to which you are connecting. |
| DB Name |
Property ID: dbName Type: string (Optional) Specify the database name to which you want to connect. |
| Username |
Property ID: user Type: string (Optional) Specify the database username. |
| Password |
Property ID: password Type: string (Optional) Specify the database password. |
| SQL Query |
Property ID: query Type: string (Advanced) Specify the SQL query you want the adapter to execute. Set either the DB Table or SQL Query parameter. If you define both parameters, the adapter only uses the SQL Query parameter. |
| Table Name |
Property ID: table Type: string (Optional) Specify the name of the table in the target database from which you want the adapter to read. |
| Driver Class |
Property ID: dbDriver Type: string (Advanced) Specify the JDBC driver class to use. |
| DB Password Encrypted |
Property ID: encrypted Type: boolean (Advanced) Specify whether the password value is encrypted. If set to true, the password value is decrypted using the RSA Key Store, RSA Key Store Password, and RSA Key Store Alias parameters. |
| RSA Key Store |
Property ID: rsaKeyStore Type: filename (Advanced) File path for RSA key store. |
| RSA Key Store Password |
Property ID: rsaKeyStorePassword Type: string (Advanced) RSA key store password. |
| RSA Key Store Alias |
Property ID: rsaKeyStoreAlias Type: string (Advanced) An alias stored in the RSA key store. |
|
PropertySet |
Property ID: propertyset Type: string (Advanced) Specifies the name of the property set. Property sets are reusable sets of properties that are stored in the project configuration file. Using these sets allows you to move adapter configuration properties out of the CCL file and into the CCR file. If you specify the same properties in the project configuration file and the ATTACH ADAPTER statement, the values in the property set override the values defined in the ATTACH ADAPTER statement. No default value. |