Re: [rules-users] MySQL / Postgres With Human Task Process Sample

Take it easy man... I have here Drools Flow running with PostgreSQL I will try to package the project and then publish it in my blog.. I will send you the link when it's ready.. 2009/7/24 JunckyUser <rafiuddin.mk(a)gmail.com&gt; > I Don't think Drools Flow is used by this user-list group. I am searching > at wrong place. Can any one help me in getting a "link or sample on MySQL > or > Postgress with Human Task process"............ > > JunckyUser wrote: > Hi, New to Drools, can any one provide a link or sample > on...<http://www.nabble.com/user/SendEmail.jtp?type=post&post=2463... > Human Task process. Cristiano Gavião have you able to solve your > issues mentioned in this thread. Thanks in Advance... > > Cristiano Gavião wrote: > Hi, I was trying to change the persistence settings for human task > process > server for using MySQL instead of H2DB. I was following the Drools Flows > Documentation on chapter 5.1.3.: Configuring Persistence.( > https://hudson.jboss.org/hudson/job/drools/lastSuccessfulBuild/artifact/t...) > I read on docs that I should override the persistence.xml of the > drools-process-enterprise.jar, create the drools.session.conf with some > contents (i don`t undestand` what it is...) and put them on my project > META-INF directory... ok? I created the files as stated on docs but it > didn't work... My example runned ok, but using the H2DB and not my MYSQL. > // > Use persistence.xml configuration emf = > Persistence.createEntityManagerFactory("org.drools.persistence.jpa"); > taskService = new TaskService(emf); taskSession = > taskService.createSession(); server = new MinaTaskServer(taskService); > Thread thread = new Thread(server); thread.start(); Thread.sleep(500); > System.out.println("Server started ..."); After some investigation I > could > see that the example recommended by Mark Proctor (TaskLifeCycleTest.java, > and others that use MinaTaskServer) use that is setting on > drools-process-task.jar and not the "org.drools.persistence.jpa" on > drools-process-enterprise.jar as stated on documentation... First > question, > which one should I use for use the Drools Flows Server and Client? emf = > Persistence.createEntityManagerFactory( "org.drools.task" ); emf = > Persistence.createEntityManagerFactory("org.drools.persistence.jpa"); I > test > the first option. I changed the persistence.xml file and use the code > below: > // Use persistence.xml configuration emf = > Persistence.createEntityManagerFactory("org.drools.task"); taskService = > new > TaskService(emf); taskSession = taskService.createSession(); server = new > MinaTaskServer(taskService); Thread thread = new Thread(server); > thread.start(); Thread.sleep(500); System.out.println("Server started > ..."); > Hummm.... It runs and connect well to my MySQL. but now it brings me a > error... java.lang.IllegalArgumentException: Named query not found: > UnescalatedDeadlines at org .hibernate .ejb .AbstractEntityManagerImpl > .createNamedQuery(AbstractEntityManagerImpl.java:108) at > org.drools.task.service.TaskService.(TaskService.java:84) at > org.drools.task.service.TaskService.(TaskService.java:68) It sounds like > it > was not possible to find orm.xml that is on META-INF of > drools-process-task.jar. But when I copy the orm.xml file to my project > META-INF it works ok.... Could someone give some ideas how can I solve > this > problem.. Thanks a lot Cristiano > _______________________________________________ rules-users mailing list > rules-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > > > ------------------------------ > View this message in context: MySQL / Postgres With Human Task Process > Sample<http://www.nabble.com/Problems-setting-MySQL-for-the-human-task... > Sent from the drools - user mailing list > archive<http://www.nabble.com/drools---user-f11823.html>at Nabble.com. > > _______________________________________________ > 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