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"............



<blockquote class="quote light-black dark-border-color"><div class="quote light-border-color">
<div class="quote-author" style="font-weight: bold;">JunckyUser wrote:</div>
<div class="quote-message">
Hi,

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

Thanks in Advance...




<blockquote class="quote light-black dark-border-color"><div class="quote light-border-color">
<div class="quote-author" style="font-weight: bold;">Cristiano Gavião wrote:</div>
<div class="quote-message">
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 ...");

                <properties>
                        <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" />
                        <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver" />
                        <property name="hibernate.connection.url" value="jdbc:mysql:// 
localhost/drools" />
                        <property name="hibernate.connection.username" value="root" />
                        <property name="hibernate.connection.password" value="" />
                        <property name="hibernate.connection.autocommit" value="false" />
                        <property name="hibernate.max_fetch_depth" value="3" />
                        <property name="hibernate.hbm2ddl.auto" value="create-drop" />
                        <property name="hibernate.show_sql" value="true" />
                </properties>


After some investigation I could see that the example recommended by  
Mark Proctor (TaskLifeCycleTest.java, and others that use  
MinaTaskServer) use <persistence-unit name="org.drools.task"> 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.<init>(TaskService.java:84)
        at org.drools.task.service.TaskService.<init>(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@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

</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">MySQL / Postgres With Human Task Process Sample</a><br>
Sent from the <a href="http://www.nabble.com/drools---user-f11823.html">drools - user mailing list archive</a> at Nabble.com.<br>