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

[JunckyUser]

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 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/lastSuccessfulBuild/artifact/trunk/target/docs/drools-flow/html_single/index.html 
>> #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 at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/rules-users
>> 
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Problems-setting-MySQL-for-the-human-task-process-server....-tp21769805p24639830.html
Sent from the drools - user mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20090724/5c9c4f49/attachment.html