Download Sqlite Jdbc 3.8 11.2 Jar

25 views

Skip to first unread message

Nichol Sadlon

unread,

Jan 9, 2024, 5:08:20 AM1/9/24

to lauwergula

Is SQLite running on your RPI? I have mySQL running well - but in addition to setting it up in OH2, you need to install and configure it. See -databases/set-up-an-sqlite-database-on-a-raspberry-pi.html for SQLite install.

I also ran in to that exact error when attempting to enable SQLite Persistence with Openhab2. The issue seems to be a bug in the sqlite_jdbc java library that is included with Openhab2. Specifically version 3.8.11.2. I tried to figure out how to update the version included but that version seems to be hard coded somewhere that I was unable to find.

download sqlite jdbc 3.8 11.2 jar

Download Zip https://diafortuze.blogspot.com/?h=2x67Bq

As a workaround, however, I downloaded a new version of the library from -jdbc/downloads then copied it overtop of /usr/share/openhab2/runtime/system/org/xerial/sqlite-jdbc/3.8.11.2/sqlite-jdbc-3.8.11.2.jar

Hi all,
after day of research i found that sqlite-jdbc version 3.8.11.2 works only in certain systems/processors. There is something wrong in compiled native library which resides inside of bundle. Bundle itself is dynamically downloaded on install and restart?

This is a development environment based on sqlite (original code base from windows environment), so this is a problem. Probably I need to consider how to force the installation of 3.32.x based sqlite with dnf if at all possible.
G

Same problem:[ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.10.1:compile (default-compile) on project sqlite-jdbc: Fatal error compiling: error: release version 8 not supported -> [Help 1]

java.lang.UnsatisfiedLinkError: /tmp/sqlite-3.39.2.0-10bfa1ff-bfe8-486d-8350-be204dc57fc6-libsqlitejdbc.so: /tmp/sqlite-3.39.2.0-10bfa1ff-bfe8-486d-8350-be204dc57fc6-libsqlitejdbc.so: classe ELF errata: ELFCLASS64 (Possible cause: architecture word width mismatch)

this property was not in the configuration (original hibernate config xml is in the first post)
now I added hibernate.jdbc.use_get_generated_keys = false and it seems to work fine.
Thanks a lot for your help!

Connect to the SQLite database by creating a URL string using the format jdbc:subprotocol:subname. The jdbc part of this string remains constant for any JDBC driver. subprotocol is a database type, in this case, sqlite. For SQLite, subname contains the location of the database. For example, your URL string is jdbc:sqlite:dbpath, where dbpath is the full path to your SQLite database on your computer. Enter your string in the URL box and press Enter.

Set the JDBC connection options. For example, this code assumes that you are connecting to a JDBC data source named SQLite, full path of the SQLite driver location C:\Drivers\sqlite-jdbc-3.8.11.2.jar, SQLite driver Java class object org.sqlite.JDBC, and URL string jdbc:sqlite:C:\Databases\sqlite.db.