I vaguely remember to have overheard that PostgreSQL supports
something similar, would be really nice; sorry don't have a reference.
If it works nicely for second level caches, you might extend it to Search too.
2010/4/8 Emmanuel Bernard <emmanuel(a)hibernate.org>:
There's an interesting feature in Oracle that let's you
register to database changes events
http://download.oracle.com/docs/cd/E11882_01/java.112/e10589/dbchgnf.htm
We could use that to invalidate second level caches properly even if a third-party app
update the DB.
Worth considering a prototype in Hibernate?
_______________________________________________
hibernate-dev mailing list
hibernate-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev