My xFileControl() method has actually returned a SQLITE_OK and not as stated in 
the documentation, a SQLITE_NOTFOUND. 
I fixed it and now all the PRAGMAs worked fine. 

I thank you very much


-----Original Message-----
From: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Janke, Julian
Sent: Mittwoch, 22. April 2015 13:13
To: ambrus at math.bme.hu; General Discussion of SQLite Database
Subject: Re: [sqlite] Problems with pragma journal_mode

Thank you for the hint. I'll check that.

-----Original Message-----
From: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Zsb?n Ambrus
Sent: Mittwoch, 22. April 2015 10:58
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Problems with pragma journal_mode

On Wed, Apr 22, 2015 at 10:46 AM, Janke, Julian <julian.janke at capgemini.com> 
wrote:
> I have tested some of the other pragmas and none worked. After 
> discussing with you now I come to the conclusion that the problem is 
> caused more by my local setup. I

In that case, as you have a custom vfs, could you check if it's your vfs that 
is handling those pragmas?  The documentation at 
"http://sqlite.org/c3ref/c_fcntl_busyhandler.html#sqlitefcntlpragma";
describes that when you run a PRAGMA statement on a database, sqlite will call 
the xFileControl method of the vfs file handle (as given in a 
sqlite3_io_methods structure) with SQLITE_FCNTL_PRAGMA as the second parameter. 
 If that method returns SQLITE_OK, then sqlite will assume the vfs has handled 
the pragma, and will not handle it itself.  This could cause pragmas to fail 
silently.

-- Ambrus
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

________________________________

Firma: Capgemini Deutschland GmbH
Aufsichtsratsvorsitzender: Antonio Schnieder ? Gesch?ftsf?hrer: Dr. Michael 
Schulte (Sprecher) ? Jost F?rster ? Dr. Peter Lempp ? Dr. Volkmar Varnhagen

Amtsgericht Berlin-Charlottenburg, HRB 98814 This message contains information 
that may be privileged or confidential and is the property of the Capgemini 
Group. It is intended only for the person to whom it is addressed. If you are 
not the intended recipient, you are not authorized to read, print, retain, 
copy, disseminate, distribute, or use this message or any part thereof. If you 
receive this message in error, please notify the sender immediately and delete 
all copies of this message.
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to