Database Table Listener
The Database Table Adapter Allows Polling One Database Table
The Database Table Adapter (Listener) allows you to poll one database table for any information contained within that table. As with all the components of the eiConsole, the user is presented with a graphical interface with easy to configure screens.
To use this adapter in the Basic tab, you must specify the Polling interval (how often to poll the table), Table name and a Key field (what will determine which records to pick up out of the table). If you choose Use key field, then enter the column name for which you would like to filter the results.
In the Advanced tab – the dialogue lets you specify whether or not you want the interface to be invoked only on a trigger, if you want to keep the JDBC connection alive between transactions and whether or not each row returned from the query should result in the processing of a separate transaction.
In the Connection tab, you are to specify the JDBC drive, URL, User name and Password used to connect to the database.