How to test @Transactional method, where two table are getting updated

Question

I am trying to write a unit test for a method which uses: @Transactional. There are two methods are being called, each is running an update query on two table, if one fails other should not run or rollback.

I need to write a unit test to check if the transactional is working fine or not.

Please assist. Thanks in advance.

Why? You don't trust the over 10000 tests the spring framework has for ensuring this? — M. Deinum, Jun 03 '19 at 09:04
@M.Deinum I need to write a unit test case to ensure code coverage as well — Nitin Kumar, Jun 03 '19 at 09:09
And coverage isn't added when you just add a test which does the happy case? Adding an additional one testing the same code path (but for an exception) doesn't add any percentage to your coverage. — M. Deinum, Jun 03 '19 at 09:11
Thats right! written a happy case, my manager asked me to write a unit test to ensure @Transactional also working. Can you please help me to ensure thats working. — Nitin Kumar, Jun 03 '19 at 09:15

score 0 · Answer 1 · answered Jun 03 '19 at 09:46

0

mock second call throw exception close transaction check if data was removed

answered Jun 03 '19 at 09:46

MarcinL

130
1
6

score 0 · Answer 2 · answered Jun 03 '19 at 13:17

testing the failure condition is not a bad thing, in fact it's something that should be done.

I would do integration tests for this, because you want to check a real database to see if the failure is rolled back as expected.

You have two tests :

first update fails, everything should stop and second update should not run.
first update works, second fails, so first update should be rolled back.

If you want unit tests, then use an in-memory database for example.

You don't say which database you are using, but typically you can check if an update succeeds as an update statement will tell you how many rows have been changed. If you get zero, or there is something wrong with the update statement and you get an error message, then you know you need to stop

How to test @Transactional method, where two table are getting updated

2 Answers2