COMMIT is not working

[vasanthan297]

Hi ,
I am using jbossts for my transaction. I have only one datasourse :
In my code:

TransactionManager transactionManager = trxManager.getTransactionManager();
transactionManager.begin();
long i = jDBCDBHandler.readValue();
System.out.println("read i " + i);
i++;
jDBCDBHandler.updateValue(i);
System.out.println("Updated i : " + i);
transactionManager.rollback();

Even I am calling the rollback. My values are commited to the database.

Would you please any body help me

My Spring-Config is :


com.mysql.jdbc.Driver


jdbc:mysql://localhost:3306/TEST


user


password

<!-- configuration pool via c3p0-->

5


100

<!-- seconds -->

100


10


5


100



30


10000


true

[marklittle]

You're using JBossTS with Spring?

[vasanthan297]

Yes I am using JbossTS with Spring.

[marklittle]

At this time we haven't tried JBossTS within Spring. However, it would seem that your connectionisn't known to the transaction manager and hence all work you're doing on it (through to MySQL) is happening immediately (i.e., autocommit is still true). If the TM knew about your connection then it would turn autocommit off and explicitly call commit (or rollback) when the transaction terminates.

You may find http://www.javaworld.com/javaworld/jw-04-2007/jw-04-xa.html?page=1 useful.