[fpc-devel] MSSQL doesn't commit 2nd transaction

[Michael Van Canneyt]

On Mon, 18 Jun 2018, LacaK wrote:

>
>
>>
>> Is this a bug in fpc-db or is this some kind of MSSQL feature? Does it 
>> mean I cannot use multiple transactions with one MSSQL connection?
>
> AFAIK MS SQL Server does not natively supports concept of multiple 
> simultaneous independent transactions per one connection.
> (AFAIK also others RDBMS does not support it with exception of Firebird, 
> which support it)
> So there is question if sqlDB should "simulate"/support it at client 
> side in background by "open new connection per new transaction"
> There was discuusion about it approx. 4 years ago. Michael's position is 
> that this should be supported on client side.

Indeed.

We already do this for MySQL and Postgres (which also do not support
multiple transactions). There is no reason why MS SQL should be an 
exception. So if the current implementation does not support this, 
we must check why this is so.

Michael.