File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes how to automatically detect a row insertion in database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to automatically detect a row insertion in database" Watch "how to automatically detect a row insertion in database" New topic
Author

how to automatically detect a row insertion in database

utsav gupta
Ranch Hand

Joined: Mar 19, 2009
Posts: 57
Hi

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?

Thanks
utsav.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41508
    
  53
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 - my free Android networking tools app
utsav gupta
Ranch Hand

Joined: Mar 19, 2009
Posts: 57
Hi

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.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41508
    
  53
Yes - consult the documentation of the DB you're using about "triggers" and "stored procedures written in Java".
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to automatically detect a row insertion in database