On 07/06/2016 09:09 PM, Jeff Archer wrote:
Hi All, I am a long time SQLite user but have generally used it from C++ in the past. In this project however, I am attempting to make a JDBC wrapper and use from Android a newer version of SQLite (3.12.2) than that provided by Android 4.2.2 (3.7.11).
Group 8 however can only do 26 successful inserts and on the 27th sqlite3_step() is returning SQLITE_CANTOPEN (14).
SQLite is failing to create a temporary file, as there is nowhere convenient to do this on Android. The usual fix is to build SQLite to store temp files in memory:
-DSQLITE_TEMP_STORE=3 https://www.sqlite.org/compile.html#temp_store Or execute "PRAGMA temp_store = memory" after opening your db connection. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
