Spring Java DB Poller Generator

This generator enables the deployment of your OpenLegacy Hub project as a Database Polling service in a Java runtime environment. The result is a low-code Spring Boot project, which mirrors the contract of the generated Hub project. Each method within the Hub project is transformed into a DB Poller, responsible for periodically polling records from the data base and executing the associated logic.

Once deployed and running, to incorporate the latest changes from the Hub project—such as newly added methods, removed methods, or modifications to input/output fields—simply stop and restart the service.

Configuring the Database Connection

Users must first specify the database connection properties for the entire project and all associated methods.

• DB Type: Select from the list of supported database types:
  • Oracle
  • MSSQL
  • DB2 for IBM Z/OS
  • DB400 for AS/400
• DB URL: Specify the database URL.
  For example: jdbc:oracle:thin:@//oracle.myOracleServer.com:15221/myDB
• Username: Enter the database username.
• Password: Enter the corresponding password.

Configuring a Database Poller

Users can configure the behavior of each DB Poller by specifying the following parameters:

• Cron Expression: Defines the schedule for when the poller is executed.
• Poller Query: Specify the SQL query to be executed for retrieving records from the database.
• Row Processing Query: Configure an SQL statement to execute once a record from the result set has been processed. For example, you might update the status column with a "processed" value in the record table.
• End Processing Query: Similar to the Row Processing Query, this allows you to execute an SQL statement after all records in the initial result set have been processed. For instance, you might update all records with a "new" status to "processed" in the record table.