How many jdbc connection can be used in one spring transaction?

Question

Suppose there are following components which are configured all together:

jdbc connection pool
DataSource
Dao

Suppose there is method which is marked with @org.springframework.transaction.annotation.Transactional and contains several dao methods calls. Do all these dao methods use the same connection during transaction or not?

score 0 · Answer 1 · edited May 23 '17 at 10:31

0

If they all have the same Datasource, and you are only using Spring to create and manage your transactions, then yes.

Reason: because of isolation and propagation behaviour see: Spring @Transactional - isolation, propagation, there will only be one transaction which all the DAO methods use. And there is only one connection used per a transaction in JDBC.

edited May 23 '17 at 10:31

Community

1
1

answered May 08 '17 at 04:24

Derrops

7,651
5
30
60

Could you provide any proof? – Cherry May 08 '17 at 04:25
The connection itself is what is providing the transaction behaviour: https://docs.oracle.com/javase/tutorial/jdbc/basics/transactions.html – Derrops May 08 '17 at 04:43

How many jdbc connection can be used in one spring transaction?

1 Answers1