[rules-users] Maintaining DB/Working Memory Synchronization

[Greg Barton]

I don't think there's a built in way to do this with drools, but in general this is done using database triggers.  The trigger fires when the data changes, and from there it's up to you how the record is transported to working memory.  

If you use oracle there's a specific mechanism for this called "Database Change Notification"

--- On Fri, 11/6/09, Daniel Miller <dmiller at versatile.com> wrote:

> From: Daniel Miller <dmiller at versatile.com>
> Subject: [rules-users] Maintaining DB/Working Memory Synchronization
> To: rules-users at lists.jboss.org
> Date: Friday, November 6, 2009, 2:43 PM
> So I hope that someone out here, or
> many of you, can give me some idea  
> of how you do this.
> 
> I have about 20+ entities in my database that I want Drools
> to know  
> about.  Obviously my hope is to apply CEP, rules and
> processes to  
> these items.  However, I feel like I'm missing some
> type of connection  
> between how Drools recommends keeping my working memory in
> sync with  
> my database changes.
> 
> Ideally, I'd love to be able to just update my entities as
> I have been  
> doing in the database, but have those changes automatically
> move their  
> way over into the working memory.  How do any of you
> recommend I  
> accomplish this?
> 
> Thanks in advance for any suggestions.
> 
> Dan Miller 
>   
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>