How to connect SQLite with Java?

Question

I am using one simple code to access the SQLite database from Java application . My code is

 import java.sql.Connection;  
 import java.sql.DriverManager;  
 import java.sql.ResultSet;  
 import java.sql.Statement;  
 public class ConnectSQLite 
 {  
  public static void main(String[] args) 
  {  
     Connection connection = null;  
     ResultSet resultSet = null;  
     Statement statement = null;  

     try 
     {  
         Class.forName("org.sqlite.JDBC");  
         connection = DriverManager.getConnection("jdbc:sqlite:D:\\testdb.db");  
         statement = connection.createStatement();  
         resultSet = statement  
                 .executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");  
         while (resultSet.next()) 
         {  
             System.out.println("EMPLOYEE NAME:"  
                     + resultSet.getString("EMPNAME"));  
         }  
     } 
     catch (Exception e) 
     {  
         e.printStackTrace();  
     }
     finally 
     {  
         try 
         {  
             resultSet.close();  
             statement.close();  
             connection.close();  
         } 
         catch (Exception e) 
         {  
             e.printStackTrace();  
         }  
     }  
 }  
}

But this code gives one exception like

java.lang.ClassNotFoundException: org.sqlite.JDBC

How can I slove this,please help me.

I guess you are not putting SQLite jar in classpath

vpram86
– vpram86

2009-10-06 13:04:50 +00:00
Commented Oct 6, 2009 at 13:04 — vpram86
– vpram86, Commented Oct 6, 2009 at 13:04

kevinarpe · Accepted Answer · 2017-03-31 06:28:10Z

72

You need to have a SQLite JDBC driver in your classpath.

Taro L. Saito (xerial) forked the Zentus project and now maintains it under the name sqlite-jdbc. It bundles the native drivers for major platforms so you don't need to configure them separately.

edited Mar 31, 2017 at 6:28

kevinarpe

21.6k28 gold badges137 silver badges170 bronze badges

answered Oct 6, 2009 at 13:04

Reverend Gonzo

41.1k6 gold badges61 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Dyapa Srikanth Over a year ago

i am using this driver, and works fine. But why it is not compacting database while creating.With FireFox sqlite plugin Database compacted from 11.5MB to 11.3MB. how to do that with java.

Donal Fellows Over a year ago

@Dyapa You need to periodically run VACUUM; since JDBC doesn't actually interpret the SQL (for very good reasons) just send it over. Or use a pragma per connection to run in auto-vacuum mode.

Dyapa Srikanth Over a year ago

@DonalFellows can u explain how to run VACUUM through java.

Roy Hinkley Over a year ago

For those experiencing this issue with Tomcat this jar needs to be put into the lib folder for respective Tomcat version. Tomcat will also need to be restarted. In the web application, the jar needs to be placed into the WEB-INF lib folder as well. You don't need to add it to the build path because putting it in the WEB-INF lib folder places it there automatically.

tonytony Over a year ago

@AndroidAddict Thank you bro you saved hours of my time :)

|

lesce · Accepted Answer · 2010-05-04 13:13:57Z

9

If you are using netbeans Download the sqlitejdbc driver Right click the Libraries folder from the Project window and select Add Library , then click on the Create button enter the Library name (SQLite) and hit OK

You have to add the sqlitejdbc driver to the class path , click on the Add Jar/Folder.. button and select the sqlitejdbc file you've downloaded previously Hit OK and you are ready to go !

answered May 4, 2010 at 13:13

lesce

6,3245 gold badges32 silver badges35 bronze badges

1 Comment

Indigo Over a year ago

I struggled a lot because of this problem. I am a Java newbie and using Netbeans. It's been a frustration. Finally, your answer saved my day.

Olcay Ertaş · Accepted Answer · 2016-10-19 19:35:11Z

8

If you are using Netbeans using Maven to add library is easier. I have tried using above solutions but it didn't work.

<dependencies>
    <dependency>
      <groupId>org.xerial</groupId>
      <artifactId>sqlite-jdbc</artifactId>
      <version>3.7.2</version>
    </dependency>
</dependencies>

I have added Maven dependency and java.lang.ClassNotFoundException: org.sqlite.JDBC error gone.

edited Oct 19, 2016 at 19:35

answered May 18, 2015 at 12:54

Olcay Ertaş

6,2648 gold badges82 silver badges116 bronze badges

Comments

MeanderingCoder · Accepted Answer · 2011-05-31 23:47:13Z

6

I'm using Eclipse and I copied your code and got the same error. I then opened up the project properties->Java Build Path -> Libraries->Add External JARs... c:\jrun4\lib\sqlitejdbc-v056.jar Worked like a charm. You may need to restart your web server if you've just copied the .jar file.

answered May 31, 2011 at 23:47

MeanderingCoder

611 silver badge1 bronze badge

Comments

Thev · Accepted Answer · 2016-06-01 09:28:44Z

5

You have to download and add the SQLite JDBC driver to your classpath.
You can download from here https://bitbucket.org/xerial/sqlite-jdbc/downloads

If you use Gradle, you will only have to add the SQLite dependency:

dependencies {
    compile 'org.xerial:sqlite-jdbc:3.8.11.2'
}

Next thing you have to do is to initialize the driver:

try {
    Class.forName("org.sqlite.JDBC");
} catch (ClassNotFoundException eString) {
    System.err.println("Could not init JDBC driver - driver not found");
}

answered Jun 1, 2016 at 9:28

Thev

711 silver badge4 bronze badges

1 Comment

nicovell3 Over a year ago

I had added that gradle option, but I was missing the driver initialization. Thank you so much for that snippet!

user2402433 · Accepted Answer · 2013-10-16 09:02:57Z

4

    import java.sql.ResultSet;
    import java.sql.SQLException;
    import javax.swing.JOptionPane;
    import org.sqlite.SQLiteDataSource;
    import org.sqlite.SQLiteJDBCLoader;

    public class Test {

        public static final boolean Connected() {
            boolean initialize = SQLiteJDBCLoader.initialize();

            SQLiteDataSource dataSource = new SQLiteDataSource();
            dataSource.setUrl("jdbc:sqlite:/home/users.sqlite");
            int i=0;
            try {
                ResultSet executeQuery = dataSource.getConnection()
                        .createStatement().executeQuery("select * from \"Table\"");
                while (executeQuery.next()) {
i++;
                    System.out.println("out: "+executeQuery.getMetaData().getColumnLabel(i));

                }



            } catch (SQLException ex) {
                JOptionPane.showMessageDialog(null, ex);
            }

            return initialize;

        }

edited Oct 16, 2013 at 9:02

answered Oct 16, 2013 at 8:53

user2402433

412 bronze badges

1 Comment

kmort Over a year ago

I was using dataSource.setDatabaseName(...) and it wasn't working. Now I see I needed to use dataSource.setUrl(...). Thanks. :-)

Donal Fellows · Accepted Answer · 2012-05-24 13:09:16Z

1

connection = DriverManager.getConnection("jdbc:sqlite:D:\\testdb.db");

Instead of this put

connection = DriverManager.getConnection("jdbc:sqlite:D:\\testdb");

edited May 24, 2012 at 13:09

Donal Fellows

139k19 gold badges161 silver badges222 bronze badges

answered May 24, 2012 at 12:39

Vasanth Kumar

1071 gold badge1 silver badge9 bronze badges

Comments

fiddle · Accepted Answer · 2013-02-05 07:10:35Z

1

Hey i have posted a video tutorial on youtube about this, you can check that and you can find here the sample code :

http://myfundatimemachine.blogspot.in/2012/06/database-connection-to-java-application.html

answered Feb 5, 2013 at 7:10

fiddle

1,1925 gold badges20 silver badges33 bronze badges

1 Comment

Davoud Taghawi-Nejad Over a year ago

Its a lot of irrelevant code to learn about a relatively specific problem. Not saying its a bad video/code, but not specific for this problem.

Deepak S. Gavkar · Accepted Answer · 2013-07-31 18:42:46Z

0

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;   


public class Connectdatabase {

        Connection con = null;

        public static Connection ConnecrDb(){

            try{
                //String dir = System.getProperty("user.dir");
                Class.forName("org.sqlite.JDBC");
                Connection con = DriverManager.getConnection("jdbc:sqlite:D:\\testdb.db");
                return con;
            }
            catch(ClassNotFoundException | SQLException e){
                JOptionPane.showMessageDialog(null,"Problem with connection of database");
                return null;
            }
        }

    }

answered Jul 31, 2013 at 18:42

Deepak S. Gavkar

4578 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to connect SQLite with Java?

9 Answers 9

7 Comments

1 Comment

Comments

Comments

1 Comment

1 Comment

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

9 Answers 9

7 Comments

1 Comment

Comments

Comments

1 Comment

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related