I have QT += sql in my pro.
DB path= "/usr/share/Stockona/.stockona_db"
By the way, db.lastError().text() and type() gave me:
"Error: DB failed to open, "out of memory Error opening database" errorType=
1"
The path I got when deployed as binary was:
DB path= "/opt/sdk/Stockona/usr/share/Stockona/.stockona_db"
Database file can be created as expected with this configuration.
Thanks,
William
________________________________
From: Andrey Kozhevnikov <coderusin...@gmail.com>
To: devel@lists.sailfishos.org
Sent: Tuesday, November 12, 2013 12:14 AM
Subject: Re: [SailfishDevel] QSqlDatabase cannot create db file when deployed
as rpm package
have you added sql to your project CONFIG?
and what is resulting dbPath value?
On 12.11.2013 14:12, Stockona wrote:
Source code:
>
>
>Q_DECL_EXPORTintmain(intargc,char*argv[]) {
>...
> FileHandler*fileHandler=newFileHandler();
>view->rootContext()->setContextProperty("fileHandler",fileHandler);
>...
>}
>
>
>FileHandler::FileHandler(QObject*parent):QObject(parent){
> ...
>
>// /usr/share/Stockona/
QStringdbPath=QString(DEPLOYMENT_PATH); dbPath.append(".stockona_db");
qDebug()<<"DBpath="<<dbPath;
QSqlDatabasedb=QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(dbPath); // Cannot open database when deployed as rpm
boolok=db.open(); ...
}
>
>
>
>________________________________
> From: Andrey Kozhevnikov <coderusin...@gmail.com>
>To: devel@lists.sailfishos.org
>Sent: Monday, November 11, 2013 11:32 PM
>Subject: Re: [SailfishDevel] QSqlDatabase cannot create db file when deployed
>as rpm package
>
>
>
>My project working with QSQLITE local database, and everything good :)
>
>Share your code and we can found issues.
>
>
>On 12.11.2013 02:35, Stockona wrote:
>
>When I switched to "Deploy by copying binary", the database is created and
>connected correctly.
>>Changing the deployment to rpm package the same code just failed with
>>database error message "out of memory Error opening database."
>>
>>
>>I checked in Emulator terminal and the database file was not created at all.
>>Is this a permission issue? How do I work around this?
>>Thanks in advance!
>>
>>
>>
>>
>>
>>_______________________________________________
SailfishOS.org Devel mailing list
>
>
>_______________________________________________
>SailfishOS.org Devel mailing list
>
>
>
>
>_______________________________________________
SailfishOS.org Devel mailing list
_______________________________________________
SailfishOS.org Devel mailing list
_______________________________________________
SailfishOS.org Devel mailing list