• B2B ADAPTERS - LISTENERS
• SQL Database Listener
• Database Table Listener
• Directory Listener
• Document-Style Web Service Listener
• POP3 Listener
• FTP Listener
• SSH Listener
• SSL Listener
• Socket Listener
• HTTP Form / POST Listener
• HTTP POST Listener
• HTTP Post Command Line Listener
• JMS Listener
• MSMQ Listener
• Java Listener
• RMI Listener
• Web Service Listener
• WebSphere MQ Series Listener

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 to specify the JDBC drive, URL, User name and Password used to connect to the database.