transactions in spring jdbc

by: radsaPosted on 2009-10-30 at 08:22:44ID: 25703862

This is what i have right now, but it is not working as a transaction.
while executing the second insert, a foreign key is violated and the exception is thrown. But the first insert is done. But i expected the first insert to be rolled back. What is wrong in the code. Any input is appreciated. I also tried the annotation @Transaction, but still the same result.

In the application context.xml
 
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 
<property name="dataSource" ref="dataSource"/> 
</bean> 
 
 
  <bean id="DatabaseImpl" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
    <property name="transactionManager" ref="transactionManager"/>
    <property name="target" ref="DatabaseImplTarget"/>
    <property name="proxyTargetClass" value="true"/>
    <property name="transactionAttributes">
      <props>
        <prop key="*">PROPAGATION_REQUIRED,-Exception</prop>
        <prop key="get*">PROPAGATION_SUPPORTS</prop>
      </props>
    </property>
  </bean>
 
inside the DatabaseImpl,
 
public class DatabaseImpl extends JdbcDaoSupport {
 
	private DriverManagerDataSource dataSource;
	
	public void setDataSource(DriverManagerDataSource datasource)
	{
		dataSource = datasource;
	}
	
 
	public void modifyItem() throws Exception{
			JdbcTemplate update = new JdbcTemplate(dataSource);
			update.update("insert into configuration(config_id, config_name) values (?,?)",
					new Object[] {18,"department2"});
			update.update("insert into con_detail(config_id, test_id, val_on_off_flag)" +
					" values(?,?,?)",
					new Object[] {18,55,"OFF"});
			update.update("insert into con_detail(config_id, test_id, val_on_off_flag)" +
					" values(?,?,?)",
					new Object[] {19,2,"OFF"});
	}

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:

Select all Open in new window

by: dravidnsrPosted on 2009-10-30 at 09:52:30ID: 25704790

http://static.springsource.org/spring/docs/2.0.8/reference/jdbc.html

http://www.vogella.de/articles/SpringJDBC/article.html

This 2 link help u... for jdbctemplate and spring...

by: dravidnsrPosted on 2009-10-30 at 09:54:48ID: 25704814

if u know more details let me know ...

i think above 2 link give u the correct path ...

by: radsaPosted on 2009-10-30 at 10:43:59ID: 25705247

Thanks,

I solved it using the programatic way,

my appcontext is,
 
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 
<property name="dataSource" ref="dataSource"/> 
</bean> 
 
 
<bean id="DatabaseImpl" class="com.comp.proj.dao.DatabaseImpl">
    <property name="dataSource" ref="dataSource"/>
    <property name="transactionManager" ref="transactionManager"/>
  </bean>
 
my dao method is,
	public void modifyItem() throws DataAccessException {
	    TransactionTemplate tt = new TransactionTemplate();
	    tt.setTransactionManager(new DataSourceTransactionManager(dataSource));
	    tt.setPropagationBehavior(DefaultTransactionDefinition.PROPAGATION_REQUIRED);
	    tt.execute(new TransactionCallbackWithoutResult() {
            protected void doInTransactionWithoutResult(TransactionStatus status) {
            	JdbcTemplate jt = new JdbcTemplate(dataSource);
        	    jt.update("insert into configuration(config_id, config_name) values (?,?)",
    					new Object[] {19,"department3"});
        	    jt.update("insert into config_detail(config_id, test_id, val_on_off_flag)" +
    					" values(?,?,?)",
    					new Object[] {19,2,"OFF"});
            }
	    });
	}

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:

Select all Open in new window

by: radsaPosted on 2009-10-30 at 10:44:47ID: 25705253

I would still like to know if i could solve it the declarative way, which i previously posted. But for some reason that is not working.

by: dravidnsrPosted on 2009-10-30 at 10:52:12ID: 25705312

Thats gd...

by: yazubetsPosted on 2009-10-30 at 13:36:42ID: 25706591

Hi,

The format of transactionAttributes is:

PROPAGATION_NAME,ISOLATION_NAME,readOnly,timeout_NNNN,+Exception1,-Exception2

Note that the only mandatory portion of the string is the propagation setting. The default transactions semantics which apply are as follows:
* Exception Handling: RuntimeExceptions roll-back, normal (checked) Exceptions dont
* Transactions are read/write
* Isolation Level: TransactionDefinition.ISOLATION_DEFAULT
* Timeout: TransactionDefinition.TIMEOUT_DEFAULT

Not sure, but maybe you are handling checking exception?

by: dravidnsrPosted on 2009-11-03 at 21:27:38ID: 25736654

do u want to know y its going wrong ??

by: radsaPosted on 2009-11-07 at 00:13:05ID: 25765418

yes

by: dravidnsrPosted on 2009-11-07 at 01:07:44ID: 25765517

The DataSourceTransactionManager class is a PlatformTransactionManager implementation for single JDBC datasources. It binds a JDBC connection from the specified data source to the currently executing thread, potentially allowing for one thread connection per data source.

Application code is required to retrieve the JDBC connection via DataSourceUtils.getConnection(DataSource) instead of J2EE's standard DataSource.getConnection. This is recommended anyway, as it throws unchecked org.springframework.dao exceptions instead of checked SQLExceptions. All framework classes like JdbcTemplate use this strategy implicitly. If not used with this transaction manager, the lookup strategy behaves exactly like the common one - it can thus be used in any case.

The DataSourceTransactionManager class supports custom isolation levels, and timeouts that get applied as appropriate JDBC statement query timeouts. To support the latter, application code must either use JdbcTemplate or call DataSourceUtils.applyTransactionTimeout(..) method for each created statement.

Question

transactions in spring jdbc

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

Spring

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Need individual assistance?

Our experts are ready to help.

Want to learn from the best?

Read articles from industry experts.

Working on a long term project?

Store your work and research.

What Makes Experts Exchange Unique?

Trusted by the world's most respected brands.

Faithfully serving IT professionals since 1996.

Related Solutions

Free Tech Articles

Cloud Class Webinars

Join the Community

Give a Little. Get a Lot.

Answers

3 Ways to Join

The Experts

The Experts

Testimonials

Testimonials

Testimonials

Business Clients

Business Clients

In the Press

In the Press

In the Press