[SOLVED] QSqlDatabase::addDatabase("QSQLITE","localdb"); problem with name

[conceptid]

With this code in the constructor of my mainwindow:
@
db = QSqlDatabase::addDatabase("QSQLITE","localdb");
db.setDatabaseName("../test/test.db");
if (!db.open()) {
QMessageBox::critical(0, QObject::tr("Database Error"),
db.lastError().text());
}

model = new QSqlTableModel(this);
model->setTable("items");
model->select();
qDebug() << "SQL LastError:" << model->lastError().text();

@

and in the destructor:

@
db.close();
QSqlDatabase::removeDatabase("localdb");
delete ui;
@

output at start:
(I don't have the qmessagebox and my table view stay blank.)
SQL LastError: " Unable to find table items"

output at close app:
QSqlDatabasePrivate::removeDatabase: connection 'localdb' is still in use, all queries will cease to work.

If I remove the name of the connection, "localdb" and let the system use the default name, I have this:
@ db = QSqlDatabase::addDatabase("QSQLITE");
@

SQL LastError: " "

and I have my datas shown in the table view... ?!?!?
No error at close.

What am I doing wrong with the connection name?

I need it because this app will have 2 separates connections, one local with sqlite and another to a remote db2 server.

[panosk]

Hi,

For your first problem, you haven't included the database name in your QSqlTableModel constructor so the default connection is used. So create your model like this:
@
model = new QSqlTableModel(this,db);
@

For your second problem, try to remove the database like this:
@
db.close();
db = QSqlDatabase();
db.removeDatabase("localdb");
@

[conceptid]

Work for both solutions :)

I didn't know the model needed to specify the connection name :)

I understand for the remove that I need to disconnect the db variable with the database name/connection I want to delete... And seems to not have a method to disconnect so, replacing the object with a default one have the same effect...

Thank you very much :)

[panosk]

Nice :) . Don't forget to edit your initial post and add [SOLVED] to the title.