I saw that you change the transaction-type to RESOURCE_LOCAL, and not JTA as it's in the documentation. In the documentation I think that it mention that drools requires JTA, for it's internal mechanisms, that's why we use bitronix as a transaction manager implementation.
2010/5/4 <andre.fons...@mail.com> > Hi Mauricio, > > It's below, thanks! > > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <persistence > version="1.0" > xsi:schemaLocation= > "http://java.sun.com/xml/ns/persistence > http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd > http://java.sun.com/xml/ns/persistence/orm > http://java.sun.com/xml/ns/persistence/orm_1_0.xsd" > xmlns:orm="http://java.sun.com/xml/ns/persistence/orm" > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > xmlns="http://java.sun.com/xml/ns/persistence"> > > <persistence-unit name="org.drools.persistence.jpa" > transaction-type="RESOURCE_LOCAL"> > <provider>org.hibernate.ejb.HibernatePersistence</provider> > <class>org.drools.persistence.session.SessionInfo</class> > > <class>org.drools.persistence.processinstance.ProcessInstanceInfo</class> > > <class>org.drools.persistence.processinstance.ProcessInstanceEventInfo</class> > <class>org.drools.persistence.processinstance.WorkItemInfo</class> > <properties> > <property name="hibernate.dialect" > value="org.hibernate.dialect.MySQLDialect" /> > <property name="hibernate.connection.url" > value="jdbc:mysql://localhost:3306/drools" /> > <property name="hibernate.connection.driver_class" > value="com.mysql.jdbc.Driver" /> > <property name="hibernate.connection.password" value="mysql" /> > <property name="hibernate.connection.username" value="root" /> > <property name="hibernate.hbm2ddl.auto" value="create-drop" /> > <property name="hibernate.transaction.manager_lookup_class" > value="org.hibernate.transaction.BTMTransactionManagerLookup" /> > </properties> > </persistence-unit> > > </persistence> > > > > -----Original Message----- > From: Mauricio Salatino <sala...@gmail.com> > To: Rules Users List <rules-users@lists.jboss.org> > Sent: Mon, May 3, 2010 11:24 pm > Subject: Re: [rules-users] Drools + ETL Process > > Hi man, > can you show us your persistence.xml file where it's defined > org.drools.persistence.jpa > Persistence Unit? > > > > 2010/5/3 <andre.fons...@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 <sala...@gmail.com> >> To: Rules Users List <rules-users@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.fons...@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 <sala...@gmail.com> >>> To: Rules Users List <rules-users@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.fons...@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.alive...@gmail.com> >>>> To: Rules Users List <rules-users@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.fons...@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@lists.jboss.org >>>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>>> >>>>> >>>> >>>> >>>> -- >>>> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX >>>> >>>> Esteban Aliverti >>>> >>>> _______________________________________________ >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> rules-users mailing list >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> rules-users@lists.jboss.org >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> _______________________________________________ >>>> rules-users mailing list >>>> rules-users@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@lists.jboss.org >>> >>> >>> >>> https://lists.jboss.org/mailman/listinfo/rules-users >>> >>> >>> >>> >>> _______________________________________________ >>> rules-users mailing list >>> rules-users@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@lists.jboss.org >> >> https://lists.jboss.org/mailman/listinfo/rules-users >> >> >> _______________________________________________ >> rules-users mailing list >> rules-users@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@lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > > > _______________________________________________ > rules-users mailing list > rules-users@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@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users