TPQConnection connection handling - in transaction
Original Reporter info from Mantis: desmondc
-
Reporter name: Desmond C
Original Reporter info from Mantis: desmondc
- Reporter name: Desmond C
Description:
When closing TSQLTransaction, the connection spawned on the pgsql srv to run the orignal query is disconnected. When a new query is exec'ed, a new connection is spawned again.
When doing a large amount of transactions in a short time, this will keep the pgsql srv too busy as a process for each connection is spawned and dropped for each query executed
Steps to reproduce:
Set up TPQConnection, TSQLTransaction and TSQLQuery.
Set .Action to caNone (or call .Rollback or set .Active := False) on transaction component after executing query.
The connection on pgsql srv disappears.
Mantis conversion info:
- Mantis ID: 17712
- Build: rc1
- Version: 2.4.0
- Fixed in version: 3.0.0
- Target version: 3.0.0