java - 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.
解决方案
推荐阅读
- amazon-web-services - 创建和启动定时 EC2 脚本
- c# - 在通过级联加载的 selectchange 上将项目添加到 c# 列表
- javascript - 动画汉堡导航
- python - 程序在Pycharm和IDLE中运行,直接打开就崩溃
- java - 我们可以在 jdbcTemplate 更新中使用 IN 子句吗?
- javafx - 在另一个 JavaFX 窗口中关闭阶段时采取措施
- python - Raspberry GPIO:是否可以猜测连接到 gpio 引脚的设备类型?
- python - 获取具有多个变量的列的假人
- google-cloud-platform - 用于 Minecraft 服务器的 Google VM RAM
- typescript - TypeScript:通用扩展对象,只有可选键