Scenario:

We are building a web application which uses NHibernate to persist data to an Oracle database. Changes in the database need to be reflected by the web application. Our application is not the only one making changes to the database.


Questions:

Is it possible to take advantage of Oracle database change notification in an NHibernate friendly way (this is just a potential solution and not a hard requirement)? If it is not possible, how is this scenario usually addressed?


Thank you,
Chris

Perhaps I should clarify my original post.

Ignore the particular type of database that we are using (after all, this is partially what everyone is after).

How do I update an interface (ignore the fact that it is web-based, if you'd like) with changes made in the database? I don't believe that everyone polls for changes.

Thank you for any insight,
Chris

So we'll assume that there's no "nice" solution.

One possible solution to this problem might include capturing generated SQL and request update notifications for those statements (with ODP.NET, one can register a dependency on a command, and an event handler gets called when any of the associated tables change).

Can I capture SQL with an interceptor and OnPrepareStatement? Can I do this in the current version? Also, can the SQL string parameter to OnPrepareStatement be executed as is (i.e., could I copy, paste, and execute that string in sqlplus)?

Thank you for your time,
Chris