wqbyangtzeu / spatialite-android

Automatically exported from code.google.com/p/spatialite-android
0 stars 1 forks source link

problem with temporery file #29

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. run code:

String[] argsGeom = {name, geometryColumn};
db.exec("DROP TABLE \"idx_%q_%q\";", null, argsGeom);

2. same problem with code:

String[] argsTable = {name};
db.exec("VACUUM;", null, argsTable);

What is the expected output? What do you see instead?

Exception - "unable to open database file"

What version of the product are you using? On what operating system?

I use spatialite-for-android-3.0.1.zip from this URL 
https://www.gaia-gis.it/fossil/libspatialite/wiki?name=splite-android . Android 
4.0.4 tablet Prestigio MultiPad 7.0 pro duo.

Please provide any additional information below.

Problem is with temporery file. I think, that the program can not open 
temporery file. One solution is use only memory:

db.exec("PRAGMA temp_store = 2;", null, null);

but i thing temporery file is better. There is pragma temp_store_directory, but 
it is deprecated.

Original issue reported on code.google.com by v.kal...@gmail.com on 19 Mar 2013 at 10:55