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

Hi, New to Drools, can any one provide a link or sample ondrools... MySQL 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/lastSuccessfulBui... > #d0e1157) > > 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 > >