Re: [hibernate-dev] Oracle's Database Change Notification

2010-04-08 Thread Gunnar Morling
Sounds definitely promising. It would be interesting to see how this behaves performance-wise. When reading the documentation, I wondered how to exclude changes made by Hibernate itself from the notification mechanism, but I guess, there will be some way. Gunnar 2010/4/8 Steve Ebersole > If w

Re: [hibernate-dev] Oracle's Database Change Notification

2010-04-08 Thread Steve Ebersole
If we could make it generic enough so it could work with other notification schemes (other vendor extensions, user written triggers, etc) then I'd be all of including this. Of course starting off with targeting a specific one and growing out from there is ok :) On 04/08/2010 07:29 AM, Emmanue

Re: [hibernate-dev] Oracle's Database Change Notification

2010-04-08 Thread Sanne Grinovero
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 : > There's an interesting feature in Oracle that let's you

[hibernate-dev] Oracle's Database Change Notification

2010-04-08 Thread Emmanuel Bernard
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 prototyp