Drool rule to SQL Stored procedure

[Anitha Naduvath]

Hi ,
  My use case is something like this .
I use the Domain Specific Language feature(expanders or extenders I am not sure )  of Drools . And then use the rule engine to create actual rules .
My query is , is there a way to directly convert the rules above to sql procedures ? So, while invoking , I will call the sql procedure so that I push down rule evaluation to the database ?

Thanks!
Anitha .

[Mauricio Salatino]

Nothing like that exists yet.. mostly because Rules are not exactly the same as SQL store procedures in the way that they are executed. 

To use drools nowadays you will need to get your data from the database, create your data object instance and then insert them as facts. 

HTH

--
You received this message because you are subscribed to the Google Groups "Drools Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to drools-development+unsub...@googlegroups.com.
To post to this group, send email to drools-development@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/drools-development/f5995979-0ccf-4d06-a104-7c482880fe4e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

 - MyJourney @ http://salaboy.com

 - Co-Founder @ http://www.jugargentina.org
 - Co-Founder @ http://www.jbug.com.ar
 
 - Salatino "Salaboy" Mauricio -

[Mauricio Salatino]

By the way, you should not post to Drools Development if you are asking about use cases. 

This is for Drools Developers to discuss features and issues. 

On Wed, Nov 23, 2016 at 9:39 AM, Mauricio Salatino <sal...@gmail.com> wrote:

Nothing like that exists yet.. mostly because Rules are not exactly the same as SQL store procedures in the way that they are executed. 

To use drools nowadays you will need to get your data from the database, create your data object instance and then insert them as facts. 

HTH

On Wed, Nov 23, 2016 at 9:10 AM, Anitha Naduvath <anad...@gmail.com> wrote:

Hi ,
  My use case is something like this .
I use the Domain Specific Language feature(expanders or extenders I am not sure )  of Drools . And then use the rule engine to create actual rules .
My query is , is there a way to directly convert the rules above to sql procedures ? So, while invoking , I will call the sql procedure so that I push down rule evaluation to the database ?

Thanks!
Anitha .

--
You received this message because you are subscribed to the Google Groups "Drools Development" group.

To unsubscribe from this group and stop receiving emails from it, send an email to drools-development+unsubscribe@googlegroups.com.

To post to this group, send email to drools-development@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/drools-development/f5995979-0ccf-4d06-a104-7c482880fe4e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

 - MyJourney @ http://salaboy.com

 - Co-Founder @ http://www.jugargentina.org
 - Co-Founder @ http://www.jbug.com.ar
 
 - Salatino "Salaboy" Mauricio -

[Anitha Naduvath]

Thank you!

This copy and map will cause performance issues and so we wanted to check if we could do pushdown to db .

On Wednesday, November 23, 2016 at 3:09:54 PM UTC+5:30, Salaboy Mauricio Salatino wrote:

Nothing like that exists yet.. mostly because Rules are not exactly the same as SQL store procedures in the way that they are executed. 

To use drools nowadays you will need to get your data from the database, create your data object instance and then insert them as facts. 

HTH

On Wed, Nov 23, 2016 at 9:10 AM, Anitha Naduvath <anad...@gmail.com> wrote:

Hi ,
  My use case is something like this .
I use the Domain Specific Language feature(expanders or extenders I am not sure )  of Drools . And then use the rule engine to create actual rules .
My query is , is there a way to directly convert the rules above to sql procedures ? So, while invoking , I will call the sql procedure so that I push down rule evaluation to the database ?

Thanks!
Anitha .

--
You received this message because you are subscribed to the Google Groups "Drools Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to drools-development+unsub...@googlegroups.com.

To post to this group, send email to drools-de...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/drools-development/f5995979-0ccf-4d06-a104-7c482880fe4e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Amit Sharma]

Hi Salaboy,

I am working on solution to connect with SQL and get the data from SQL database to create new rules using Guided Decision Table in Kie Workbench. Since you mentioned in your reply that "get the data from the database" then can you please advise how we can do that to achieve my requirement?

Thanks in advance!

On Wednesday, November 23, 2016 at 4:39:54 AM UTC-5, Salaboy Mauricio Salatino wrote:

Nothing like that exists yet.. mostly because Rules are not exactly the same as SQL store procedures in the way that they are executed. 

To use drools nowadays you will need to get your data from the database, create your data object instance and then insert them as facts. 

HTH

On Wed, Nov 23, 2016 at 9:10 AM, Anitha Naduvath <anad...@gmail.com> wrote:

Hi ,
  My use case is something like this .
I use the Domain Specific Language feature(expanders or extenders I am not sure )  of Drools . And then use the rule engine to create actual rules .
My query is , is there a way to directly convert the rules above to sql procedures ? So, while invoking , I will call the sql procedure so that I push down rule evaluation to the database ?

Thanks!
Anitha .

--
You received this message because you are subscribed to the Google Groups "Drools Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to drools-development+unsub...@googlegroups.com.

To post to this group, send email to drools-de...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/drools-development/f5995979-0ccf-4d06-a104-7c482880fe4e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.