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&#39;s ready..<br><br><div class="gmail_quote">2009/7/24 JunckyUser <span dir="ltr">&lt;<a href="http://rafiuddin.mk">rafiuddin.mk</a>@<a href="http://gmail.com">gmail.com</a>&gt;</span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I Don&#39;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 &quot;link or sample on MySQL or Postgress with Human Task process&quot;............



<blockquote><div>
<div style="font-weight: bold;">JunckyUser wrote:</div>
<div>
Hi,

New to Drools, can any one provide a link or sample on<a href="http://www.nabble.com/user/SendEmail.jtp?type=post&amp;post=24639830&amp;i=0" rel="nofollow" target="_blank">...</a> MySQL Human Task process. Cristiano Gavião have you able to solve your issues mentioned in this thread.

Thanks in Advance...




<blockquote><div>
<div style="font-weight: bold;">Cristiano Gavião wrote:</div>
<div>
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 <a href="http://5.1.3." target="_blank">5.1.3.</a>:  
Configuring Persistence.(<a href="https://hudson.jboss.org/hudson/job/drools/lastSuccessfulBuild/artifact/trunk/target/docs/drools-flow/html_single/index.html" target="_blank">https://hudson.jboss.org/hudson/job/drools/lastSuccessfulBuild/artifact/trunk/target/docs/drools-flow/html_single/index.html</a> 
#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&#39;t work...  My  
example runned ok, but using the H2DB and not my MYSQL.

                // Use persistence.xml configuration
                emf =  
Persistence.createEntityManagerFactory(&quot;org.drools.persistence.jpa&quot;);
                taskService = new TaskService(emf);
                taskSession = taskService.createSession();
                server = new MinaTaskServer(taskService);
                Thread thread = new Thread(server);
                thread.start();
                Thread.sleep(500);
                System.out.println(&quot;Server started ...&quot;);

                
                        
                        
                        
                        
                        
                        
                        
                        
                        
                


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  
&quot;org.drools.persistence.jpa&quot; 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( &quot;org.drools.task&quot; );

        emf =  
Persistence.createEntityManagerFactory(&quot;org.drools.persistence.jpa&quot;);


I test the first option. I changed the persistence.xml file and use  
the code below:

                // Use persistence.xml configuration
                emf = Persistence.createEntityManagerFactory(&quot;org.drools.task&quot;);
                taskService = new TaskService(emf);
                taskSession = taskService.createSession();
                server = new MinaTaskServer(taskService);
                Thread thread = new Thread(server);
                thread.start();
                Thread.sleep(500);
                System.out.println(&quot;Server started ...&quot;);



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
<a href="mailto:rules-users@lists.jboss.org" target="_blank">rules-users@lists.jboss.org</a>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a>

</div>
</div></blockquote>


</div>
</div></blockquote>


<br><hr align="left" width="300">
View this message in context: <a href="http://www.nabble.com/Problems-setting-MySQL-for-the-human-task-process-server....-tp21769805p24639830.html" target="_blank">MySQL / Postgres With Human Task Process Sample</a><br>
Sent from the <a href="http://www.nabble.com/drools---user-f11823.html" target="_blank">drools - user mailing list archive</a> at Nabble.com.<br>
<br>_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br> - <a href="http://salaboy.wordpress.com">http://salaboy.wordpress.com</a><br> - <a href="http://www.jbug.com.ar">http://www.jbug.com.ar</a><br> - Salatino &quot;Salaboy&quot; Mauricio -<br>