nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Service Task transaction with database

fernando-sc

Hi,

I'm using a serviceTask to make some rules in my process.
The problem is that I'm trying to do a query on my database (hibernate), I realized that when my serviceTask starts, the activiti opens a transaction and only closes when it is finalized.
I wanted to enjoy the transaction already opened to make the query.

It is possible to do this?

Thanks

Find more posts tagged with

Comments

jbarrez

How do you manage the connection and datasource? If you use Spring for example, it is possible to have hibernate and activiti go against the same database, using the same transaction manager, which would answer your question.

fernando-sc

I'm using Spring in this way:

<tx:annotation-driven transaction-manager="transactionManager" mode="aspectj"/><br><br><task:annotation-driven/><br><br>&nbsp; <bean id="dataSource"<br>&nbsp;&nbsp;&nbsp; class="com.mchange.v2.c3p0.ComboPooledDataSource"><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="driverClass" value="${database.driver}" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="jdbcUrl" value="${database.url}" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="user" value="${database.username}" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="password" value="${database.password}" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="initialPoolSize" value="3" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="minPoolSize" value="1" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="maxPoolSize" value="17" /><br>&nbsp; </bean><br>&hellip;<br><bean id="transactionManager"<br>&nbsp;&nbsp;&nbsp; class="org.springframework.orm.hibernate3.HibernateTransactionManager"><br>&nbsp;&nbsp;&nbsp; <property name="dataSource" ref="dataSource" /><br>&nbsp;&nbsp;&nbsp; <property name="sessionFactory" ref="sessionFactory" /><br>&nbsp; </bean><br>&hellip;<br><bean<br>&nbsp;&nbsp;&nbsp; class="org.springframework.transaction.aspectj.AnnotationTransactionAspect"<br>&nbsp;&nbsp;&nbsp; factory-method="aspectOf"><br>&nbsp;&nbsp;&nbsp; <property name="transactionManager"><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <ref local="transactionManager" /><br>&nbsp;&nbsp;&nbsp; </property><br>&nbsp; </bean><br>&hellip;<br><bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"><br>&nbsp;&nbsp;&nbsp; <property name="databaseType" value="postgres" /><br>&nbsp;&nbsp;&nbsp; <property name="dataSource" ref="dataSource" /><br>&nbsp;&nbsp;&nbsp; <property name="transactionManager" ref="transactionManager" /><br>&nbsp;&nbsp;&nbsp; <property name="history" value="full" /><br>&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; <property name="databaseSchemaUpdate" value="true" /> <br>&nbsp;&nbsp;&nbsp; <property name="jobExecutorActivate" value="true" /><br>&hellip;<br>

Is something wrong in my configuration?

Thank you!

jbarrez

That looks as it should.

How do you do the query in the servicetask? How do you inject the hibernate session in the service task?

fernando-sc

This is my serviceTask:

public class TestServiceTask implements JavaDelegate{<br><br> private VersionDAO versionDAO;<br><br> public TestServiceTask(){<br>&nbsp; versionDAO = new BeanAccessor().getBean(VersionDAO.class);<br> } <br> <br> public void execute(DelegateExecution execution) throws Exception {<br>&nbsp; Version version = versionDAO.loadDistributionVersion("Test");<br>&nbsp;&nbsp;&nbsp; }<br>}

My DAO:

@Transactional<br> public Version loadDistributionVersion(String productName) {<br>&nbsp; return (Version) getCurrentSession().createQuery("" +<br>&nbsp;&nbsp;&nbsp; "from Version as v " +<br>&nbsp;&nbsp;&nbsp; "where v.product.name = :smileytongue:roductName " +<br>&nbsp;&nbsp;&nbsp; "and v.product.distributionVersion.id = v.id")<br>&nbsp;&nbsp;&nbsp; .setParameter("productName", productName)<br>&nbsp;&nbsp;&nbsp; .uniqueResult();<br> }

And my getCurrentSession() which is in GenericDAO:

public GenericDAO{<br>&nbsp;&nbsp; @Autowired<br> private SessionFactory sessionFactory;<br>&hellip;<br><br>&nbsp;&nbsp;&nbsp; protected Session getSession() {<br>&nbsp; return sessionFactory.getCurrentSession();<br> }<br>}

I can't use the @Autowired within ServiceTask, so I use the class BeanAccessor:

@Configurable<br>public class BeanAccessor {<br><br>&nbsp; @Autowired<br>&nbsp; private WebApplicationContext context;<br><br>&nbsp; public <T> T getBean(Class<T> beanClass) {<br>&nbsp;&nbsp;&nbsp; return context.getBean(beanClass);<br>&nbsp; }<br>&nbsp; <br>&nbsp; public <T> Map<String, T> getBeansOfType(Class<T> beanClass) {<br>&nbsp;&nbsp;&nbsp; return context.getBeansOfType(beanClass);<br>&nbsp; }<br>}

Thanks!

jbarrez

****, I was hoping to find something wrong in that setup … but I don't see anything unusual.

So let me get this straight: you are actually seeing two separate transactions going on? If so, could you please file a jira report with some simple test case, cause that stuff should just work.

fernando-sc

Hi jbarrez,

I'm using the changes you've made to the branch, where you fixed the problem(https://jira.codehaus.org/browse/ACT-1386 and http://forums.activiti.org/en/viewtopic.php?f=4&t=4646).

But, I'm still having the same problem using the configuration above.
I have to change the way they work with Spring after these changes?

Thanks.

jbarrez

Well, the issue in the test case you attached on the jira is that you recreate every time the application context, effectively creating a new transaction manager. You need to inject the services in the bean instead, such that only one applicationContext is used.

fernando-sc

Added a new example, now working correctly with the Spring.

https://jira.codehaus.org/browse/ACT-1386

Thank you!

jbarrez

Ok, great to hear it works now! Thanks for following up and attaching your project.

fernando-sc

You got it wrong, the problem still continues, but now, he is injecting the Spring correctly

ops:

jbarrez

Okay, I understood

now working correctly with the Spring

As that it worked now. I'll reopen the issue and check the new code.