Qt使用QSqlDatabase remoeDatabase()连接提示仍在使用解决方案

最新推荐文章于 2024-09-29 22:27:19 发布

FreeLikeTheWind.

最新推荐文章于 2024-09-29 22:27:19 发布

阅读量473

点赞数

分类专栏： Qt记录 Qt编程 c++ 文章标签： qt 数据库开发语言

本文链接：https://blog.csdn.net/MrHHHHHH/article/details/132758934

版权

Qt记录同时被 3 个专栏收录

175 篇文章 13 订阅

订阅专栏

Qt编程

80 篇文章 2 订阅

订阅专栏

c++

67 篇文章 1 订阅

订阅专栏

文章讲述了在使用QSqlDatabase的removeDatabase函数时，如果数据库连接仍有查询在进行，会导致资源泄露。正确的方法是在查询执行完毕后，确保对象出作用域再调用removeDatabase。同时提到如何移除默认连接和函数的线程安全特性。

摘要由CSDN通过智能技术生成

问题描述

调用QSqlDatabase的removeDatabase函数的时候，出现了如下错误

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

官方示例

[static] void QSqlDatabase::removeDatabase(const QString &connectionName)
Removes the database connection connectionName from the list of database connections.
Warning: There should be no open queries on the database connection when this function is called, otherwise a resource leak will occur.
Example:

  // WRONG
  QSqlDatabase db = QSqlDatabase::database("sales");
  QSqlQuery query("SELECT NAME, DOB FROM EMPLOYEES", db);
  QSqlDatabase::removeDatabase("sales"); // will output a warning

  // "db" is now a dangling invalid database connection,
  // "query" contains an invalid result set

The correct way to do it:

  {
      QSqlDatabase db = QSqlDatabase::database("sales");
      QSqlQuery query("SELECT NAME, DOB FROM EMPLOYEES", db);
  }
  // Both "db" and "query" are destroyed because they are out of scope
  QSqlDatabase::removeDatabase("sales"); // correct

To remove the default connection, which may have been created with a call to addDatabase() not specifying a connection name, you can retrieve the default connection name by calling connectionName() on the database returned by database(). Note that if a default database hasn't been created an invalid database will be returned.
Note: This function is thread-safe.

解决方案

{
QSqlDatabase db = QSqlDatabase::database(“sales”);
QSqlQuery query(“SELECT NAME, DOB FROM EMPLOYEES”, db);
}
// Both “db” and “query” are destroyed because they are out of scope
QSqlDatabase::removeDatabase(“sales”);