Bug? sqlite-jdbc ignored

[aeric]

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]

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

 

[aeric]

Can I have a link to download version 10.00 ?

 

[Erel]

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

 

[aeric]

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

 

[aeric]

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]

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