Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for lazy connections in R2DBC in the same manner as LazyConnectionDataSourceProxy #33897

Open
cloudshiftchris opened this issue Nov 15, 2024 · 0 comments
Labels
status: waiting-for-triage An issue we've not yet triaged or decided on

Comments

@cloudshiftchris
Copy link

Support lazy connections in R2DBC following the same concepts in LazyConnectionDataSourceProxy for JDBC.

atm hitting an "empty" transaction (the calls are cached so no actual database operations are performed) still borrows a connection from the pool, starts the connection and commits the transaction.

2024-11-15T14:15:16.436-08:00 DEBUG 8774 [atcher-worker-9] io.r2dbc.mssql.QUERY                     : Executing query: SELECT 1
2024-11-15T14:15:16.447-08:00 DEBUG 8774 [actor-tcp-nio-5] io.r2dbc.mssql.QUERY                     : Executing query: BEGIN TRANSACTION ****;
2024-11-15T14:15:16.449-08:00 DEBUG 8774 [actor-tcp-nio-5] io.r2dbc.mssql.QUERY                     : Executing query: IF @@TRANCOUNT > 0 COMMIT TRANSACTION;

(the SELECT 1 is the connection pool validation query)

@spring-projects-issues spring-projects-issues added the status: waiting-for-triage An issue we've not yet triaged or decided on label Nov 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
status: waiting-for-triage An issue we've not yet triaged or decided on
Projects
None yet
Development

No branches or pull requests

2 participants