QSqlDatabase, SET TRANSACTION READ ONLY, ISOLATION LEVEL

[michaeldev]

Hi!

Is it possible define SET TRANSACTION READ ONLY and ISOLATION LEVEL?
By QSqlDatabase or QSqlQuery.

[mrjj]

Hi
What database system are you using ?
Sqlite ?

[michaeldev]

@mrjj Firebird

[mrjj]

Hi
It seems you can do

QSqlQuery query;
query.exec("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE");

dont know with readonly.

[michaeldev]

@mrjj Error's text: " "

[mrjj]

@michaeldev
??????????

[michaeldev]

@mrjj said in QSqlDatabase, SET TRANSACTION READ ONLY, ISOLATION LEVEL:

Hi
It seems you can do

QSqlQuery query;
query.exec("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE");

dont know with readonly.

false, error's text: " "

[mrjj]

hi
And have connected to the DB first and the connection is fine ?
What are you using the FireBird plugin ? or via odbc ?

[michaeldev]

@mrjj said in QSqlDatabase, SET TRANSACTION READ ONLY, ISOLATION LEVEL:

hi
And have connected to the DB first and the connection is fine ?
What are you using the FireBird plugin ? or via odbc ?

Connection is fine. Common queries have results good.
I use Firebird native plugin.

[mrjj]

@michaeldev
Hi
Ok then i don't think the plugin supports it.
But it odd it dont report anything back about it.