sqlite-jdbc: java.lang.UnsatisfiedLinkError: org.sqlite.core.NativeDB._open(Ljava/lang/String;I)V

Check that your /tmp is not mounted noexec. Debian 9, for example, mounts /tmp with noexec.

$ mount | grep /tmp
/dev/sda6 on /tmp type ext4 (rw,noexec,nosuid,nodev,relatime,data=ordered)

If this is the case, there are 2 workarounds:

Solution 1. Edit /etc/fstab and remove noexec from /tmp. Then remount /tmp:

$ mount -o remount /tmp

Solution 2. Use another tmp location.

$ java ... -Djava.io.tmpdir=/var/run/some-other-location

If running tomcat8 on Debian, edit /etc/default/tomcat8 and add:

JVM_TMP=$CATALINA_BASE/temp

I’m getting the same error on ubuntu linux 14.04 running on a pandaboard (armhf architecture):

03/14/2016 14:59:31: Caused by: java.lang.UnsatisfiedLinkError: org.sqlite.core.NativeDB._open(Ljava/lang/String;I)V 03/14/2016 14:59:31: at org.sqlite.core.NativeDB._open(Native Method) 03/14/2016 14:59:31: at org.sqlite.core.DB.open(DB.java:161) 03/14/2016 14:59:31: at org.sqlite.core.CoreConnection.open(CoreConnection.java:220) 03/14/2016 14:59:31: at org.sqlite.core.CoreConnection.<init>(CoreConnection.java:76) 03/14/2016 14:59:31: at org.sqlite.jdbc3.JDBC3Connection.<init>(JDBC3Connection.java:24) 03/14/2016 14:59:31: at org.sqlite.jdbc4.JDBC4Connection.<init>(JDBC4Connection.java:23) 03/14/2016 14:59:31: at org.sqlite.SQLiteConnection.<init>(SQLiteConnection.java:45) 03/14/2016 14:59:31: at org.sqlite.JDBC.createConnection(JDBC.java:114) 03/14/2016 14:59:31: at org.sqlite.JDBC.connect(JDBC.java:88) 03/14/2016 14:59:31: at java.sql.DriverManager.getConnection(DriverManager.java:571) 03/14/2016 14:59:31: at java.sql.DriverManager.getConnection(DriverManager.java:233)

Please check, that the tmpDir is set and you have the permissions. The SQLite DLL gets extracted from the jar to the tmp.

final File tmp = new File(System.getProperty("java.io.tmpdir")); if (!tmp.exists() || !tmp.isDirectory() || !tmp.canRead() || !tmp.canWrite()) { throw new Exception("error with tmpDir"); } SQLiteJDBCLoader.initialize();

I have the same problem on Raspbian 2016

how to solve it on mac??? I’m having the same issue with Android and Room.

I only recently downloaded the source code, compiled it and tried to include in into my java application (console based server application with SQLite support planned). The compiled shared object in included in package /org/sqlite/native/Linux/arm and is named libsqlitejdbc.so

Now, according to some posts here, which I found useful, my server application checks “java.io.tmpdir” for correct permissions. Everything seems to be OK.

The error happens to me if my server is being executed on a Raspberry Pi 3 and the following line is executed: connection = DriverManager.getConnection(“jdbc:sqlite:” + dbPath);

dbPath specifies the file path to the database to be opened.

To my temp directory /tmp a file named sqlite-3.7.15-arm-libsqlitejdbc.so is copied.

What can I do about the error?

This is the stacktrace I got

Exception in thread “main” java.lang.UnsatisfiedLinkError: org.sqlite.NativeDB._open(Ljava/lang/String;I)V at org.sqlite.NativeDB._open(Native Method) at org.sqlite.DB.open(DB.java:157) at org.sqlite.Conn.open(Conn.java:169) at org.sqlite.Conn.<init>(Conn.java:87) at org.sqlite.JDBC.createConnection(JDBC.java:113) at org.sqlite.JDBC.connect(JDBC.java:87) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270) at jsqlite.Database.open(Database.java:41) at jsqlite.Server.requestRemoteDatabase(Server.java:172) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at de.root1.simon.ProcessMessageRunnable.processInvoke(ProcessMessageRunnable.java:485) at de.root1.simon.ProcessMessageRunnable.run(ProcessMessageRunnable.java:97) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)

EDIT: After updating to sqlite-jdbc-3.15.1.jar the error was gone. seems that 3.7.15 simply was too old.

Same error as above. The root cause of my error is: THERE IS NO TEMP FOLDER IN TOMCAT INSTALL DIR($CATALINA_BASE). So my solution is: cd /usr/share/tomcat8 # this is the install dir of my tomcat8 (cause I install it by apt-get) sudo mkdir temp sudo chmod 777 temp/ Then restart tomcat, the error is gone.