JDBC Input and Output Adapter

The JDBC Input adapter receives data from tables in a database and inputs it into Event Stream Processor. The JDBC Output adapter sends data from Event Stream Processor to a database table.

• JDBC Input Adapter Configuration
  Configure the JDBC Input adapter by specifying values for the ESP connector, formatter, and transporter modules in the adapter configuration file.
• JDBC Output Adapter Configuration
  Configure the JDBC Output adapter by specifying values for the ESP connector, formatter, and transporter modules in the adapter configuration file.
• Adapter Controller Parameters
  The Adapter Controller port listens for commands. The controller.xml file is located in %ESP_HOME%/adapters/framework/config directory. This file is shared among all the adapter within the %ESP_HOME%/adapters/framework/instances directory.
• Logging
  The JDBC Input and Output adapter use the Apache log4j API to log errors, warnings, and information and debugging messages. A sample log4j.properties file containing the logging configuration is located in the %ESP_HOME%\adapters\framework\config directory.
• Starting the JDBC Adapter
  To start the JDBC adapter from the command line, start Event Stream Processor and execute the start command.
• Stopping the JDBC Adapter
  To stop the JDBC adapter from the command line, execute the stop command.