B4J Code Snippet Open Encrypted Sqlite Databases with B4J (SQLCipher)

Hi @mcqueccu
I used your example for testing
And I have to say that there are errors with individual JDBC:

'Working
#AdditionalJar: sqlite-jdbc-3.30.0
#AdditionalJar: sqlite-jdbc-3.31.1
#AdditionalJar: sqlite-jdbc-3.35.5.1

#AdditionalJar: slf4j-api-1.7.36

Click to expand...

java.io.FileNotFoundException: Version file is null
java.io.FileNotFoundException: Version file is null
DB Started

Click to expand...

#AdditionalJar: sqlite-jdbc-3.46.0.0
#AdditionalJar: slf4j-api-1.7.36

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
DB Started

Click to expand...

For now, I have not managed to test other (older) JDBC version.

It can be ignored, of course. But adding:

#AdditionalJar: slf4j-nop-1.7.36

Click to expand...

I get no warnings whatsoever. Cleaner log.

Hi @mcqueccu. Did you have any luck with the SQLCipher for B4J? I tried your project and it responds that the file is not a sqlite database.

Edit - With 3.7.2 and slf4j-api-1.7.36 it responds that it cannot find the table.

hatzisn said:

Hi @mcqueccu. Did you have any luck with the SQLCipher for B4J? I tried your project and it responds that the file is not a sqlite database.

Edit - With 3.7.2 and slf4j-api-1.7.36 it responds that it cannot find the table.

Click to expand...

It works fine. Make sure you using the recommended files

mcqueccu said:

It works fine. Make sure you using the recommended files

Click to expand...

Hi there !!!

well i ve tried your example with many sqlite drivers and with the recommended +slf4j-api-1.7.36... but the result was always the same:
org.sqlite.SQLiteException: [SQLITE_NOTADB] File opened that is not a database file (file is not a database)

I ve checked hundred of times if i was having something different... also tried open with db browser sqlcipher-version your file (and works)...
I ve also used direct path to database... but the same...
The error seems... comes when trying to open... the already founded file (so no path error)... and all seems that will go ok... but something other hits... not decrypting well, not using right the key passphrase in my b4j-jdk version (who knows)...

So I think the problem is deeper... so let's find it..

I am using B4J v10
Open JAVA JDK 19...

what versions are you using ?

ps: if the files are in additional folder (of libs) getting the same error with @hatzisn