I want to an application be triggered as soon as a row is inserted in a database. I wwould like to have it happen on an event basis. That is as soon as a row is inserted an oject is created or a function is called. Is there a way to do it?
That depends on which database you're using. Many databases have a feature called "trigger", which are stored procedures executed when certain conditions occur (like an insert in a table). Some databases allow stored procedures to be written in Java (Oracle, PostgreSQL with the PL/Java extension, Derby etc.). This wouldn't work if you wanted that object created (or method called) not in the DB but in some external application.
Ping & DNS - updated with new look and Ping home screen widget
Joined: Mar 19, 2009
Thanks for your reply.
Is it possible to create an object that can keep a watch on a particular table in java and invoke a method when a row enters. In that way I would be able to generate a code that will common to all types of database.
However my current focus is oracle and db2.
Joined: Mar 22, 2005
Yes - consult the documentation of the DB you're using about "triggers" and "stored procedures written in Java".