Facing Problem to save SQLite Database on Symbian Device

[narendar_discover]

Hi,
I want to save some data on device, for that I am using SQLite Database. In Emulator I am able to create DB, Tables and also able to run various type of SQL statement like Insert, Delete, Update and so on. Here is the link from where I got all information regarding SQLite on Symbian:

http://wiki.forum.nokia.com/index.ph...database_in_Qt

But after creation sis file if I run this app on device. its not working. What may have problem ?

I am using Nokia Qt SDK 1.0.2. I have installed the app on Nokia E7.

I am also getting this error in Application Output :
QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed

[danhicksbyron]

Maybe you should show us a little bit of your code.

[skumar_rao]

you can try this

        QString connectionName = "myconnection";
        if(QSqlDatabase::contains(connectionName)) {
            QSqlDatabase::removeDatabase(connectionName);
        }
        database = QSqlDatabase::addDatabase("QSQLITE", connectionName);
        database.setDatabaseName("tablename");

[danhicksbyron]

If you want the database on the device, you shouldn't need a connection name.

[narendar_discover]

If you want the database on the device, you shouldn't need a connection name.

bool DatabaseManager:penDB()
{
bool ret = false;

// QString connectionName = "connection";
// if(QSqlDatabase::contains(connectionName)) {
// QSqlDatabase::removeDatabase("QSQLITE");
// }

mDb = QSqlDatabase::addDatabase("QSQLITE");
mDb.setDatabaseName("MYDB");
ret = mDb.open();
qDebug()<<"openDB() ret = "<<ret;
return ret;
}

In my app I call this method more than one time and get the error on log

[danhicksbyron]

Well, don't call the method more than one time. Or close the db when you're done with it.

[skumar_rao]

did #3 worked ?

[narendar_discover]

did #3 worked ?

I was still getting same issue. Then I have changed my code like below I mean I have placed QSqlDatabase::removeDatabase("QSQLITE"); after closing the db and again getting same issue.

void DatabaseManager::closeDB()
{
if (mDb.isOpen())
{
mDb.close();
QSqlDatabase::removeDatabase("QSQLITE");
}
}

[skumar_rao]

can you check the doc http://doc.qt.nokia.com/latest/qsqld...removeDatabase as you can see removeDatabase() closes a open connection. i suggest you try again #3 before opening file or open the file with a connection name then

void DatabaseManager::closeDB()
{
if (mDb.isOpen())
{
mDb.close();
QSqlDatabase::removeDatabase("connectionName");
}
}

[danhicksbyron]

Why are you opening the DB more than once???

[narendar_discover]

Why are you opening the DB more than once???

I have two Tabs each. Each tab read some data from DB from different table.

At startup Tab A opens the DB, reads the rows and then closes the DB also removes the database. when user goes to Tab B again my app opens the DB, reads the rows and then closes the DB and removes the database. Do we need to change this logic. and just need to open DB in Tab A and then continue in Tab B without closing it.

[skumar_rao]

note that : a DB can have multiple tables .

[danhicksbyron]

Why not just leave the database open?