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

[Al ITF]

Did anyone resolve this?
I've stumbled across the same issue trying to get "org.drools.task" working
with MS SqlServer.



Mauricio Salatino wrote:
> 
> 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 at gmail.com>
> 
>> 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=24639830&i=0>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: MySQL / Postgres With Human Task Process
>> Sample<http://www.nabble.com/Problems-setting-MySQL-for-the-human-task-process-server....-tp21769805p24639830.html>
>> 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 at 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 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....-tp21769805p25381781.html
Sent from the drools - user mailing list archive at Nabble.com.