How to connect to SQLite with IntelliJ Community Version?

[eugenedakin]

I am almost finished writing a book on Java with the IntelliJ IDEA IDE, and the last chapter is to connect to a SQLite database. How do I perform an SQL query with the IntelliJ community edition on a SQLite database with IntelliJ community edition using Java?

If the DB Browser plugin is not compatible, is there another plugin that works with the community edition for SQLite databases?

Thanks!

[npalardy]

have you got the jdbc driver for sqlite installed ?

you should be able to use that to connect & use the db browser

[HalGumbert]

Might be similar to PHPStorm…

Then click the + within Databases. Once connect then Edit Data

Lots of Connectors!

[eugenedakin]

Hi Hal,

Thanks for the screen grabs. Unfortunately, the Database selection is not an option.

Is this option only available on the Ultimate version maybe?

[npalardy]

I think its one of those things not enabled in Community TBH

[eugenedakin]

@npalardy

have you got the jdbc driver for sqlite installed ?

you should be able to use that to connect & use the db browser

I have DB browser installed and working. I don’t remember installing the jdbc driver, which means that I likely have not installed it. Do you a link to instructions for installing this driver? There are lots on google, with many being unreliable.

[npalardy]

might be fruitless at any rate

Ultimate vs. Community - Compare Editions | IntelliJ IDEA

I dont have it open and am busy working with client on some issues so cant take the time to peek

[thorstenstueker]

Eugene DBBrowser is for CE available. I just installed it on IntelliJIDea Community Edition. After install you can use it without any problem. Definitely.

[thorstenstueker]

@eugenedakin

I have DB browser installed and working. I don’t remember installing the jdbc driver, which means that I likely have not installed it. Do you a link to instructions for installing this driver? There are lots on google, with many being unreliable.

For what you need for the DB Browser a DB Driver / Connector? I can not really understand this Idea. DBBrowser has the SQLite connector build in.

To use SQLite with your App you need to download the Connector Jar and add it to the project Libraries before you can use it. There are several tutorials for SQLite Connecting with Java.

[eugenedakin]

Yes, you were right, the SQLite JDBC Driver was not installed. It works perfectly now.

Thank you!

[trishaduke]

I think you need install a db navigator plugin

[eugenedakin]

@trishaduke

I think you need install a db navigator plugin

Hi Trisha,

I installed Database Navigator plugin, and was not able to find an example on how to run a query with the plugin.

When using the sqlite-jdbc-3.36.0.3.jar JDBC Driver, I was able to perform a successful SQLite query with this code:

            String url = "jdbc:sqlite:D:\\user\\JavaIntelliJ\\InjelliJJavaBeginning\\Chapter13\\Example13-2.sqlite";
            try {
                Connection conn = DriverManager.getConnection(url);
                Statement st = conn.createStatement();
                ResultSet rs = st.executeQuery("Select * from TblBooks");

                while(rs.next()){
                    System.out.println(rs.getString("Title") + rs.getString("Author"));
                }

            } catch (SQLException er) {
                System.out.println(er.getMessage());
                System.out.println("An error occurred while connecting MySQL database");
            }

Do you have any suggestions on how to make it work with Database Navigator, or is there a specific db navigator plugin that is being used that has documentation?

Thank you

[trishaduke]

I manage to use the SQL console to create a new sql statement and run it.