首页 > 解决方案 > Process Oracle DB->column value change, in a Spring-boot-app-container

问题描述

Requirement (Simplified): Env: AWS

For all the rows in ORCL TBL_1 {
 if (COL_1 is "Y") {
     then process this (Biz-logic) in a
             Springboot-app (container);
     Set COL_1 = "N";
 }
}

Please recommend approaches to accomplish this in AWS Preferably without using ORCL table triggers

Some possible approaches:

Have a Lambda-service that polls the DB which then
A) calls a springboot rest-api for business logic processing   OR
B) posts a message on a Queue, which is processed by a springboot consumer 
C) Other approaches

Please let me know of recommended approaches in AWS.

标签: javaamazon-web-servicesspring-bootoracle11gtriggers

解决方案


推荐阅读