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

Reply via email to