Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can a single client have multiple concurrent transactions active within a single connection to the database?

April 26, 2017active client concurrent connection database transactions

0

0 Posted

Can a single client have multiple concurrent transactions active within a single connection to the database?

1 Answer

0

0 Posted

No, a database connection can only have one transaction active at a time. However, nested transactions within another transaction are supported in SQL/ODBC applications with the SavePoint and Rollback to SavePoint syntax.