can using trigger i call external java class in MySQL?

Can I trigger an external program to run when a new record is added to the mysql table?

The external program is in java and instead of scanning the table continuously for new insertions, it will be better if an external program could be triggered.

Any suggestions?

Thanks

Answers


Calling external programs will cause inconsistency in your transactions and corrupt your data if your program were to fail, reconsider your approach to do this from the application side.


Need Your Help

Attribute based interception with Castle.DynamicProxy and Simple Injector

c# simple-injector castle-dynamicproxy

I'm using Simple Injector in my project. For integration Simple Injector with Castle.DynamicProxy I'm using this example.