Android Question How Create a wraper sqlite-3430000

[N. Franz]

I am trying to create a sqlite wrapper different from android native sqlte from https://www.sqlite.org/download.html
since a client wants to have the characteristics of said version for b4a. and try to create a wrapper. I try to make it very similar to the b4a wrapper but my attempts lead to the same message from
java.lang.UnsatisfiedLinkError: No implementation found for long org.sqlite.database.sqlite.SQLiteConnection.nativeOpen(java.lang.String, int, java.lang.String, boolean, boolean) (tried Java_org_sqlite_database_sqlite_SQLiteConnection_nativeOpen and Java_org_sqlite_database _sqlite_SQLiteConnection_nativeOpen__Ljava_lang_String_2ILjava_lang_String_2ZZ)

I can't manage to open at least one database. so I decide to come to you, great connoisseurs. I hope I can find a direction to go.

reasons why I want to achieve this.

- sqlite3_column_type which for now I'm doing it with
Cursor..RunMethod("getType",Array(x)

- Older versions of SQLite do not support RIGHT JOIN

i am trying it with slc tool

and in b4a
I am including #AdditionalJar: sqlite-android-3430000.aar

I have tried extracting clasess.java. and the same result

 

[Erel]

If it is implemented as a standard jdbc driver then you can use JdbcSQL library and don't need to create any wrapper.

 

[OliverA]

Another option is the use of the SQLCipher library (https://www.b4x.com/android/forum/threads/android-database-encryption-with-sqlcipher-library.14965/). It's solved similar "stock Android SQLite does not support a given function/feature problem" in these cases:

sqlite "no such function" runtime error

Dear all, I have successfully done following queries in DB Browser for SQLite: INSERT INTO tblUser (name, phone) values("oz", json('{"cell":"+491765", "home":"+498973"}')); SELECT json_set(tblUser.phone, '$.cell', '123') FROM tblUser; SELECT tblUser.name From tblUser WHERE...

www.b4x.com

sqlite3 fts5

is sqlite3 fts5 option supported by B4A ?

www.b4x.com

No wrappers needed, and the only code change (as it relates to SQLite usage under B4A) is the initialization routine.