JDBC

This library contains components to access any JDBC compliant database. It requires uploading the JDBC driver jar file to the flow.

Connection

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 Connection component.

Some database systems close the JDBC connection after a while of inactivity. You can specify a simple select statement to prevent this, and an Interval Timer component can be attached to execute it.

select 1 from <tablename>

CODE

Insert

Inserts a row into a database table by taking properties out of the incoming message and store them as the column values.

Update

Updates rows of a database table.

Delete

Deletes rows from a database table.

Query

Executes a SQL query and returns the result as a memory that you can further process:

Close

Closes the JDBC connection triggered by a message. This is usually done by connecting it to the Flow Stop component.