sql的操作是如何绑定到特定事务的
Open
Nobody has claimed this yet.
type/question
- Dominant language
- Python
- Stars
- 1.8k
- Forks
- 1.2k
- Avg merge
- 1d 16h
- Merged PRs (30d)
- 31
Description
File: /release-7.1/optimistic-transaction.md
场景: 显示声明事务后，sql的执行正常都是在同个事务内进行的。针对使用数据库连接池的场景下(java)，如果存在连接被复用了，会不会导致当前sql的执行绑定到了错误的事务中
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Read release-7.1/optimistic-transaction.md, especially the section on explicit transactions, and verify how transaction context is associated with SQL execution when Java connection pools reuse connections. Confirm the behavior and update the documentation to explain whether reuse can bind a statement to the wrong transaction, including the relevant usage conditions.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases, documentation
- Issue type
- Documentation
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100