B4J Question Sqlite-jdbc update problem

[drgottjr]

regarding https://www.b4x.com/android/forum/threads/sqlite-jdbc-library-version-updates.133792/ (posted 18/10/2023)

i only have 1 project in b4j and uses sqlite, and i'm ashamed to say that i've fallen behind on updating Sqlite-jdbc. (and many thanks to forum memberr oliveira for, at least, attempting to keep us all informed).

for what it's worth, the last version that compiles for me without error is 3.43.0.0. both 3.43.2.0 and 3.43.2.1 cause the same issue, which 3.43.2.1 claims to fix.

this is the fix mentioned for 3.43.2.1: do not initialize logging framework at build-time (d8f762c)

please refer to the attached images:
on the left side, you can see the version being used, and in the log, you can see the very logging framework error which is mentioned in the list of fixes. 3.43.2.0 and 3.43.2.1 cause the logging initialization error, while 3.43.0.0 does not.

i'm guessing another dependency might need to be updated, but i have only had to reference Sqlite-jdbc in the past, and any updates to that library worked fine until 3.43.0.0

 

[aeric]

Try add this lines:

#AdditionalJar: slf4j-api-2.0.9

edit: remove unnecessary slf4j-jdk14 dependency

 

[drgottjr]

thanks. i've added your suggestion to the project, but commented it out since i don't have those jars. technically, no problem to download, but i'm not sure now exactly what i'm getting myself into, given how i use sqlite in the project. i'll have to check those posts notifying us of the updates to see what's going on first. the project itself uses an older version of sqlite, so the benefits of support for a newer version of sqlite - for this project at least - are moot. i appreciate the interest in any case.

also, the latest version mentions backing down to version slf4j 1.7, so i'm not sure i should be using 2.09 ...

 

[aeric]

no problem to download

Yes, you also need to download the additional jars as I listed.

#AdditionalJar: slf4j-api-2.0.9
#AdditionalJar: sqlite-jdbc-3.43.2.0

slf4j-api-2.0.9

#AdditionalJar: slf4j-api-1.7.36
#AdditionalJar: sqlite-jdbc-3.43.2.1

slf4j-api-1.7.36

fix: downgrade SLF4J to 1.7 · xerial/sqlite-jdbc@874a926

Closes: #990 Co-authored-by: Gauthier Roebroeck <[email protected]>

github.com

Root cause is in sqlite-jdbc-3.43.2.0:
makefile

• add slf4j dependency (1663cfe)

sqlite-jdbc-3.43.0.0 does not have this dependency.

If you don't want to add the slf4j dependency then stick to sqlite-jdbc-3.43.0.0

edit: removed slf4j-jdk14

 

[aeric]

Update: slf4j-jdk14 is not required

SQLiteJDBC and slf4j

Hi all! An important observation about SQLiteJDBC. Starting with version 3.43.2.0, the authors of the SQLiteJDBC library added the SLF4J logging framework as a dependency. You can find more information about this HERE. Therefore, applications using SQLiteJDBC version 3.43.2.0 and higher must...

www.b4x.com