Thanks, @Sergey, for chiming in. Yes, @Stargate, there will also be a @Transactional example in addition to the existing example where transactions are handled explicitly.
Cheers Lukas 2014/1/3 Sergey Epik <[email protected]> > 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. > -- 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.
