如何用java制作数据库监听器? [英] How to make a database listener with java?

问题描述

大家好我想做一个触发器或一个监听器(我不知道是什么)来监听特定的数据库表，并在这个表上插入每条新记录，做一些 java 代码，我的意思是它检测到一个插入新记录并在可能的情况下获取其数据我需要一些有关如何完成此过程的指南?

Greetings all I want to do something like a trigger or a listener (I don't know what) that will listen on a specific database table, and with each new record inserted on this table, do some java code, I mean that it detects that a new record was inserted and get it's data if it's possible I need some guide about how this process can be accomplished ?

我正在使用 Spring-Hibernate-PostgreSQL

I am using Spring-Hibernate-PostgreSQL

推荐答案

这就是 LISTEN/NOTIFY 是为.

唯一的缺点是您需要某种后台线程来定期轮询数据库以查看是否有任何通知可用.

The only drawback is that you will need to have some kind of background thread that polls the database on a regular basis to see if any notifications are available.

您也可以使用 Postgres Wiki 中的代码作为起点

You can also use the code from the Postgres Wiki to have a starting point

这篇关于如何用java制作数据库监听器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！