[SQLITE_NOTADB] File opened that is not a database file (file is not a database) when passing from 3.38.5 to higher

[emmedierre]

with this version :

<dependency>
	<groupId>io.github.willena</groupId>
	<artifactId>sqlite-jdbc</artifactId>
	<version>3.38.5</version>
</dependency>

and this code:

String myURL = "jdbc:sqlite:file:C:/temp/testdatabase.db?cipher=sqlcipher&legacy=3&kdf_iter=64000&legacy_page_size=1024";
String myUSR = "";
String myPASS = "xxx";
Connection conn = DriverManager.getConnection(myURL, myUSR, myPASS);

it's all ok!

If i upgrade to 3.39.0 version or higer (now i'm testing with 3.51.2.0)
i obtain an exception like this :

[SQLITE_NOTADB] File opened that is not a database file (file is not a database)

could you help me to upgrage the code ?

Thank you.

[Willena]

Hello,

Sorry for the delay.
You are not using the recommended way to open the database.

You should not use the user / password api of DriverManager as this is not a supported method.
To open a ciphered database see the configuration methods here: https://github.com/Willena/sqlite-jdbc-crypt/blob/master/USAGE.md#configuration-methods

Given your code, can you try using a PRAGMA key='xxx' statement

Keep in mind that I would prefer the more "modern" way to configure the connection introduced a while back.
The simple and configurable way I like to recommend is to use the SQLiteMCConfig classes:
It looks like you are using the SQLCipher v3 defaults parameters, so here is an example on how to created a connection:

        Connection c = SQLiteMCSqlCipherConfig.getV3Defaults()
                .withKey("xxx").build()
                .createConnection("jdbc:sqlite:file:C:/temp/testdatabase.db");

If required you can fully configure the connection using the setters on SQLiteMCSqlCipherConfig or SQLiteMCConfig

Hope it helped