Need Example Transaction handling in Spring 3

Question

I need step by step guide to handle transactions in spring sqltemplate. Transaction handling has to be implemented in my project. Guide me. Need to use the transaction Managment with SqlTemplate.

What is SqlTemplate? Do you mean Cayenne? If so here's an article on that: https://cwiki.apache.org/CAY/spring-integration-examples.html — Dan, May 02 '11 at 01:03

score 1 · Answer 1 · edited May 23 '17 at 11:55

1

I suggest you use @Transaction annotation than code it manually. You may follow example here. For its best practice, you may read here. If you plan to spend few hours to study Spring Data JPA, you almost no need to handle transaction manually for most cases.

Thanks.

edited May 23 '17 at 11:55

Community

1
1

answered May 02 '11 at 00:52

Lee Chee Kiam

11,450
10
65
87

score 0 · Answer 2 · answered Sep 15 '13 at 14:40

if you are using Programmatic Transactions then use below

<bean id="transactionManager"   class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
    <ref local="dataSource"/>
</property>
</bean>

Programmatic means you have transaction management code surrounding your business code. This gives extreme flexibility, but is difficult to maintain. Declarative means you separate transaction management from the business code. You can use annotations or XML based configuration.

Declarative Transaction Management allows to eliminate any dependencies on the transaction framework from the Java code. The four participants to provide the transaction support are transaction manager, proxy factory, transaction interceptor, and a set of transaction attributes. below is an example

<bean id="boxOffice" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager"><ref bean="transactionManager"/></property>
<property name="target">
    <ref bean="boxOfficeService"/>
</property>
<property name="transactionAttributes">
    <props>
        <prop key="get*">PROPAGATION_SUPPORTS,readOnly</prop>
        <prop key="allocate*">PROPAGATION_REQUIRED</prop>
    </props>
</property>
</bean>

Need Example Transaction handling in Spring 3

2 Answers2