[rules-users] Drools + ETL Process

Mon May 3 22:24:10 EDT 2010

Hi man,
can you show us your persistence.xml file where it's defined
org.drools.persistence.jpa
Persistence Unit?

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

>
>  Hi Mauricio, thanks for your reply
>
> I have commented the transaction , please check
> http://pastebin.com/NxQyft2t
> I put the hibernate log there too.
>
> There is no error, after the first time executed I have the tables created
> in mysql
>
> | processinstanceeventinfo       |
> | processinstanceinfo            |
> | processinstanceinfo_eventtypes |
> | sessioninfo                    |
> | workiteminfo                   |
>
> but they are empty, this is because I am not creating a process just rules
> and facts?
>
> the drools expert knowlege database persist rules and facts or this is
> maintained only in the working memory?
>
> TIA
>
>
>
>
>  -----Original Message-----
> From: Mauricio Salatino <salaboy at gmail.com>
> To: Rules Users List <rules-users at lists.jboss.org>
> Sent: Sun, May 2, 2010 11:16 pm
> Subject: Re: [rules-users] Drools + ETL Process
>
>  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 -
>
> _______________________________________________
>
> 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/20100503/111fd242/attachment.html 