How to Connect DB Navigator Plugin with SQLite
Answered
HI, I m using IntelliJ Community 2020.2 with Jdk 14. I added Sqlite Dependency in maven pom.xml. The driver is loaded but I dont know how to connect the database with the Intellij "DB Navigator" plugin. I have a demo Sqlite Database (chinook.db), which I put in a folder called "DB" in the root folder of my project and marked that folder as "resource". There are Two fields to fill up in the RED MARKED area in the picture, can somebody plz help me get it done. I want to use the DB navigator's default tool for CRUD functions.
N.B- I found that if I put the absolute path in the first field, Test Connection get successful. But I want Relative path bcoz the DB will be shipped with the app.
Please sign in to leave a comment.
Hello,
If you are referring to this plugin (Database Navigator by Dan Cioca), it is third-party, and so all issues related to it need to be submitted to the plugin's own issue tracker.
This may not be any issue/problem. I want to know how to get it working for Sqlite. What to put in those fields to get it to work.
If you are using a plugin that is not developed by JetBrains, the question should go to its author (you can log it to the plugin's tracker as e.g. a usability issue). I can only point you to IntelliJ IDEA's help page on how to create a data source connection to SQLite via standard built-in means:
https://www.jetbrains.com/help/idea/connecting-to-a-database.html#connect-to-sqlite-database