how to connect sqlite3 with cipher type : WxSQLite3 ,Cipher : system.data.rc4 encrypted database using java or else remove the password for database

[ShadowTechnology]

I already have Sqlite3 database with cipher type : WxSQLite3 ,Cipher : system.data.rc4 encrypted and know i want to connect this database using java and run the table i wanted. but when i tried to connect this database it says File opened that is not a database file error occurs. Or remove the password for my database. and i attached the code and database file in zip file to check the code is correct or not
Databasezip.zip

[pawelsalawa]

Execute PRAGMA rekey = ''; in SQLiteStudio on the encrypted database. This should remove encryption. You should be able to open it now in your Java app.

Keep in mind that SQLiteStudio will still try to open it using configured password, so best way is to remove the database from SQLiteStudio and re-add it using regular "SQLite 3" driver, so without any encryption.

[ShadowTechnology]

Thanks Pawelsalawa

…

On Mon, Aug 28, 2023 at 3:57 AM Paweł Salawa ***@***.***> wrote: Execute PRAGMA rekey = ''; in SQLiteStudio on the encrypted database. This should remove encryption. You should be able to open it now in your Java app. Keep in mind that SQLiteStudio will still try to open it using configured password, so best way is to remove the database from SQLiteStudio and re-add it using regular "SQLite 3" driver, so without any encryption. — Reply to this email directly, view it on GitHub <#4858 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BAWLVV5GSIYQ7BJWLX3VGZTXXPCUPANCNFSM6AAAAAA36MNS2Q> . You are receiving this because you authored the thread.Message ID: ***@***.*** com>