B4J Question [Solved] SQLite use with new Version?

[mw71]

hi,

i have
- add #AdditionalJar: sqlite-jdbc-3.31.1 (in Main Window at Project Attributes, File in Libary Folder)
- use ist with sql_k.initializesqlite
but with

Log(SQL_K.ExecQuerySingleResult( "SELECT sqlite_version()"))

(after load a File) i get 3.7.2 ???

What's the rigth way to use a newer SQLite Version??

 

[TILogistic]

sqlite connector (JDBC Java Database Connectivity)
sqlite-jdbc-3.31.1

Database Version sqlite3.
SELECT sqlite_version()
3.7.2

see:
version of the connector.

https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc

 

[mcqueccu]

hi,

i have
- add #AdditionalJar: sqlite-jdbc-3.31.1 (in Main Window at Project Attributes, File in Libary Folder)
- use ist with sql_k.initializesqlite
but with

Log(SQL_K.ExecQuerySingleResult( "SELECT sqlite_version()"))

(after load a File) i get 3.7.2 ???

What's the rigth way to use a newer SQLite Version??

I tried your code and it gave me the correct versions, with 2 different jdbc driver
'#AdditionalJar: sqlite-jdbc-3.27.2.1
#AdditionalJar: sqlite-jdbc-3.36.0.1

 

[TILogistic]

I tried your code and it gave me the correct versions, with 2 different jdbc driver
'#AdditionalJar: sqlite-jdbc-3.27.2.1
#AdditionalJar: sqlite-jdbc-3.36.0.1

jdbc is equal to sqlite version?

 

[TILogistic]

see:

2010-08-24 (3.7.2)​

Release History Of SQLite

www.sqlite.org

 

[TILogistic]

What's the rigth way to use a newer SQLite Version??

read:

SQLite Home Page

www.sqlite.org

 

[mw71]

Hello,

The version history of SQLite is known, so I want to use a newer version. The function I need was added in 3.7.15.

I have the download from https://repo1.maven.org/maven2/org/xerial/sqlite-jdbc/, others are also available. I copied the JAR file to the User Libary directory.

Unfortunately it always uses the 3.7.2 JAR from the internal directory (is this possible through a library?).

 

[TILogistic]

copy jar to Additional Libraries

See:

B4J:

 

[TILogistic]

error:

Unfortunately it always uses the 3.7.2 JAR from the internal directory (is this possible through a library?).

 

[mw71]

copy jar to Additional Libraries

See:
View attachment 123782
B4J:
View attachment 123783
View attachment 123784

yes, this is the location of the file I want to use (for me: C:\B4X_Support\Libary_User)

 

[TILogistic]

upload a sample app to review.

 

[TILogistic]

sample:

Main:

#Region Project Attributes
    #MainFormWidth: 600
    #MainFormHeight: 600
    #AdditionalJar: sqlite-jdbc-3.36.0.3
#End Region

Sub Process_Globals
    Private fx As JFX
    Private MainForm As Form
End Sub

 

[mw71]

sample:
View attachment 123787
Main:

#Region Project Attributes
    #MainFormWidth: 600
    #MainFormHeight: 600
    #AdditionalJar: sqlite-jdbc-3.36.0.3
#End Region

Sub Process_Globals
    Private fx As JFX
    Private MainForm As Form
End Sub

View attachment 123785

Test, it's show the correct Version 3.36...., than it crash (no problem)

Add B4XTable (i use this, V 1.21), it show 3.7.2
Is there any solution?

 

[mcqueccu]

create sample project and upload

 

[TILogistic]

See found error:
manifest B4Xtable

Version=1.21
B4J.DependsOn=B4XFormatter.b4xlib, jSQL, sqlite-jdbc-3.7.2
B4A.DependsOn=B4XFormatter.b4xlib, SQL
B4i.DependsOn=B4XFormatter.b4xlib, iSQL

main:

#Region Project Attributes
    #MainFormWidth: 600
    #MainFormHeight: 600
    #AdditionalJar: sqlite-jdbc-3.36.0.3
#End Region

Sub Process_Globals
    Private fx As JFX
    Private MainForm As Form
End Sub

 

[mw71]

hi,

my solution is to change the Line
B4J.DependsOn=B4XFormatter.b4xlib, jSQL, sqlite-jdbc-3.7.2
in the Copy of B4XTable Libary to sqlite-jdbc-3.36.0.3

Thank for your Help.