QSql QSqlDatabasePrivate::removeDatabase: connection 'IDconnect' is still in use, all queries will cease to work.

gabor53

@SGaist
Hi,
I got back to the same problem.
I realized that when Additem loads the first time everything works fine. I get the error message when Additem is reloaded from another class, Review. I assume, somehow the original Additem database connections are still active when I load the class the second time. How can I avoid recreating the connection each time I reload Additem?
Thank you.

SGaist

Do you have several connections to the database ?

gabor53

Yeswith different names.

gabor53

I ment connection names. Also when Additem is called several times I assume it attempts to reconnect to the db and kills the previous connection with the same name.

SGaist

You don't need to re-create the connection each time. You create it one time and then, depending on how your application works, you open and close it at will or open it once at the start of your application. When you want to use it, you can use the following construct:

void MyCoolClass::myCoolFunction()
{
QSqlDatabase db = QSqlDatabase::database("IDconnect");
// open if needed
QSqlQuery query(db);
// rest of your code
// close if needed
}

gabor53

@SGaist
Thank you. Do I close it the right way using db.close() and removeDatabase?

SGaist

There's no need to call removeDatabase every time. QSqlDatabase can be seen as a sort of registry where you store all the connection data for the databases you are going to access. Unless you have good reasons to remove that particular connection, just set it up once and for the rest follow the myCoolFunction example.

gabor53

@SGaist
I made some changes. The db connection is used in the Additem class so I created a connection function like this:

void Additem::connection()
{
    if(!db.open ())
        {
            db = QSqlDatabase::addDatabase ("QSQLITE","Friend");
            db.setDatabaseName (fileQstring );
        }
}

This became the only db opening statement. I call this function before function Addfriend as Addfriend is the function where the db connection is used. Whenever Additem is called, I get the usual error messages:
QSqlDatabasePrivate::removeDatabase: connection 'Friend' is still in use, all queries will cease to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name 'Friend', old connection removed.
Closing Additem clearly doesn't removes the connection (based on the error messages) but if there is no connection why does the !db.open thinks the connection is still open and gives me a new message? Thank you.

SGaist

Again, you have a QSqlDatabase class member. Each time you create a Additem object you create a new invalid QSqlDatabase object that will be replaced in connection and depending on how Additem objects are managed, you'll have several of these connection re-created.

gabor53

Is this something I definitely have to fix or it's not a big deal?

SGaist

Duplicating connection name means that you will break at least one connection. I'd rather not overlook that.