<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic TaskList issues after using JPA in service tasks in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/tasklist-issues-after-using-jpa-in-service-tasks/m-p/59392#M36512</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;With JTA and CMP i have transaction issues when i create JPA entities using&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;a EJB looked up via JNDI from within a service task and store this entities as&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;process variables and later reuse them in another service task. Using the&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;entities within the servce task and the EJB is no problem as they are persisted&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;ok, but i have problems getting the task list via the TaskService after i run &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;a process with such service and user tasks. It seems that Activiti is then not &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;able to get a db session:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;org.apache.ibatis.exceptions.PersistenceException: &lt;BR /&gt;### Error opening session.&amp;nbsp; Cause: java.sql.SQLException: Error in allocating a connection. Cause: java.lang.RuntimeException: Got exception during XAResource.start:&lt;BR /&gt;### Cause: java.sql.SQLException: Error in allocating a connection. Cause: java.lang.RuntimeException: Got exception during XAResource.start:&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessionFromDataSource(DefaultSqlSessionFactory.java:81)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSession(DefaultSqlSessionFactory.java:32)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.db.DbSqlSession.&amp;lt;init&amp;gt;(DbSqlSession.java:86)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.db.DbSqlSessionFactory.openSession(DbSqlSessionFactory.java:77)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.interceptor.CommandContext.getSession(CommandContext.java:177)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.persistence.AbstractManager.getSession(AbstractManager.java:56)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.persistence.AbstractManager.getDbSqlSession(AbstractManager.java:52)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.persistence.entity.TaskManager.findTasksByQueryCriteria(TaskManager.java:89)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.TaskQueryImpl.executeList(TaskQueryImpl.java:334)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:138)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.AbstractQuery.list(AbstractQuery.java:112)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at erp.web.faces.beans.activiti.TaskList.getOwnTasks(TaskList.java:62)&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;What can be wrong here in the Activiti configuration? Or maybe somewhere else?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;jee:jndi-lookup jndi-name="jdbc/MysqlErp" id="dataSource" /&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;jee:jndi-lookup jndi-name="java:appserver/TransactionManager" id="transactionManager" /&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;bean id="processEngineConfiguration"&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;class="org.activiti.engine.impl.cfg.JtaProcessEngineConfiguration"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;property name="transactionManager" ref="transactionManager"/&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;property name="transactionsExternallyManaged" value="false" /&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;property name="dataSource" ref="dataSource" /&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;property name="databaseSchemaUpdate" value="true" /&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;property name="databaseType" value="mysql" /&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/bean&amp;gt;&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks in advance&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Chris&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 18 Aug 2011 21:35:22 GMT</pubDate>
    <dc:creator>chris_joelly</dc:creator>
    <dc:date>2011-08-18T21:35:22Z</dc:date>
    <item>
      <title>TaskList issues after using JPA in service tasks</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/tasklist-issues-after-using-jpa-in-service-tasks/m-p/59392#M36512</link>
      <description>Hello,With JTA and CMP i have transaction issues when i create JPA entities usinga EJB looked up via JNDI from within a service task and store this entities asprocess variables and later reuse them in another service task. Using theentities within the servce task and the EJB is no problem as they ar</description>
      <pubDate>Thu, 18 Aug 2011 21:35:22 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/tasklist-issues-after-using-jpa-in-service-tasks/m-p/59392#M36512</guid>
      <dc:creator>chris_joelly</dc:creator>
      <dc:date>2011-08-18T21:35:22Z</dc:date>
    </item>
    <item>
      <title>Re: TaskList issues after using JPA in service tasks</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/tasklist-issues-after-using-jpa-in-service-tasks/m-p/59393#M36513</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;BLOCKQUOTE class="jive-quote"&gt;&amp;lt;property name="transactionsExternallyManaged" value="false" /&amp;gt;&lt;/BLOCKQUOTE&gt;&lt;BR /&gt;&lt;SPAN&gt;Not sure about this one.. When transactions aren't externally managed, activiti will handle it, and close connections as well…&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 24 Aug 2011 08:56:38 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/tasklist-issues-after-using-jpa-in-service-tasks/m-p/59393#M36513</guid>
      <dc:creator>frederikherema1</dc:creator>
      <dc:date>2011-08-24T08:56:38Z</dc:date>
    </item>
    <item>
      <title>Re: TaskList issues after using JPA in service tasks</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/tasklist-issues-after-using-jpa-in-service-tasks/m-p/59394#M36514</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;yes, i tried both, setting it to true and false. and i have the same issue.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;i created a more detailed forum post &lt;/SPAN&gt;&lt;A href="http://forums.activiti.org/en/viewtopic.php?f=6&amp;amp;t=2256" rel="nofollow noopener noreferrer"&gt;here&lt;/A&gt;&lt;SPAN&gt;, which reflects the current&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;state of my problem with transactions.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 24 Aug 2011 18:27:59 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/tasklist-issues-after-using-jpa-in-service-tasks/m-p/59394#M36514</guid>
      <dc:creator>chris_joelly</dc:creator>
      <dc:date>2011-08-24T18:27:59Z</dc:date>
    </item>
  </channel>
</rss>

