[rules-users] Drools + ETL Process

[Mauricio Salatino]

Ok looks nice.. but you shouldn't begin and commit the transaction. If you
remove that.. do you have some error?

2010/5/2 <andre.fonseca at mail.com>

>  Hi Mauricio,
>
> Sorry if I was not clear. I have already installed Guvnor, and I have also
> changed repository.xml to persist data in MySQL.
> But I dont want to use Guvnor, I would like to author the rules and facts
> in Eclipse using Drools plugin ( I have also installed it ) and persist data
> in MySQL.
> That's because I'm trying to use JPAKnowlegeService
> Could you please take a look in the code of pastebin?
>
> TIA
>
>
>  -----Original Message-----
> From: Mauricio Salatino <salaboy at gmail.com>
> To: Rules Users List <rules-users at lists.jboss.org>
> Sent: Fri, Apr 30, 2010 6:54 pm
> Subject: Re: [rules-users] Drools + ETL Process
>
>  Hi man,
> you are mixing a lot of stuff here..
> I will recommend you the following steps for achieving the steps that you
> are mentioning
> 1) Install guvnor
> 2) author the rules inside it.. (it already contains a JCR repository, that
> is similar to a database, it will allow you to store rules there), you can
> also author some objects (fact model) inside guvnor.
> 3) Then you can create tests to execute the rules and see which rules are
> fired.
>
> Greetings, hope it helps!
> 2010/4/30 <andre.fonseca at mail.com>
>
>>
>>  Hi Esteban,
>>
>> Sorry, I have only one week looking into Drools =)
>> Yes, I am talking about Drools Expert Database
>>
>> Looking into this
>> http://downloads.jboss.com/drools/docs/5.0.1.26597.FINAL/apidocs/org/drools/persistence/jpa/JPAKnowledgeService.htmlI tried a sample snippet
>>
>> http://pastebin.com/uJd5642D
>>
>> But its incomplete, for example, I need to create the Rule in the database
>> also
>>
>> The things that I need to do are:
>> 1) Create Rule and Object Facts in Java and persist them in the Drools
>> Expert Database
>> 2) Check in the Guvnor Interface the Rules and Facts created in the step
>> before
>> 2) Fire the Rules created and get the response
>>
>>  Is there someone that have experience using JPA persistence with Drools?
>> I already have a simple project configured using JPA and Hibernate but I
>> still don't know how to proceed =(
>>
>> Thanks In Advance !
>>   -----Original Message-----
>> From: Esteban Aliverti <esteban.aliverti at gmail.com>
>> To: Rules Users List <rules-users at lists.jboss.org>
>> Sent: Thu, Apr 29, 2010 9:02 pm
>> Subject: Re: [rules-users] Drools + ETL Process
>>
>>  Which drools database are you talking about? If you just want to use
>> drools expert, you don't need any db. If you want to persist your kbase or
>> rules, feel free to use whatever mechanism you want.
>>
>>  2010/4/28 <andre.fonseca at mail.com>
>>
>>>
>>>  Hi all,
>>>
>>> I am using Drools 5.0 with Tomcat 6 and MySQL.
>>>
>>> Now I need to insert data in the drools database but I DON'T want to use
>>> the Guvnor interface.
>>> This is because in the future we'll need to use a kind of ETL process to
>>> populate the drools database.
>>>
>>> Should I create a java class with JDBC access and perform a SQL direct to
>>> that tables?
>>> I did the reverse engineering of the drools database but I could not
>>> understood yet where the data are persisted.
>>>
>>> Any advice should be very helpful.
>>>
>>> Thanks in advance.
>>>
>>>
>>> _______________________________________________
>>> rules-users mailing list
>>> rules-users at lists.jboss.org
>>> https://lists.jboss.org/mailman/listinfo/rules-users
>>>
>>>
>>
>>
>> --
>> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
>>
>> Esteban Aliverti
>>
>> _______________________________________________
>>
>>
>> rules-users mailing list
>>
>> rules-users at lists.jboss.org
>>
>> https://lists.jboss.org/mailman/listinfo/rules-users
>>
>>
>> _______________________________________________
>> rules-users mailing list
>> rules-users at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/rules-users
>>
>>
>
>
> --
> - http://salaboy.wordpress.com
> - http://www.jbug.com.ar
> - Salatino "Salaboy" Mauricio -
>
> _______________________________________________
>
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>


-- 
- http://salaboy.wordpress.com
- http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20100502/80f7e643/attachment.html