Willena / sqlite-jdbc-crypt

SQLite JDBC Driver with encryption support
Apache License 2.0
172 stars 33 forks source link

Something wrong when using username and password #15

Closed Willena closed 4 years ago

Willena commented 4 years ago

When doing some tests (https://github.com/Willena/sqlite-jdbc-crypt/issues/14#issuecomment-604663038) for another issue, a bug appeared.

In the code provided the Test1 function should have failed but in fact not. You are always able to read the database even if the provided key in URI is different.

The username is always ignored. The password will be used as key.

IT IS NOT RECOMMENDED TO USE username AND password with SQLite databases. Please use URI configuration, Pragma configuration, or use classes in the org.sqlite.mc package to create the connection.

ivanooi commented 4 years ago

thanks