This library contains components to access any JDBC compliant database. It requires to upload the JDBC driver jar file to the flow.
Creates a new JDBC connection and provides it as a reference. The connection is either created by a message trigger or during flow init.
This component requires that you upload the JDBC driver as a
jar file by clicking on the
Attach button at the top:
Then drop the
jar file into the upload area:
The upload needs to be confirmed in the property dialog of the
Some database systems close the JDBC connection after a while of inactivity. To prevent this, a simple select statement like
select 1 from <tablename>
can be specified and a
Interval Timer component can be attached to execute it.
Inserts a row into a database table by taking properties out of the incoming message and store them as column value.
Updates rows of a database table.
Deletes rows from a database table.
Executes a SQL query and returns the result as a memory that can be further processed:
Closes the JDBC connection triggered by a message. This is usually done by connecting it to the
Flow Stop component. It
can also be done on any other event by connecting it to the respective component: