我可以使用oracle db监听器解决这个问题吗?
尽量说得更清楚,我对这个问题缺乏想法,即使它听起来很经典。
我的应用程序在 weblogic 10.3.3 应用程序服务器上运行,对于数据库,我使用 Oracle 数据库 11g。我的问题是数据库中有一个表,比如说“user”,该表中有一个列,比如说“columnA”。该表正在由应用程序的某些模块更新。
如果当列的值为“abc”时,我想要什么,那么我必须向控制台(IP)显示警报。 {IP 可以从数据库中检索,因为它是在数据库中配置的。这个IP将是安装oracle数据库的Linux机器以外的其他Linux系统。}更新是从应用程序模块在我的表上不断完成的。请告诉我应该从哪里开始?我应该读什么。我无法理解应该采取什么方法。非常感谢任何帮助。
你能给我提供 oracle db 监听器的 begginner.s 链接吗?
Try to be more clear, I'm in lack of ideas in this problem, even it sounds like a classic.
My application is running on weblogic 10.3.3 application server, and for database I am using Oracle database 11g. My problem is that there is table in db, let's say "user.", there is column, let's say "columnA", in this table. This table is updating by some module of application.
What I want if when value of column is "abc.", then I have to show alert to console(IP). {IP can be retrieved from DB as it is configured in DB. this ip will be other linux system other than linux machine where oracle database is installed.} Updating is continuously done on my table from module of application. Please tell me from where should I start?, what should I read. I am not able to understand what should be approach. Any help is much appreciated.
Can u provide me any begginner.s link of oracle db listener?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您可能想查看在数据库中设置触发器
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/triggers.htm
You probably want to look at setting up a Trigger in the database
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/triggers.htm
触发器的替代方法是记录针对表的更新查询(到日志文件)并让进程监视日志,在发生某些情况时发出警报。
An alternative to a trigger would be to log update queries against the table (to a log file) and have a process monitor the log, sending out alerts when something happens.