Connector for JDBC Database – Streaming

The JDBC Database -Streaming connector allows subscription to a set of data, upserting existing received values in a JDBC SQL Database, by running micro batched queries.

The database must have the appropriate JDBC driver .jar files and JNDI connections.

Refer to the Database section in the Panopticon Real Time Installation and Troubleshooting Guide for more information.

Steps:

 

1.     You can either select:

·         JNDI Name

 

NOTE	The JNDI resource name needs to be on the form: java:/comp/env/jdbc/[resourcename]

 

·         URL

Enter the URL specific to the database’s JDBC driver, the Driver Class Name specific to the driver, and the User Id and Password.

Check the Show Characters box to display the entered characters.

2.     Enter the Timeout or the length of time to wait for the server response. Default is 60.

3.     Enter the Query, which can contain parameters in a similar manner to the database connector.

4.     Select whether the parameters should be automatically enclosed in quotes, by checking the Enclose parameters in quotes box.

5.     Click  to retrieve the schema of the configured subscription.

This also populates the Id Column with the set of columns, of arbitrary type, that can be concatenated to form a unique row identifier.

6.     Date/Time values of output data and Date/Time inputs, where supported, is by default unchanged.

You can opt to define the Show in Timezone and Source Timezone settings.

7.     For this section:

Refer to Define Real-Time Settings for more information.