Hello Stargate,
We use jooq 3.x in several spring projects without any problems with
transaction handling.
1. If you use @Transactional annotation, make sure that you declare
<tx:annotation-driven transaction-manager="transactionManager"/>
in your spring application context.
See details in
http://docs.spring.io/spring/docs/3.2.x/spring-framework-reference/html/transaction.html#transaction-declarative-annotations
Spring automatically wires your service with
org.springframework.transaction.interceptor.TransactionInterceptor (see
details in javadoc). You can see this interceptor in stacktrace if you stop
debugger in "transactional" method.
2. Make sure that jooq uses transaction aware datasource (from the sample ):
<bean id="transactionAwareDataSource"
class="org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy">
<constructor-arg ref="dataSource" />
</bean>
<bean class="org.jooq.impl.DataSourceConnectionProvider"
name="connectionProvider">
<constructor-arg ref="transactionAwareDataSource" />
</bean>
On Fri, Jan 3, 2014 at 11:03 AM, Stargate <[email protected]> wrote:
> Hi,
>
> thx for your help, but will this tutorial show how i get the
> @Transactional Annotation work with Jooq ? I use a postgresql DB and no
> InnoDB +Mysql Like in the other Thread.
> At the moment i try to create a little project with my implementation that
> i can send to you.
>
> Best regards
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
