B4J Question Running sqlite on a raspberry pi

[TomDuncan]

Hi All,
I have an application that runs fine on windows and a x86 linux box.
I have set it up on a raspberry pi 64 bit Dietpi debian distro.
I get an error

Caused by: java.lang.Exception: No native library is found for os.name=Linux and os.arch=aarch64
    at org.sqlite.SQLiteJDBCLoader.loadSQLiteNativeLibrary(SQLiteJDBCLoader.java:284)
    at org.sqlite.SQLiteJDBCLoader.initialize(SQLiteJDBCLoader.java:65)
    at org.sqlite.core.NativeDB.load(NativeDB.java:53)
    at org.sqlite.core.CoreConnection.open(CoreConnection.java:211)

Do I have to install any specific sqlite dependencies.

Tom

 

[TomDuncan]

I just tried sudo apt install sqlite3.
It is running 3.34.1
Tom

 

[Erel]

Which version of sqlite-jdbc are you using (#AdditionalJar: ...) ?

 

[TomDuncan]

#AdditionalJar: sqlite-jdbc-3.8.10.2

I can run the b4j-bridge.jar
doing a java -version I get

openjdk version "17-ea" 2021-09-14
Environment (build 17-ea+19-Debian-1)
openjdk 64-Bit Server VM

BTW I have put this is a standard 32bit Raspberry pi OS build.
Tom

 

[Erel]

Try it with the latest version: https://github.com/xerial/sqlite-jdbc/releases

 

[TomDuncan]

Try it with the latest version: https://github.com/xerial/sqlite-jdbc/releases

Yep fixed it thanks. Works like a charm.

 

[BillHart]

Yep fixed it thanks. Works like a charm.

Problem re-appears in 2023-12 xerial builds 3.33.xx thru latest 3.44.xx. I posted this also in a new thread.