Toolkit com.ibm.streamsx.jdbc 1.6.0
Specialized toolkits - release 4.3.1.0-prod20190605 > com.ibm.streamsx.jdbc 1.6.0
General Information
The JDBCRun operator runs a user-defined SQL statement that is based on an input tuple.
The statement is run once for each input tuple received. Result sets that are produced by the statement are emitted as output stream tuples.
The JDBCRun operator is commonly used to update, merge, and delete database management system (DBMS) records.
This operator is also used to retrieve records, create and drop tables, and to call stored procedures.
it is strongly recommended before you begin with the implementation of a SPL application on JDBCRun operator, read the documentation of database vendors.
Every database vendor delivers one or more JAR libraries as jdbc driver. Please check the version of your database server and the version of JDBC driver libraries.
Behavior in a consistent region:
The JDBCRun operator can be used in a consistent region.
It cannot be the start operator of a consistent region. In a consistent region, the configured value of the transactionSize is ignored. Instead, database commits are performed (when supported by the DBMS) on consistent region checkpoints, and database rollbacks are performed on consistent region resets.
On drain: If there are any pending statements, they are run. If the statement generates a result set and the operator has an output port, tuples are generated from the results and submitted to the output port. If the operator has an error output port and the statement generates any errors, tuples are generated from the errors and submitted to the error output port.
On checkpoint: A database commit is performed.
On reset: Any pending statements are discarded. A rollback is performed.
The JDBCRun operator support optional type feature.
It supports also phoenix jdbc to connect to the HBASE database.
The JDBCRun operator has been improved in version 1.4.0 with a new parameter checkConnection. This optional parameter specifies whether a checkConnection thread should be start. It checks periodically the status of JDBC connection. The JDBCRun sends in case of any failure a SqlCode and a message to SPL application.
- Version
- 1.6.0
- Required Product Version
- 4.2.0.0