N9 and SQLITE database

[boumacmilan]

Hello

i have a question about reading a SQLite Database on N9
for symbian i used to do:
in main file :

#ifdef Q_WS_SIMULATOR
view.engine()->setOfflineStoragePath("qml/MyProject/sqlite");
#else
QString pathOfflineStorage(QApplication::applicationDirPath());
pathOfflineStorage.append(QDir::separator()).append("qml/MyProject/sqlite");
pathOfflineStorage = QDir::toNativeSeparators(pathOfflineStorage);
view.engine()->setOfflineStoragePath(pathOfflineStorage);
#endif
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
QFileInfo i("qml/Myproject/sqlite/Databases/bd.sqlite");
db.setDatabaseName(QDir::toNativeSeparators(i.absoluteFilePath()));
db.open();

in Bd.js:

function getDatabase()
{
    return openDatabaseSync("MyProject", "1.0", "ana", 100000);
}

it works correctly with symbian but no with meego
any ideas??
thanks in advance

[nowheremanmail]

I have similar code working. Are you sure that it is not a problem on path?

Otherwise what it means doesn't work? it give you any error? crash?

[tkastlunger]

May I ask, why do you do :

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
QFileInfo i("qml/Myproject/sqlite/Databases/bd.sqlite");
db.setDatabaseName(QDir::toNativeSeparators(i.absoluteFilePath()));
db.open();

The javascript will have no use for it whatsoever.
Also, if I remember correctly, you have to enable offline storage explicitly. I *could* post you the link with an example, but - oh - harmattan-dev is down, so.... :/

[boumacmilan]

Hi nowheremanmail
thanks for your answer the error is i can't open the data base the path of my DB : qml/MyProject/SQLite/DB/test.sqlite
the same path worked perfectly with symbian

thanks in advance for your help

[rhythmkay]

It is quite easy.
In N9 you should better use absolute path

such as this:

view.engine()->setOfflineStoragePath("qml/MyProject/sqlite");
you should correct it to this path better "opt/yourProjectName/qml/MyProject/sqlite"
yourProjectName is your real project name.