Automatic updates to table

[sankvs]

We've creates an app that displays the contents of an Oracle db table in a Java table. This was done by setting Java params and is therefore static.

Has anyone experience with displaying updates to the Oracle db tables automatically on the Java tables ? Is JSP or servlets the way to go here ? Any pointers would be greatly appreciated.

Thanks and regards
Vasu

[spider_man]

Ok, read about triggers and stored procedures (It's kinda lot of info to explain it in a TEXTAREA).

[Anon]

We have a table presenter that displays the rows of an Oracle table and I'd like to update the presenter (update values, add rows, delete rows) as and when similar changes occur in Oracle. Currently, the view is static (in that changes need the entire page to be reloaded). The cell values are passed to the Java presenter as PARAM values.

Triggers and stored procedures would be useful to indicate that changes have occured.

The question I have is what would be the best way of interfacing the Java presenter to the Oracle db in order to make the updates automatic (in the sense that the page does not need to be manually reloaded. I also dont mean to have a page reload since the amount of db work and network load would remain the same). So, is there a simpler way in PHP to implement this functionality (apart from using sockets and sending compressed data from PHP to a custom Java applet) ?

Thanks
Vasu