How to call a Java function inside MySQL trigger?

[abhishe...@gmail.com]

Hi all,

We have a situation which requires calling a java function as part of
database trigger.

I am using Java 1.6 and database is MySQL 5.1

Actual problem goes like this:

We have number of systems, each running number of processes on them.
We need to monitor health of these processes and need to report it to
the Clients sitting at remote place.
Each of these processes will be updating their progress information in
database at regular interval of time.
So what we need is to update status indicator in client GUI as soon as
status update is inserted in database by the process.
For this we are planning to write an insert trigger and in that
trigger we need to call java function which will update the Client
GUIs remotely.

Please guide me to call java function in MySQL trigger.

Thanks in advance.

[arthur...@gmail.com]

You may check this out:

http://code.rocksol.it/call-java-from-mysql-trigger

regards,

[ArthurRM]

Had almost the same problem to tackle just recently and wrote a package to make MySQL triggers fire Java code:

http://code.rocksol.it/call-java-from-mysql-trigger

[abhinai...@boxcarcentral.com]

Hi ArthurRM,

Could you please share the code base because we are getting 404 error.

Regards,
Abhinai B

[Paul]

Get an archive copy ?

https://web.archive.org/web/20120713234241/http://code.rocksol.it/call-java-from-mysql-trigger

https://web.archive.org/web/20120618005922/http://code.rocksol.it/jdbtrigger.jar

Archive.org has more than 5000 disk drives, holding
old copies of web sites.

Paul