A JDBC Table is a data construct that enables a StreamBase EventFlow to share data from an external, persistent JDBC data source. When connected to a JDBC Table (instead of to a Query Table), a Query operator can manipulate the JDBC data together with tuples from the application's input streams. JDBC Tables can be associated with multiple Query operators, but each Query operator can be associated only with one JDBC Table.
This topic describes the configuration options for each tab of the JDBC Table's
Properties view. The procedures assume that you have performed the earlier steps in
Using JDBC Data Sources: declaring a
JDBC data source project's sbd.sbconf configuration file,
and adding a JDBC Table data construct to your EventFlow.
Name: Every application component must have a unique name. Use this field to specify or change the component's name. The name must contain only alphabetic characters, numbers, and underscores, and no hyphens or other special characters. The first character must be alphabetic or an underscore.
Description: Optionally, enter a description to briefly describe the component's purpose and function. In the EventFlow canvas, you can see the description by pressing Ctrl while the component's tooltip is displayed.
In the Data Source tab, choose the JDBC data source you want to use from the dropdown
list. The list contains the name of every JDBC data source declared in the
data-sources section of the current project's
.sbconf file.
-
Defining a StreamBase Server Configuration in the Administration Guide
-
StreamSQL: APPLY Statement