Bug? sqlite-jdbc ignored

aeric

Expert

Licensed User

Longtime User

• Mar 25, 2025

• #1

I am running B4J version 10.20
The IDE ignores additional jar and seems it is loading a default SQLite JDBC library.
#AdditionalJar: sqlite-jdbc-3.49.1.0

 

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Mar 25, 2025

• #2

I don't think that it is possible. The problem is somewhere else...

 

aeric

Expert

Licensed User

Longtime User

• Mar 25, 2025

• #3

Can I have a link to download version 10.00 ?

 

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Mar 25, 2025

• #4

Sure: https://www.b4x.com/b4j/files/B4J_10_0.exe

 

aeric

Expert

Licensed User

Longtime User

• Mar 25, 2025

• #5

I suspect the IDE takes the default sqlite-jdbc from B4XTable library.
If I remove B4XTable then my query passed.

 

aeric

Expert

Licensed User

Longtime User

• Mar 25, 2025

• #6

Now I recall this issue.

Update sqlite-jdbc-3.7.2.jar dependency in B4XTable

sqlite-jdbc-3.7.2.jar is the default SQLite JDBC library comes with B4X IDEs installation but it is quite old. The good thing about this version is it is very small (3.05MB only). The bad thing is, it is a dependency for B4XTable for B4J. Recently, I tried to execute a SQLite query in B4J...

www.b4x.com

jSQL ... need to upgrade ?

Hi, I have a SQLite problem with a simple query ... When I run this query from windows, I get correct results. When I run it from B4J, I get wrong results. I just upgrade to B4J version 9.80, the jSQL.jar date is 2022-07-05 (version 1.61 in B4J IDE) Should I upgrade to a more recent jSQL.jar...

www.b4x.com

 

aeric

Expert

Licensed User

Longtime User

• Mar 25, 2025

• #7

I removed the sqlite-jdbc-3.7.2 in manifest.txt inside B4XTable.b4xlib as written by @OliverA for now.