MBTilesWriter java.lang.UnsatisfiedLinkError slice-sqlite-jdbc-3.8.7

Question

im using the mbtiles4j writer inside an Android App to create a new .mbtiles file in an AsyncTask class.

Here is my java code:

private class FetchData extends AsyncTask<String, Void, String> {
  private Exception exception;

  @Override
  protected String doInBackground(String... routeSelected) {
    MBTilesWriter w = null;
    String filePath = Environment.getExternalStorageDirectory().getAbsolutePath() + "/MyRoutes/" + routeSelected;
    try {
      outputFile = new File(filePath);
      w = new MBTilesWriter(outputFile);
      new File(Environment.getExternalStorageDirectory().getAbsolutePath() + "/MyRoutes").mkdirs();
    } catch (MBTilesWriteException e) {
      this.exception = e;
      System.out.println("exception: " + e);
      return "";
    }

    //Irrelevant code removed here...

    return filePath;
  }
}

Full error report on windows 10 x64 bit. http://pastebin.com/raw/fhSH8qJr

build.gradle looks as follows

dependencies {
    compile fileTree(include: ['*.jar'], dir: 'libs')
    androidTestCompile('com.android.support.test.espresso:espresso-core:2.2.2', {
        exclude group: 'com.android.support', module: 'support-annotations'
    })
    //compile 'org.imintel:mbtiles4j:1.0.5'
    compile 'org.xerial:sqlite-jdbc:3.8.7'
    compile 'commons-io:commons-io:2.5'

mbtiles4j is actually included inside my project: see screenshot. There were other problems with including it through build.gradle, so I managed to workaround it like this. The mbtilesreader works fine!

Edit: disabled instant run, error code is now: couldn't find "libsqlitejdbc.so"

Have you tried to disable instant-run (http://stackoverflow.com/questions/35168753/instant-run-in-android-studio-2-0-how-to-turn-off) and get the same problem? — Morrison Chang, Jan 06 '17 at 17:00
Disabled it and now the error is specified more specificly: couldn't find "libsqlitejdbc.so" — user3586358, Jan 06 '17 at 17:09
I think you need to find a Android specific SQLite JDBC driver/library and make the appropriate changes to MBTilesWriter. — Morrison Chang, Jan 06 '17 at 17:26
yes, the driver is hardcoded, so I'll have to change it. Thanks! — user3586358, Jan 06 '17 at 17:29

score 1 · Answer 1 · answered Jan 06 '17 at 20:39

1

Solution thanks to @Morrison Chang and @cCOOK

I had to rewrite the MBTilesWriter for specific Android implementation. Check it out here

answered Jan 06 '17 at 20:39

user3586358

99
1
9

MBTilesWriter java.lang.UnsatisfiedLinkError slice-sqlite-jdbc-3.8.7

1 Answers1