Symbian Belle FP1 + QML App + sqlite offlineStoragePath = PROBLEM!!!

[e.pirola]

Hello!

I've just developed my first QML/Qt application that uses the embedded sqlite Databes to store information.

If i run it (both on windows and on my Nokia 700 Belle FP1) usind the default offlineStoragePath, everything is fine.

When I try to change the DB path (in order to have data automatically backed up!), on MinGW works perfectly while on my the application hangs up.
I particular, during the new DB creation, my App creates the "MyDB".ini file but not the "MyDB".sqlite one.

The code I'm using in main.cpp is the following:

{
QScopedPointer<QApplication> app(createApplication(argc, argv));
QmlApplicationViewer viewer;
QDir dirMgr ;

QString myPath("/data");
viewer.engine()->setOfflineStoragePath(QString(dirMgr.toNativeSeparators(myPath)));

viewer.setMainQmlFile(QLatin1String("qml/GestFin/main.qml"));
viewer.showExpanded();
return app->exec();
}

I found a couple of bugs on 'setOfflineStoragePath' but they should be closed in Qt 4.8.0 that is deployed with Belle FP1.

I need to have my db file outside in an accessible directory. Can you help me?

Thanks in Advance

[e.pirola]

Anybody can help?

[vladestCh]

I'd suggest to move db interactions to c++ code

[e.pirola]

Can you explain better?

If I do not set "OfflineStoragePath", I correctly work with the DMBS.
It only fails to create the database when I set the parameter.

What are you suggesting to move to c++?

[mikitzzii]

Hi,

by default a database is saved to private folder on installed drive.
e.g. "C:\Private\e2c6cd9e\QML\OfflineStorage" where e2c6cd9e is application uid.

There is no problem to change database folder. I tested your code in my Qt & qml project and I managed to create new db.ini & db.sqlite files to "data" folder.
Seems that files are saved to "C:\data\Databases" folder.

Note that after Belle Fp1 update you need to install new CODA and update your Qt SDK . Please see page
Otherwise application hangs up