topic Java service task, JavaDelegate JPA in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/java-service-task-javadelegate-jpa/m-p/186356#M139486 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I couldn't find information about how to create a JPA entity in Java ServiceTask. I can do it before starting the process by adding it as a process variable:</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE>ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("myProcess", variables);<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Well I want activiti to manage the creation of entities when in ServiceTasks, how can I achieve that, I'm not using spring (or am i? ), just JPA.</SPAN><BR /><BR /><SPAN>my persistence.xml:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR />&lt;persistence version="2.0" xmlns="<A href="http://java.sun.com/xml/ns/persistence" rel="nofollow noopener noreferrer">http://java.sun.com/xml/ns/persistence</A>" xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xsi:schemaLocation="<A href="http://java.sun.com/xml/ns/persistence" rel="nofollow noopener noreferrer">http://java.sun.com/xml/ns/persistence</A> <A href="http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd" rel="nofollow noopener noreferrer">http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd</A>"&gt;<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&lt;persistence-unit name="DAO"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;provider&gt;org.hibernate.ejb.HibernatePersistence&lt;/provider&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;…my classes…<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;properties&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/orderbase" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="hibernate.connection.username" value="user" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="hibernate.connection.password" value="pwd1" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="hibernate.hbm2ddl.auto" value="update" /&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/properties&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&lt;/persistence-unit&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&lt;/persistence&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I configure my process Engine like this:</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />ProcessEngineConfigurationImpl pEC = (ProcessEngineConfigurationImpl) ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pEC.setJpaPersistenceUnitName("DAO")<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setJpaHandleTransaction(true)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setDatabaseSchemaUpdate("false")<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setJdbcDriver("com.mysql.jdbc.Driver")<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setJdbcUrl("jdbc:mysql://localhost:3306/activiti")<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setJobExecutorActivate(false)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setJdbcUsername("user")<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setJdbcPassword("pwd");&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;processEngine = pEC.buildProcessEngine();<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I get entityManager like this:</SPAN><BR /><PRE class="language-java line-numbers"><CODE><BR />EntityManagerSessionFactory entityManagerSessionFactory = (EntityManagerSessionFactory) pEC<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .getSessionFactories()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .get(EntityManagerSession.class);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;entityManagerFactory = entityManagerSessionFactory.getEntityManagerFactory();<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>And I can persist the entity:</SPAN><BR /><PRE class="language-java line-numbers"><CODE><BR /> EntityManager manager = entityManagerFactory.createEntityManager();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; manager.getTransaction().begin();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Order newOrder=new Order();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />…doing stuff here order related….<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;manager.persist(newOrder);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;manager.flush();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;manager.getTransaction().commit();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;manager.close();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.put("order", newOrder);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("myProcess", variables);<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>And it works perfectly, I can retrieve the order throughout the process, every change in ServiceTasks persists it to Database(not the same as activiti).</SPAN><BR /><BR /><SPAN>But, there's always a but <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /> I want to start the process by MessageStartEvent, so I will need the ServiceTask to create an entity that gets persisted into db. Can it be achieved in some way? I've tried the Activiti in Action book as well as the Activiti documentation, but I can't seem to find such example.</SPAN><BR /><BR /><SPAN>Example Java ServiceTask Delegate:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />public class ServiceTaskNewOrder implements JavaDelegate{<BR /><BR />&nbsp;&nbsp;&nbsp;@Override<BR />&nbsp;&nbsp;&nbsp;public void execute(DelegateExecution execution) throws Exception {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //this works ok, but how can I create here an entity that will be stored into my second not-activiti database?<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Order o = (Order) execution.getVariable("order");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;}<BR />}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>If it can't be done with this configuration then I'm open for any advice how to do it in xml.</SPAN><BR /><BR /><SPAN>Please forgive me if it is somewhere in documentation or the forums.</SPAN><BR /><BR /><SPAN>Many thanks for any help. I've started with activiti just few days ago, but I can't resolve this step <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></SPAN></BODY></HTML> Wed, 11 Jun 2014 15:41:07 GMT nexowski 2014-06-11T15:41:07Z Java service task, JavaDelegate JPA https://connect.hyland.com/t5/alfresco-archive/java-service-task-javadelegate-jpa/m-p/186356#M139486 Hi,I couldn't find information about how to create a JPA entity in Java ServiceTask. I can do it before starting the process by adding it as a process variable<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />rocessInstance processInstance = runtimeService.startProcessInstanceByKey("myProcess", variables);‍Well I want activiti to manage the creat Wed, 11 Jun 2014 15:41:07 GMT https://connect.hyland.com/t5/alfresco-archive/java-service-task-javadelegate-jpa/m-p/186356#M139486 nexowski 2014-06-11T15:41:07Z Re: Java service task, JavaDelegate JPA https://connect.hyland.com/t5/alfresco-archive/java-service-task-javadelegate-jpa/m-p/186357#M139487 <HTML><HEAD></HEAD><BODY><SPAN>Can't you simply do the same in the service task: get the entity manager and do the jpa magic? Or am I missing something here?</SPAN></BODY></HTML> Tue, 17 Jun 2014 10:25:49 GMT https://connect.hyland.com/t5/alfresco-archive/java-service-task-javadelegate-jpa/m-p/186357#M139487 jbarrez 2014-06-17T10:25:49Z Re: Java service task, JavaDelegate JPA https://connect.hyland.com/t5/alfresco-archive/java-service-task-javadelegate-jpa/m-p/186358#M139488 <HTML><HEAD></HEAD><BODY><SPAN>Ok I've managed with it. Indeed created own classes to handle the database operations (I wanted one and the same EntityManager). Working now ith REST api and found another problem which I'll post in a while. This topic can be deleted I think it does not give any information.</SPAN></BODY></HTML> Fri, 20 Jun 2014 13:11:05 GMT https://connect.hyland.com/t5/alfresco-archive/java-service-task-javadelegate-jpa/m-p/186358#M139488 nexowski 2014-06-20T13:11:05Z