AppletTalk.com

vejan · Guest

Hello!

I have a little problem. I have a real time form that has to read
data from the database and display it. Another program inputs data into
the database.

CLIENT ---> ORACLE ->> REAL TIME FORM

is a small schema. The information is not mission critical but HAS to be
viewed at most 2 seconds after the insert in the db. The idea is to have
a trigger that sends some kind of information to the real time form. I
was thinking of doing it this way:
- have a small program that holds communication on the server side
- the real time form listens on the socket
- the db trigger sends info on the socket

Are there any better ways?

Regards
Mario Udina