Re: [rules-users] FactType returns null when creating a java client on Eclipse invoking a rule in Guvnor
hi Michael,
My environment is like below
droools expert 5.3.0 final
guvnor 5.3.0 final - guvnor-5.3.0.Final-tomcat-6.0.war
Eclipse Helios - JBoss Drools Workbench 4.0.7 plugin
I am not using authentication in guvnor, using guest user
Actually I think I resolved the issue!
I think I was missing to build the package! Now it works, below the test code
I used
Java Class
Resource xml = ResourceFactory.newClassPathResource("changeset.xml");
KnowledgeAgent kAgent = KnowledgeAgentFactory.newKnowledgeAgent("myagent");
kAgent.applyChangeSet(xml);
KnowledgeBase kBase = kAgent.getKnowledgeBase();
FactType fType = kBase.getFactType("mypackage", "MyObject");
Thanks for all!
- Original Message -
From: Michael Anstis
Sent: 01/09/12 06:13 AM
To: Rules Users List
Subject: Re: [rules-users] FactType returns null when creating a java client on
Eclipse invoking a rule in Guvnor
What version of Drools Expert and Guvnor are you using?
On 9 January 2012 00:47, kachaps4u < kachananidha...@gmail.com > wrote:
Exactly my error too!!! I too followed their documentation.. some one had to
find it. My project has ESB in it too.. So I went to the next step in
running the uri from an ESB and it was successful. But the thing is I
uploaded the POJO jars and wrote rules. I didn't test creating FACT in BRMS
and running the same because I couldn't solve this error. let me see whether
i can do something. I will update if i get any positive result.
--
View this message in context:
http://drools.46999.n3.nabble.com/rules-users-FactType-returns-null-when-creating-a-java-client-on-Eclipse-invoking-a-rule-in-Guvnor-tp3642559p3643345.html
Sent from the Drools: User forum mailing list archive at Nabble.com.
___
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
Re: [rules-users] FactType returns null when creating a java client on Eclipse invoking a rule in Guvnor
Hi, another comment
When I try to access my own package using
http://localhost:8090/drools-guvnor/org.drools.guvnor.Guvnor/package/mypackage/LATEST
I am getting
java.lang.NullPointerException
java.io.OutputStream.write(Unknown Source)
org.drools.guvnor.server.files.FileManagerUtils.loadBinaryPackage(FileManagerUtils.java:189)
But when I try using
http://localhost:8090/drools-guvnor/org.drools.guvnor.Guvnor/package/mypackage/LATEST.drl
I can download the drl file TIA
- Original Message -
From: Andre Fonseca
Sent: 01/08/12 06:34 PM
To: Rules Users List
Subject: Re: [rules-users] FactType returns null when creating a java client on
Eclipse invoking a rule in Guvnor
Hi Kachan, thanks for your reply! I took a look in your post and tried to adapt
my code, this is below: # Strategy 1 KnowledgeAgent kagent =
KnowledgeAgentFactory.newKnowledgeAgent("myagent");
kagent.applyChangeSet(ResourceFactory.newUrlResource("http://localhost:8090/drools-guvnor/org.drools.guvnor.Guvnor/package/mortgages/LATEST";));
KnowledgeBase kbase = kagent.getKnowledgeBase(); FactType appType =
kbase.getFactType("mortgages", "LoanApplication"); I copied the URL
"http://localhost:8090/drools-guvnor/org.drools.guvnor.Guvnor/package/mortgages/LATEST";
and past it on the browser, it downloads the file mortgages.pkg, so its
correct right? But executing this code I got "(null: 1, 1): Content is not
allowed in prolog." So I changed the line 2 to use #Strategy 2
kagent.applyChangeSet(ResourceFactory.newClassPathResource("src/main/resources/mortgage-changeset.xml"));
The mortgage-charset.xml is below
http://drools.org/drools-5.0/change-set";
xmlns:xs="http://www.w3.org/2001/XMLSchema-instance";
xs:schemaLocation="http://drools.org/drools-5.0/change-set
http://anonsvn.jboss.org/repos/labs/labs/jbossrules/trunk/drools-api/src/main/resources/change-set-1.0.0.xsd";>
http://localhost:8090/drools-guvnor/org.drools.guvnor.Guvnor/package/mortgages/LATEST";
type="PKG" basicAuthentication="enabled" username="admin" password="admin" />
With this change I dont have error, but the variable appType
returns null again. The point here is, I am using Guvnor with guest user (no
authentication) this could be the problem? The URL from Strategy1 is corrected,
I tested it. The file in Stragety2 is corrected to, I debug it and see the file
inputstream. TIA
- Original Message -
From: kachaps4u
Sent: 01/08/12 05:54 PM
To: rules-users@lists.jboss.org
Subject: Re: [rules-users] FactType returns null when creating a java client on
Eclipse invoking a rule in Guvnor
http://drools.46999.n3.nabble.com/urlResource-applyChangeset-and-authentication-error-td3629051.html
Hey, Please read the above and see whether it can help you. I had the same
problem returning null. Then I stopped it and now doing in ESB to access the
resources using its rules processor. But sometimes the above discussion can
help you and if you have anything positive please let me know too. I was trying
my own example in fact and not the mortgage. I think this would help both of
us. Thank you. Kachan -- View this message in context:
http://drools.46999.n3.nabble.com/rules-users-FactType-returns-null-when-creating-a-java-client-on-Eclipse-invoking-a-rule-in-Guvnor-tp3642559p3642609.html
Sent from the Drools: User forum mailing list archive at Nabble.com.
___ 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
Re: [rules-users] FactType returns null when creating a java client on Eclipse invoking a rule in Guvnor
Hi Kachan, thanks for your reply!
I took a look in your post and tried to adapt my code, this is below:
# Strategy 1
KnowledgeAgent kagent = KnowledgeAgentFactory.newKnowledgeAgent("myagent");
kagent.applyChangeSet(ResourceFactory.newUrlResource("http://localhost:8090/drools-guvnor/org.drools.guvnor.Guvnor/package/mortgages/LATEST";));
KnowledgeBase kbase = kagent.getKnowledgeBase();
FactType appType = kbase.getFactType("mortgages", "LoanApplication");
I copied the URL
"http://localhost:8090/drools-guvnor/org.drools.guvnor.Guvnor/package/mortgages/LATEST";
and past it on the browser, it downloads the file mortgages.pkg, so its
correct right?
But executing this code I got "(null: 1, 1): Content is not allowed in prolog."
So I changed the line 2 to use
#Strategy 2
kagent.applyChangeSet(ResourceFactory.newClassPathResource("src/main/resources/mortgage-changeset.xml"));
The mortgage-charset.xml is below
http://drools.org/drools-5.0/change-set";
xmlns:xs="http://www.w3.org/2001/XMLSchema-instance";
xs:schemaLocation="http://drools.org/drools-5.0/change-set
http://anonsvn.jboss.org/repos/labs/labs/jbossrules/trunk/drools-api/src/main/resources/change-set-1.0.0.xsd";>
http://localhost:8090/drools-guvnor/org.drools.guvnor.Guvnor/package/mortgages/LATEST";
type="PKG" basicAuthentication="enabled" username="admin" password="admin" />
With this change I dont have error, but the variable appType returns null
again.
The point here is, I am using Guvnor with guest user (no authentication) this
could be the problem?
The URL from Strategy1 is corrected, I tested it. The file in Stragety2 is
corrected to, I debug it and see the file inputstream.
TIA
- Original Message -
From: kachaps4u
Sent: 01/08/12 05:54 PM
To: rules-users@lists.jboss.org
Subject: Re: [rules-users] FactType returns null when creating a java client on
Eclipse invoking a rule in Guvnor
http://drools.46999.n3.nabble.com/urlResource-applyChangeset-and-authentication-error-td3629051.html
Hey, Please read the above and see whether it can help you. I had the same
problem returning null. Then I stopped it and now doing in ESB to access the
resources using its rules processor. But sometimes the above discussion can
help you and if you have anything positive please let me know too. I was trying
my own example in fact and not the mortgage. I think this would help both of
us. Thank you. Kachan -- View this message in context:
http://drools.46999.n3.nabble.com/rules-users-FactType-returns-null-when-creating-a-java-client-on-Eclipse-invoking-a-rule-in-Guvnor-tp3642559p3642609.html
Sent from the Drools: User forum mailing list archive at Nabble.com.
___ 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
[rules-users] FactType returns null when creating a java client on Eclipse invoking a rule in Guvnor
Hi all,
I have imported the mortgage-sample-repository.xml to my guvnor instance. Its
okey.
Then I tried to run the MortgageClientExample java class.
Everything is okey, but when I try to create the FactType
"FactType appType = kbase.getFactType("mortgages", "LoanApplication");"
I have null as the result for the appType variable.
The KnowledgeBase is okey also.
I used the same configurations of the example that comes with guvnor download.
I am in Windows with Tomcat 7.
I appreciate any help.
TIA
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
[rules-users] Schedule Rules to Fire in Drools Expert
Hi all, It's possible to schedule (and reschedule) rules to fire in Drools Expert? As my understood the Agenda is a kind of TODO list right? Can I reorder the priority of that list so? Could someone give-me and idea (a pseudo-code or something like that) to show that concept? Thanks In Advance! ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] Drools + ETL Process
Hi Mauricio, team I mapped my javabean in the persistence.xml org.acme.drools.Account And after run my main test I can see the "account table" in DB, but it's still empty, probably I am missing something in the project configuration. Let me check and I'll reply back Tks! -Original Message- From: andre.fons...@mail.com To: rules-users@lists.jboss.org Sent: Tue, May 4, 2010 12:28 pm Subject: Re: [rules-users] Drools + ETL Process Hi Mauricio, It's below, thanks! 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";> org.hibernate.ejb.HibernatePersistence org.drools.persistence.session.SessionInfo org.drools.persistence.processinstance.ProcessInstanceInfo org.drools.persistence.processinstance.ProcessInstanceEventInfo org.drools.persistence.processinstance.WorkItemInfo -Original Message- From: Mauricio Salatino To: Rules Users List 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 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 To: Rules Users List 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 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 To: Rules Users List 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 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.html I 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 To: Rules Users List 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 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 becaus
Re: [rules-users] Drools + ETL Process
Hi Mauricio, It's below, thanks! 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";> org.hibernate.ejb.HibernatePersistence org.drools.persistence.session.SessionInfo org.drools.persistence.processinstance.ProcessInstanceInfo org.drools.persistence.processinstance.ProcessInstanceEventInfo org.drools.persistence.processinstance.WorkItemInfo -Original Message- From: Mauricio Salatino To: Rules Users List 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 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 To: Rules Users List 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 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 To: Rules Users List 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 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.html I 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 To: Rules Users List 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 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 http
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 To: Rules Users List 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 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 To: Rules Users List 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 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.html I 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 To: Rules Users List 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 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 -- 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 _
Re: [rules-users] Drools + ETL Process
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 To: Rules Users List 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 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.html I 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 To: Rules Users List 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 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 -- 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
Re: [rules-users] Drools + ETL Process
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.html I 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 To: Rules Users List 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 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 -- 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
[rules-users] Drools + ETL Process
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
Re: [rules-users] Guvnor - Persist data in MySQL
Hi, I have changed the repository.xml to NOT use JNDI and its working now. Could someone give me an example of a configuration using JNDI ? Thanks a lot! -Original Message- From: andre.fons...@mail.com To: rules-users@lists.jboss.org Sent: Mon, Apr 26, 2010 2:09 pm Subject: [rules-users] Guvnor - Persist data in MySQL Hi all, I am trying to configure Guvnor to persist data in MySQL, I am running mysql 5.1-45 (windows 7) under Tomcat 6 The steps that I did: 1) Create empty database "drools" in Mysql 2) Configure Tomcat data source 3) Edit generated repository.xml I used the links below to try those steps 1.2.2.2. Configuring Guvnor to use an external RDBMS http://downloads.jboss.com/drools/docs/5.0.1.26597.FINAL/drools-guvnor/html_single/index.html http://wiki.apache.org/jackrabbit/UsingJNDIDataSource Unfortunately I am getting the exception below Caused by: org.drools.repository.RulesRepositoryException: javax.jcr.RepositoryException: Invalid repository configuration: repository.xml: Configuration element FileSystem not found in Versioning.: Configuration element FileSystem not found in Versioning. at org.drools.guvnor.server.repository.BRMSRepositoryConfiguration.newSession(BRMSRepositoryConfiguration.java:116) at org.drools.guvnor.server.repository.BRMSRepositoryConfiguration.create(BRMSRepositoryConfiguration.java:56) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) - Caused by: javax.jcr.RepositoryException: Invalid repository configuration: repository.xml: Configuration element FileSystem not found in Versioning.: Configuration element FileSystem not found in Versioning. at org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:250) at org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:265) at org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:333) at org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:363) at org.drools.guvnor.server.repository.BRMSRepositoryConfiguration.newSession(BRMSRepositoryConfiguration.java:112) ... 62 more Could you please assist? Thanks in Advance ___ 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
[rules-users] Guvnor - Persist data in MySQL
Hi all, I am trying to configure Guvnor to persist data in MySQL, I am running mysql 5.1-45 (windows 7) under Tomcat 6 The steps that I did: 1) Create empty database "drools" in Mysql 2) Configure Tomcat data source 3) Edit generated repository.xml I used the links below to try those steps 1.2.2.2. Configuring Guvnor to use an external RDBMS http://downloads.jboss.com/drools/docs/5.0.1.26597.FINAL/drools-guvnor/html_single/index.html http://wiki.apache.org/jackrabbit/UsingJNDIDataSource Unfortunately I am getting the exception below Caused by: org.drools.repository.RulesRepositoryException: javax.jcr.RepositoryException: Invalid repository configuration: repository.xml: Configuration element FileSystem not found in Versioning.: Configuration element FileSystem not found in Versioning. at org.drools.guvnor.server.repository.BRMSRepositoryConfiguration.newSession(BRMSRepositoryConfiguration.java:116) at org.drools.guvnor.server.repository.BRMSRepositoryConfiguration.create(BRMSRepositoryConfiguration.java:56) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) - Caused by: javax.jcr.RepositoryException: Invalid repository configuration: repository.xml: Configuration element FileSystem not found in Versioning.: Configuration element FileSystem not found in Versioning. at org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:250) at org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:265) at org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:333) at org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:363) at org.drools.guvnor.server.repository.BRMSRepositoryConfiguration.newSession(BRMSRepositoryConfiguration.java:112) ... 62 more Could you please assist? Thanks in Advance ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] Error deploy Guvnor - DEPLOYMENTS MISSING DEPENDENCIES
Jervis, - downloaded Drools Guvnor 5.0 - removed el-*jars - added support for JSF in the app (for deploy in Tomcat 6.0) - jsf-api, jsf-impl The deploy in Tomcat 6.0 has been successfully. Many Thanks! -Original Message- From: andre.fons...@mail.com To: rules-users@lists.jboss.org Sent: Mon, Apr 26, 2010 9:08 am Subject: Re: [rules-users] Error deploy Guvnor - DEPLOYMENTS MISSING DEPENDENCIES Thanks Jervis, I will check the link and post back. André -Original Message- From: Jervisliu To: Rules Users List Sent: Mon, Apr 26, 2010 2:33 am Subject: Re: [rules-users] Error deploy Guvnor - DEPLOYMENTS MISSING DEPENDENCIES Hi, please refer to this doc on how to deploy Guvnor in JBOSS AS 5.1 [1]. Have not tried this on AS 6, let me know if it does not work. [1]. http://community.jboss.org/docs/DOC-14395 Cheers, Jervis Liu andre.fons...@mail.com wrote: > > Hi all, > > I am trying to deployed Guvnor (5.0 and 5.1) in Jboss 6.0 using Windows 7 > > I edited WEB-INF/components.xml to change the directory to uncoment > the properties > > C:/my-path > name="configurator">org.drools.repository.JackrabbitRepositoryConfigurator > > Then I created a folder in default/deploy in Jboss and copy all the > content to there. > > I am getting the exception below > > Could someone please assist? There are something else I need to do > except to edit components.xml? > > I have also tested the deploy with the war file without sucess. > > TIA > > 2010-04-23 10:17:44,761 INFO > [org.jboss.system.server.profileservice.ProfileServiceBootstrap] > (Thread-2) Loading profile: profile...@2c842c[domain=default, > server=default, name=default] > 2010-04-23 10:17:44,777 ERROR > [org.jboss.system.server.profileservice.ProfileServiceBootstrap] > (Thread-2) Failed to load profile: Summary of incomplete deployments > (SEE PREVIOUS ERRORS FOR DETAILS): > > DEPLOYMENTS MISSING DEPENDENCIES: > Deployment "JBossTimerServiceFactory" is missing the following > dependencies: > Dependency "jboss.ejb:service=EJBTimerService" (should be in state > "Create", but is actually in state "Configured") > Deployment > "jboss.ejb:persistencePolicy=database,service=EJBTimerService" is > missing the following dependencies: > Dependency "jboss.jca:name=DefaultDS,service=DataSourceBinding" > (should be in state "Create", but is actually in state "** NOT FOUND > Depends on 'jboss.jca:name=DefaultDS,service=DataSourceBinding' **") > Dependency "jboss.jdbc:datasource=DefaultDS,service=metadata" > (should be in state "Create", but is actually in state "** NOT FOUND > Depends on 'jboss.jdbc:datasource=DefaultDS,service=metadata' **") > Deployment "jboss.ejb:service=EJBTimerService" is missing the > following dependencies: > Dependency > "jboss.ejb:persistencePolicy=database,service=EJBTimerService" (should > be in state "Create", but is actually in state "Configured") > Deployment > "jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory" > is missing the following dependencies: > Dependency "jboss.messaging:service=PostOffice" (should be in > state "Create", but is actually in state "Configured") > Dependency "jboss.messaging:service=ServerPeer" (should be in > state "Create", but is actually in state "Configured") > Dependency > "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" > (should be in state "Create", but is actually in state "Configured") > Deployment > "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" > is missing the following dependencies: > Dependency "jboss.messaging:service=PostOffice" (should be in > state "Create", but is actually in state "Configured") > Dependency "jboss.messaging:service=ServerPeer" (should be in > state "Create", but is actually in state "Configured") > Deployment > "jboss.messaging.connectionfactory:service=ConnectionFactory" is > missing the following dependencies: > Dependency "jboss.messaging:service=ServerPeer" (should be in > state "Create", but is actually in state "Configured") > Dependency "jboss.messaging:service=PostOffice" (should be in > state "Create", but is actually in state "Configured") > Deployment "jboss.messaging.destination:name=DLQ,service=Queue" is > missing the following dependencies: > Dependency "jboss.messaging:service=PostOffice" (should be in > state "Create", but is actually in state "Configured") > Dependency "jboss.messaging:service=ServerPeer" (should be in > state "Create", but is actually in state "Configured") > Deployment > "jboss.messaging.destination:name=ExpiryQueue,service=Queue" is > missing the following dependencies: > Dependency "jboss.messaging:service=ServerPeer" (should be in > state "Create", but is actually in state "Configured") > Dependency "jboss.messaging:servi
Re: [rules-users] Error deploy Guvnor - DEPLOYMENTS MISSING DEPENDENCIES
Thanks Jervis, I will check the link and post back. André -Original Message- From: Jervisliu To: Rules Users List Sent: Mon, Apr 26, 2010 2:33 am Subject: Re: [rules-users] Error deploy Guvnor - DEPLOYMENTS MISSING DEPENDENCIES Hi, please refer to this doc on how to deploy Guvnor in JBOSS AS 5.1 [1]. Have not tried this on AS 6, let me know if it does not work. [1]. http://community.jboss.org/docs/DOC-14395 Cheers, Jervis Liu andre.fons...@mail.com wrote: > > Hi all, > > I am trying to deployed Guvnor (5.0 and 5.1) in Jboss 6.0 using Windows 7 > > I edited WEB-INF/components.xml to change the directory to uncoment > the properties > > C:/my-path > name="configurator">org.drools.repository.JackrabbitRepositoryConfigurator > > Then I created a folder in default/deploy in Jboss and copy all the > content to there. > > I am getting the exception below > > Could someone please assist? There are something else I need to do > except to edit components.xml? > > I have also tested the deploy with the war file without sucess. > > TIA > > 2010-04-23 10:17:44,761 INFO > [org.jboss.system.server.profileservice.ProfileServiceBootstrap] > (Thread-2) Loading profile: profile...@2c842c[domain=default, > server=default, name=default] > 2010-04-23 10:17:44,777 ERROR > [org.jboss.system.server.profileservice.ProfileServiceBootstrap] > (Thread-2) Failed to load profile: Summary of incomplete deployments > (SEE PREVIOUS ERRORS FOR DETAILS): > > DEPLOYMENTS MISSING DEPENDENCIES: > Deployment "JBossTimerServiceFactory" is missing the following > dependencies: > Dependency "jboss.ejb:service=EJBTimerService" (should be in state > "Create", but is actually in state "Configured") > Deployment > "jboss.ejb:persistencePolicy=database,service=EJBTimerService" is > missing the following dependencies: > Dependency "jboss.jca:name=DefaultDS,service=DataSourceBinding" > (should be in state "Create", but is actually in state "** NOT FOUND > Depends on 'jboss.jca:name=DefaultDS,service=DataSourceBinding' **") > Dependency "jboss.jdbc:datasource=DefaultDS,service=metadata" > (should be in state "Create", but is actually in state "** NOT FOUND > Depends on 'jboss.jdbc:datasource=DefaultDS,service=metadata' **") > Deployment "jboss.ejb:service=EJBTimerService" is missing the > following dependencies: > Dependency > "jboss.ejb:persistencePolicy=database,service=EJBTimerService" (should > be in state "Create", but is actually in state "Configured") > Deployment > "jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory" > is missing the following dependencies: > Dependency "jboss.messaging:service=PostOffice" (should be in > state "Create", but is actually in state "Configured") > Dependency "jboss.messaging:service=ServerPeer" (should be in > state "Create", but is actually in state "Configured") > Dependency > "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" > (should be in state "Create", but is actually in state "Configured") > Deployment > "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" > is missing the following dependencies: > Dependency "jboss.messaging:service=PostOffice" (should be in > state "Create", but is actually in state "Configured") > Dependency "jboss.messaging:service=ServerPeer" (should be in > state "Create", but is actually in state "Configured") > Deployment > "jboss.messaging.connectionfactory:service=ConnectionFactory" is > missing the following dependencies: > Dependency "jboss.messaging:service=ServerPeer" (should be in > state "Create", but is actually in state "Configured") > Dependency "jboss.messaging:service=PostOffice" (should be in > state "Create", but is actually in state "Configured") > Deployment "jboss.messaging.destination:name=DLQ,service=Queue" is > missing the following dependencies: > Dependency "jboss.messaging:service=PostOffice" (should be in > state "Create", but is actually in state "Configured") > Dependency "jboss.messaging:service=ServerPeer" (should be in > state "Create", but is actually in state "Configured") > Deployment > "jboss.messaging.destination:name=ExpiryQueue,service=Queue" is > missing the following dependencies: > Dependency "jboss.messaging:service=ServerPeer" (should be in > state "Create", but is actually in state "Configured") > Dependency "jboss.messaging:service=PostOffice" (should be in > state "Create", but is actually in state "Configured") > Deployment "jboss.messaging:service=JMSUserManager" is missing the > following dependencies: > Dependency "jboss.jca:name=DefaultDS,service=DataSourceBinding" > (should be in state "Create", but is actually in state "** NOT FOUND > Depends on 'jboss.jca:name=DefaultDS,service=DataSourceBinding' **") > Deployment "jboss.messaging:service=PersistenceManager" is missing > the following dependencies: > Dependency
[rules-users] Error deploy Guvnor - DEPLOYMENTS MISSING DEPENDENCIES
Hi all, I am trying to deployed Guvnor (5.0 and 5.1) in Jboss 6.0 using Windows 7 I edited WEB-INF/components.xml to change the directory to uncoment the properties C:/my-path org.drools.repository.JackrabbitRepositoryConfigurator Then I created a folder in default/deploy in Jboss and copy all the content to there. I am getting the exception below Could someone please assist? There are something else I need to do except to edit components.xml? I have also tested the deploy with the war file without sucess. TIA 2010-04-23 10:17:44,761 INFO [org.jboss.system.server.profileservice.ProfileServiceBootstrap] (Thread-2) Loading profile: profile...@2c842c[domain=default, server=default, name=default] 2010-04-23 10:17:44,777 ERROR [org.jboss.system.server.profileservice.ProfileServiceBootstrap] (Thread-2) Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS): DEPLOYMENTS MISSING DEPENDENCIES: Deployment "JBossTimerServiceFactory" is missing the following dependencies: Dependency "jboss.ejb:service=EJBTimerService" (should be in state "Create", but is actually in state "Configured") Deployment "jboss.ejb:persistencePolicy=database,service=EJBTimerService" is missing the following dependencies: Dependency "jboss.jca:name=DefaultDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=DefaultDS,service=DataSourceBinding' **") Dependency "jboss.jdbc:datasource=DefaultDS,service=metadata" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jdbc:datasource=DefaultDS,service=metadata' **") Deployment "jboss.ejb:service=EJBTimerService" is missing the following dependencies: Dependency "jboss.ejb:persistencePolicy=database,service=EJBTimerService" (should be in state "Create", but is actually in state "Configured") Deployment "jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory" is missing the following dependencies: Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured") Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured") Dependency "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" (should be in state "Create", but is actually in state "Configured") Deployment "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" is missing the following dependencies: Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured") Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured") Deployment "jboss.messaging.connectionfactory:service=ConnectionFactory" is missing the following dependencies: Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured") Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured") Deployment "jboss.messaging.destination:name=DLQ,service=Queue" is missing the following dependencies: Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured") Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured") Deployment "jboss.messaging.destination:name=ExpiryQueue,service=Queue" is missing the following dependencies: Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured") Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured") Deployment "jboss.messaging:service=JMSUserManager" is missing the following dependencies: Dependency "jboss.jca:name=DefaultDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=DefaultDS,service=DataSourceBinding' **") Deployment "jboss.messaging:service=PersistenceManager" is missing the following dependencies: Dependency "jboss.jca:name=DefaultDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=DefaultDS,service=DataSourceBinding' **") Deployment "jboss.messaging:service=PostOffice" is missing the following dependencies: Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured") Dependency "jboss.jca:name=DefaultDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=DefaultDS,service=DataSourceBinding' **") Deployment "jboss.messaging:service=ServerPeer" is missing the following depend
[rules-users] Drools Expert (Rule Engine) - Performance Tips
Hi all, I need to perform a test in the Drools Rule Engine. This test is intended to discover the SLA for Rule Processing. The scenario that I have is: - My Knowledge Database will have almost 200 million records. - There will be a full monthly charge and a short diary charge in this KD. - The Rules are not so complex. (6 or 7 levels at most) How can I perform this test? Could you please give me some advices? Another question: How Drools integrate with the Knowledge Database assuming this is already created? (Actually this KD will be created using a ETL process) Thanks for your support, any advice will be appreciated. = ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
