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

User · Answer

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 !

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

connection   DriverManager getConnection  jdbc sqlite D   testdb db      Instead of this put  connection   DriverManager getConnection  jdbc sqlite D   testdb

User · Answer

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

User · Answer

If you are using Netbeans using Maven to add library is easier  I have tried using above solutions but it didn t work    lt dependencies gt       lt dependency gt         lt groupId gt org xerial lt  groupId gt         lt artifactId gt sqlite-jdbc lt  artifactId gt         lt version gt 3 7 2 lt  version gt       lt  dependency gt   lt  dependencies gt    I have added Maven dependency and java lang ClassNotFoundException  org sqlite JDBC error gone

User · Answer

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

User · Answer

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

[java] How to connect SQLite with Java?

Examples related to java

Examples related to sqlite

Examples related to jdbc

Examples related to classpath