Solved How many transaction can i open with one database?
-
How many connection can I open with one database? I have a client and server, when client connects to this server i send information to it. Also i have a service which uses this database, INSERT, UPDATE and DELETE queries in this database are often executed from various classes. I use Firebird base.
I mean:
if (db.open) { db.driver()->begintranTransaction(); QSqlQuery query; //write something if (!query.exec ) { db.driver()->rollbackTransaction(); } else { db.driver()->comitTransaction(); } }
-
@Taz742 With which database? It depends on the database server not Qt.
-
@jsulm
I update my question. I need transaction not connection. Sorry. -
@Taz742 said in How many transaction can i open with one database?:
Firebird
For Firebird for 2.5 and earlier its signed 32 bit integer
giving around 2^31 for maximum.It depends on the (native) database driver etc. Not Qt :)
-
@mrjj You made me very happy :)