sqlite-jdbc: Android UnsatisfiedLinkError

Device: samsung s5 with android 6.0.0, api23, with permissions granted

Here’s the dependency parts of the gradle build file


dependencies {

    compile 'com.android.support:support-v4:23+'
    compile 'com.android.support:design:23.+' //needed for UI menuing
    compile 'com.android.support:appcompat-v7:23.2.1'
    compile 'org.xerial:sqlite-jdbc:3.20.0'
    compile 'commons-io:commons-io:2.5'
    compile 'org.apache.commons:commons-lang3:3.6'
    compile 'org.apache.commons:commons-compress:1.11'
    testCompile 'junit:junit:4.12'
    //crash logging
    compile 'ch.acra:acra:4.7.0'

    //memory leak testing
    debugCompile 'com.squareup.leakcanary:leakcanary-android:1.4-beta2'
    releaseCompile 'com.squareup.leakcanary:leakcanary-android-no-op:1.4-beta2'
    testCompile 'com.squareup.leakcanary:leakcanary-android-no-op:1.4-beta2'

    //on device testing
    androidTestCompile 'com.android.support:support-annotations:23+'
    androidTestCompile 'com.android.support.test:runner:0.4.+'
    androidTestCompile 'com.android.support.test:rules:0.4.+'
}

Other build settings

android-plugin.version=2.1.0
android-support.version=23.1.1
android.buildToolsVersion=23.0.3
android.compileSdkVersion=23
android.minSdkVersion=8
android.targetSdkVersion=23

Initialization code

 DriverManager.registerDriver((Driver) Class.forName(
                             "org.sqlite.JDBC").newInstance());
                    Connection con = DriverManager.getConnection("jdbc:sqlite:/sdcard/importTest.sqlite");

Error message

E/AndroidRuntime: FATAL EXCEPTION: Thread-23816
                                                                             Process: org.osmdroid.reader.example, PID: 10352
                                                                             java.lang.UnsatisfiedLinkError: dalvik.system.PathClassLoader[DexPathList[[zip file "/data/app/org.osmdroid.reader.example-2/base.apk"],nativeLibraryDirectories=[/data/app/org.osmdroid.reader.example-2/lib/arm, /vendor/lib, /system/lib]]] couldn't find "libsqlitejdbc.so"
                                                                                 at java.lang.Runtime.loadLibrary(Runtime.java:367)
                                                                                 at java.lang.System.loadLibrary(System.java:1076)
                                                                                 at org.sqlite.core.NativeDB.<clinit>(NativeDB.java:38)
                                                                                 at org.sqlite.core.CoreConnection.open(CoreConnection.java:211)
                                                                                 at org.sqlite.core.CoreConnection.<init>(CoreConnection.java:76)
                                                                                 at org.sqlite.jdbc3.JDBC3Connection.<init>(JDBC3Connection.java:26)
                                                                                 at org.sqlite.jdbc4.JDBC4Connection.<init>(JDBC4Connection.java:24)
                                                                                 at org.sqlite.SQLiteConnection.<init>(SQLiteConnection.java:45)
                                                                                 at org.sqlite.JDBC.createConnection(JDBC.java:114)
                                                                                 at org.sqlite.JDBC.connect(JDBC.java:88)
                                                                                 at java.sql.DriverManager.getConnection(DriverManager.java:179)
                                                                                 at java.sql.DriverManager.getConnection(DriverManager.java:144)
                                                                                 at org.osmdroid.reader.MainActivity$2.run(MainActivity.java:86)

At this point, i’m not too sure what i’m doing wrong.

About this issue

  • Original URL
  • State: closed
  • Created 7 years ago
  • Reactions: 1
  • Comments: 19 (2 by maintainers)

Most upvoted comments

@xerial any update for the android x86 binary?