Re: [rules-users] Drools + ETL Process

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(a)gmail.com&gt; To: Rules Users List <rules-users(a)lists.jboss.org&gt; 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(a)mail.com&gt; > 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(a)gmail.com&gt; > To: Rules Users List <rules-users(a)lists.jboss.org&gt; > 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(a)mail.com&gt; > >> >> 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/droo... 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(a)gmail.com&gt; >> To: Rules Users List <rules-users(a)lists.jboss.org&gt; >> 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(a)mail.com&gt; >> >>> >>> 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(a)lists.jboss.org >>> https://lists.jboss.org/mailman/listinfo/rules-users >>> >>> >> >> >> -- >> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX >> >> Esteban Aliverti >> >> _______________________________________________ >> >> >> >> >> rules-users mailing list >> >> >> >> rules-users(a)lists.jboss.org >> >> >> >> https://lists.jboss.org/mailman/listinfo/rules-users >> >> >> >> >> _______________________________________________ >> rules-users mailing list >> rules-users(a)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(a)lists.jboss.org > > https://lists.jboss.org/mailman/listinfo/rules-users > > > _______________________________________________ > rules-users mailing list > rules-users(a)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(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users