Questions tagged [jsqlite]

Quick and simple SQLite database maker/accessor for Android

3 questions
5
votes
1 answer

How do I use a prepared statement in Spatialite Android?

I'm looking at the tutorial for Spatialite-Android, and I'm noticing the following code samples: String query = "SELECT AsText(Transform(MakePoint(" + TEST_LON + ", " + TEST_LAT + ", 4326), 32632));"; sb.append("Execute query:…
PearsonArtPhoto
  • 38,970
  • 17
  • 111
  • 142
1
vote
0 answers

Check if SpatiaLite database is open - android

I am trying to check if my jsqlite database is open or not. Unfortunately there is not an isOpen() function for this kind of database and I can't find any similar method to check if the database is open or not. Has anyone faced this problem before?…
stavros.3p
  • 2,244
  • 6
  • 20
  • 37
1
vote
1 answer

VACUUM results in "Unable to open database file"

I'm getting the following error in Spatialite, when I'm trying to add new files to my database. 10-05 11:50:01.408: E/GDH(1545): jsqlite.Exception: unable to open database file 10-05 11:50:01.408: E/GDH(1545): at jsqlite.Database._exec(Native…
PearsonArtPhoto
  • 38,970
  • 17
  • 111
  • 142