B4J Question Sqlite-jdbc update problem

drgottjr

Expert
Licensed User
Longtime User
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
 

Attachments

  • 1.png
    1.png
    10.7 KB · Views: 75
  • 2.png
    2.png
    12.6 KB · Views: 78
  • 3.png
    3.png
    7.4 KB · Views: 78

drgottjr

Expert
Licensed User
Longtime User
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 ...
 
Last edited:
Upvote 0

aeric

Expert
Licensed User
Longtime User
no problem to download
Yes, you also need to download the additional jars as I listed.

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

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


Root cause is in sqlite-jdbc-3.43.2.0:
makefile
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
 
Last edited:
Upvote 0
Top