Using AbstractTransactionalJUnit4SpringContextTests with commit halfway through

Question

We want a simple unit test that runs multiple threads - the idea is that the main thread commits a save to the database, then waits for a secondary thread to pick it up. We're finding that the transaction has to be committed for the second Thread to be able to query the database and find the item. Otherwise, it won't exist. We're trying to accomplish this using an H2 database, Hibernate to manage the access, and the unit test extends `AbstractTransactionalJUnit4SpringContextTests`. When we try to `commit()` the existing transaction: ``` ... // Create and save our model object sessionFactory.getCurrentSession().getTransaction().commit(); sessionFactory.getCurrentSession().beginTransaction(); ... // Create and start second Thread, query, etc. ``` We receive the error: ``` org.springframework.transaction.TransactionSystemException: Could not commit Hibernate transaction; nested exception is org.hibernate.TransactionException: Transaction not successfully started at org.springframework.or…

Accepted Answer

So, you need to create multiple transactions inside your test method. As you can see, you cannot use `AbstractTransactionalJUnit4SpringContextTests`, because it creates a single transaction for the whole test method, and cannot use bare `AbstractJUnit4SpringContextTests`, because it creates no transactions at all.

The solution is to use `AbstractJUnit4SpringContextTests` and manage transactions inside your test method programmatically.

You need to inject `PlatformTransactionManager` into your test, create `TransactionTemplate` from it and use it to demarcate your transactions as described in 11.6 Programmatic transaction management.

Using AbstractTransactionalJUnit4SpringContextTests with commit halfway through

Solution

Problem