Question about QSqlDatabase::removeDatabase

Robert Hairgrove

Working with Qt's SQLite driver ... when switching database files, can I just call the close() member function before calling setDatabaseName() and open() for the new database file, i.e. reusing the same named connection, or do I have to call QSqlDatabase::removeDatabase() first and then call QSqlDatabase::addDatabase() again?

At least for SQLite, it seems to work OK if I never call removeDatabase() at all. But maybe there is a leak somewhere? The docs are very clear about not having any active database connections or queries before calling this; however, I'm not sure that it is necessary.

SGaist

Hi,

AFAIK, there's nothing wrong with that. Having several database connections is usually when:

Connecting to several different databases
Connecting to the same database from different threads.

Christian Ehrlicher

If you've an active QSqlQuery somewhere and then calling setDatabaseName() you will likely get in trouble since there is no guarantee that this has to work. It maybe works for QSQlite.

Robert Hairgrove

@SGaist Thank you. I will have only two different named connections, but not at the same time: One connection to an existing database file, and another to a ":memory:" database. This should not be a problem.

Robert Hairgrove

@Christian-Ehrlicher Thank you. Since each QSqlQuery object and each QSqlDatabase object only exist for the life of one function body, at most, this should not be a problem.