Using this:
SQLiteDatabase.openDatabase(path, null, SQLiteDatabase.CREATE_IF_NECESSARY
| SQLiteDatabase.NO_LOCALIZED_COLLATORS);
Instead of this:
SQLiteDatabase.openOrCreateDatabase(path, null);
I don't get the error on database creation but if I then manually execute
the offending statement then I get the same error.
db.execSQL("CREATE TABLE IF NOT EXISTS android_metadata (locale TEXT)");
After using openDatabase (I'm creating a new file, not opening an existing
one)
select sqlite_version()
reports:
3.17.0
SELECT * FROM pragma_compile_options;
reports:
COMPILER=clang-3.8.256229
DEBUG
SYSTEM_MALLOC
TEMP_STORE=3
THREADSAFE=1
I'll double check everything is up to date tomorrow and try the .aar
Thanks for your help
*__________________________________________*
*ALEXANDRE MAINVILLE*
Software Architect
*iBwave*
7075, Robert-Joncas, Suite 95
Montreal, Quebec, H4M 2Z2, Canada
www.ibwave.com
T +1 514-397-0606 ext. 422
F +1 514-409-2499
alexandre.mainvi...@ibwave.com
blog <http://www.ibwave.com/blog> | facebook
<https://www.facebook.com/iBwave> | linkedin
<http://www.linkedin.com/groups?home=&gid=2720825> | twitter
<http://www.twitter.com/ibwave> |
This email, including all attachments, is intended only for the named
recipient(s) and may contain confidential information. Any unauthorized
use, review, retransmission or dissemination of this email is strictly
prohibited. If you have received this email in error, or are not the named
recipient(s), please immediately notify the sender and destroy the original
and all copies of this email. Thank you.
On Tue, Feb 21, 2017 at 1:34 PM, Richard Hipp <d...@sqlite.org> wrote:
> On 2/21/17, Alexandre Mainville <alexandre.mainvi...@ibwave.com> wrote:
> > Hi,
> >
> > I just upgraded from sqlite 3.8.8.3 to 3.17.0. (I use zipvfs 3.17.0)
> >
> > On android, I get error SQLITE_IOERR_GETTEMPPATH (6410) when I try to
> > create a new DB.
> >
> > I checked that SQLITE_TEMP_STORE is properly set to 3 in Android.mk
>
> That error is only generated in one place (on unix systems):
>
> https://www.sqlite.org/src/artifact/30e2c43e4?ln=5460
>
> I added an "assert(0)" on the previous line and compiled ZIPVFS
> version 3.17.0 with -DSQLITE_TEMP_STORE=3 and -DSQLITE_DEBUG (the
> second to enable asserts). I could not get the assert to fail.
>
> Are you sure compiling correctly and that you are using the freshly
> compiled code? What does this SQL statement return:
>
> SELECT * FROM pragma_compile_options;
>
> You should get back multiple lines, one of which should says
> "TEMP_STORE=3" if the makefile is working correctly.
>
> --
> D. Richard Hipp
> d...@sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
