Re: [Interest] transaction modes in QtSql

2020-04-14 Thread alexander golks
Am Tue, 14 Apr 2020 09:01:19 +
schrieb Hamish Moffatt :

> Some database engines allow you to set properties of a database 
> transaction, like read only versus read/write, isolation level etc.
> 
> It looks like in Postgres you would use an SQL command line like 'start 
> transaction isolation level repeatable read;'. In Firebird/Interbase, 
> you have to parse some extra parameters to the transaction API (not 
> plain text).
> 
> I don't see any way to access this functionality from Qt though. Am I 
> missing something?

Not sure if it's what you ask, but you cannot use straight sql e.g. via 
QSqlDatabase::exec
  db->exec("SET TRANSACTION ISOLATION LEVEL READ COMMITTED;");
for ms sql server?

alex

-- 
/*
 *  /* if it speaks printer language, it's
 *   * probably a printer *\/
 *linux-2.6.19/drivers/parport/probe.c
 */


pgp33EpSjSYZ0.pgp
Description: Digitale Signatur von OpenPGP
___
Interest mailing list
Interest@qt-project.org
https://lists.qt-project.org/listinfo/interest


[Interest] transaction modes in QtSql

2020-04-14 Thread Hamish Moffatt
Some database engines allow you to set properties of a database 
transaction, like read only versus read/write, isolation level etc.


It looks like in Postgres you would use an SQL command line like 'start 
transaction isolation level repeatable read;'. In Firebird/Interbase, 
you have to parse some extra parameters to the transaction API (not 
plain text).


I don't see any way to access this functionality from Qt though. Am I 
missing something?



Hamish

___
Interest mailing list
Interest@qt-project.org
https://lists.qt-project.org/listinfo/interest