I am using SQLite JDBC driver from xerial project.
Can i secure my sqlite db using username & password with java? If yes, how?
Any help is appreciated.
Thanks in advance.
2
-
read this stackoverflow.com/questions/1807320/username-in-sqlite3Youcef LAIDANI– Youcef LAIDANI2017-12-22 14:25:48 +00:00Commented Dec 22, 2017 at 14:25
-
1no idea @Md. Minhaz Nihal, but a quick search guide me to encryption read this security.stackexchange.com/questions/63343/… and developer.blackberry.com/bbos/java/documentation/…Youcef LAIDANI– Youcef LAIDANI2017-12-22 14:38:24 +00:00Commented Dec 22, 2017 at 14:38
Add a comment
|
1 Answer
I do not know, is this answer necessary for you now? But hope this answer can help other people, who have faced kind of similar problems.
- First of all, The base SQLite engine doesn't have any password/encryption options. So you can not set a username and password.
- As base SQLite does not include an encryption option. That is available as a paid option (SEE) from the suppliers of SQLite, or there are other 3rd party options available.
- For JDBC especially, you can follow this github repository. Here you find the way around to secure your SQLite DB. In their Readme file, you will find this code-block, how they create their DB Connection string. But before this, you have to configure encryption mode.
//Using the SQLiteMC default parameters
Connection connection = DriverManager.getConnection("jdbc:sqlite:file:file.db", new SQLiteMCConfig().withKey("Key").toProperties());
Connection connection = new SQLiteMCConfig().withKey("Key").createConnection("jdbc:sqlite:file:file.db");
//Using Chacha20
Connection connection = DriverManager.getConnection("jdbc:sqlite:file:file.db", SQLiteMCChacha20Config.getDefault().withKey("Key").toProperties());
Connection connection = SQLiteMCChacha20Config.getDefault().withKey("Key").createConnection("jdbc:sqlite:file:file.db");
- As you use JDBC, that means your application is java based, in that case, H2 DB will well suit your application. It has strong security features.
