How many transaction can i open with one database?

[Taz742]

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();
    }
}

[jsulm]

@Taz742 With which database? It depends on the database server not Qt.

[Taz742]

@jsulm
I update my question. I need transaction not connection. Sorry.

[mrjj]

@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 :)

[Taz742]

@mrjj You made me very happy :)