JDBC Output Transporter Module Configuration
The JDBC Output transporter obtains data from the previous module specified in the adapter configuration file and writes it into a database table using JDBC. Set values for this transporter in the adapter configuration file.
| XML Element | Description |
|---|---|
| Host |
Type: string (Required) Specify the server name of the database to which you are connecting the adapter. |
| Port |
Type: integer (Required) Specify the port number for connecting to the database server. |
| Username |
Type: string (Required) Specify the username you are using to connect to the database server. |
| Password |
Type: string (Required) Specify the password for connecting to the database server. Includes an "encrypted" attribute indicating whether the password value is encrypted. If set to true, the password value is decrypted using the RSAKeyStore, RSAKeyStorePassword, and RSAKeyStoreAlias elements. |
| DbName |
Type: string (Required) Specify the database name of the database to which you want to connect. |
| DBType |
Type: string (Required) Specify the database type of the database to which you want to connect. |
| DbDriver |
Type: string (Required) Specify the JDBC driver class for your JDBC driver. |
| Table |
Type: string (Optional) Specify the name of the table in the target database to which you want the adapter to write. |
| SqlInsert |
Type: string (Optional) Specify the SQL clause you want the adapter to execute. No default value. Set either the Table or SqlInsert element. If you define both elements, the adapter uses only the SqlInsert element. |
| RSAKeyStore |
Type: string (Dependent required) Specify the location of an RSA keystore file which contains the key used to encrypt or decrypt the password set in the Password element. This element is required if the password value is encrypted. |
| RSAKeyStorePassword |
Type: string (Dependent required) Stores the password to the RSA keystore file specified in the RSAKeyStore element. This element is required if the password value is encrypted. |
| RSAKeyStoreAlias |
Type: string (Dependent required) Specifies the keystore alias. This element is required if the password value is encrypted. |
| BatchSize |
Type: integer (Optional) If the adapter is running in GD (guaranteed delivery) mode, specify the number of message rows after which the adapter issues a commit command to the external data source and a GD commit to the stream to which the adapter is attached. If the adapter is running without GD, specify the number of message rows after which the adapter issues a commit command to the external data source. The default value is 1. Increasing this value improves performance at the expense of latency. It also increases memory consumption in the ESP Server because the uncommitted rows need to be preserved for redelivery in case of failure. If running this adapter in GD mode, set either this or the BatchPeriod property to greater than 0. If neither property is set to greater than 0, a warning is sent and this property is set to 1. |
| BatchPeriod |
Type: integer (Optional) If the adapter is running in GD mode, specify the number of seconds after which the adapter issues a commit command to the external data source and a GD commit to the stream to which the adapter is attached. If the adapter is running without GD mode, specify the number of seconds after which the adapter issues a commit command to the external data source. The default value is 0.The default value is 0. Increasing this value improves performance at the expense of latency. It also increases memory consumption in the ESP Server because the uncommitted rows need to be preserved for redelivery in case of failure. If running the adapter in GD mode, set either this or the BatchSize property to greater than 0. If not, a warning is sent and this property is set to 1. |