Java: Missing Database error

Question

I am getting the following error:

java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: apartments)

In reality, the table does exist. The following is my code:

try {
    // load the sqlite-JDBC driver using the current class loader
    Class.forName("org.sqlite.JDBC");
    Connection connection = null;
    // create a database connection
    connection = DriverManager.getConnection("jdbc:sqlite:/Path/To/apartments.db");
    System.out.println(connection.getMetaData());
    Statement statement = connection.createStatement();
    statement.setQueryTimeout(30);

    ResultSet rs = statement.executeQuery("select * from apartments");
    while(rs.next()) {
        // read the result set
        System.out.println("TEXT = " + rs.getString("display_text"));
        System.out.println("X1 = " + rs.getInt("x1"));
    }
} catch (Exception ex) {
    Logger.getLogger(MouseEventDemo.class.getName()).log(Level.SEVERE, null, ex);
}

It says SQL error or missing database , and I guess it's not table issue — Volatil3
– Volatil3, Commented Feb 21, 2013 at 9:32
I thing that your are confusing the database name with table name. Your database name is apartments and table's name also the same? — Festus Tamakloe
– Festus Tamakloe, Commented Feb 21, 2013 at 9:35
I think it is a path issue. Try giving the full path in getConnection() — Rahul
– Rahul, Commented Feb 21, 2013 at 9:35
@FestusTamakloe my db name is main, I am not finding the way to mention DB name. It's SQLIte — Volatil3
– Volatil3, Commented Feb 21, 2013 at 10:05

Festus Tamakloe · Accepted Answer · 2013-02-21 13:15:40Z

8

May be this can help you to get right path to you database

How to Specify Database Files

Here is an example to select a file C:\work\mydatabase.db (in Windows)

Connection connection = DriverManager.getConnection("jdbc:sqlite:C:/work/mydatabase.db");

A UNIX (Linux, Mac OS X, etc) file /home/leo/work/mydatabase.db

Connection connection = DriverManager.getConnection("jdbc:sqlite:/home/leo/work/mydatabase.db");

How to Use Memory Databases SQLite supports on-memory database management, which does not create any database files. To use a memory database in your Java code, get the database connection as follows:

Connection connection = DriverManager.getConnection("jdbc:sqlite::memory:");

This also can help

String path=this.getClass().getResource("apartments.db").getPath();
            connection = DriverManager.getConnection("jdbc:sqlite:"+path);

assumes that apartments.db is put in project root directory

edited Feb 21, 2013 at 13:15

answered Feb 21, 2013 at 10:16

Festus Tamakloe

11.3k9 gold badges55 silver badges66 bronze badges

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

18 Comments

Volatil3 Over a year ago

I tried this: getConnection("jdbc:sqlite:"+getClass().getResource("apartments.db")); and now it gives error: path to 'file:/path/to/apartments.db': '/paht/to/file:' does not exist I don't get why it's adding file string in the end.

Festus Tamakloe Over a year ago

Connection connection = DriverManager.getConnection("jdbc:sqlite:/home/leo/work/mydatabase.db"); doesn't work for you? then try to copy & paste your database into your project root and get it with getConnection("jdbc:sqlite:"+getClass().getResource("apartments.db"));

Volatil3 Over a year ago

It's looling in build/class. see this: java.sql.SQLException: path to 'file:/xxxx/xx/demo/build/classes/events/apartments.db': '/xxxx/xx/demo/file:' does not exist

Volatil3 Over a year ago

I have put file in every subfolder and root folder, may it pick from somewhere but none :)

Festus Tamakloe Over a year ago

if you put it in root then try to call this getConnection("jdbc:sqlite:"+getClass().getResource("apartments.db")); exactly without nothing else

|

Azad · Accepted Answer · 2013-02-21 10:16:36Z

1

Change The Extension .db to .sqlite

connection = DriverManager.getConnection("jdbc:sqlite:Path\\To\\apartments.sqlite");

answered Feb 21, 2013 at 10:16

Azad

5,05523 silver badges38 bronze badges

2 Comments

Volatil3 Over a year ago

I have explicitly give .db to filename. Changing did not make difference.

CrazedCoder Over a year ago

Thank you! Finally fixed the issue I have been attempting to resolve for hours

Farrukh Najmi · Accepted Answer · 2014-05-30 11:53:51Z

I had the same problem when running my unit tests from Robolectric on Android platform. The problem turned out to be related to something to do with using a singleton pattern on my DatabaseHelper class which was being reused by all my unit tests as it was a static object created by a base class for all my unit tests.

In my case the fix was to set the static variable caching the singleton instance inside the DatabaseHelper to null after each test. SO the base class looks something like this for me:

import com.foo.app.HomeActivity;
import com.foo.contentProvider.DatabaseHelper;

import org.junit.After;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.runner.RunWith;
import org.robolectric.Robolectric;
import org.robolectric.RobolectricTestRunner;
import org.robolectric.annotation.Config;

import static org.junit.Assert.assertNotNull;

@Config(shadows = {ShadowCaseSensitiveSQLiteCursor.class})
@RunWith(RobolectricTestRunner.class)  // <== REQUIRED for Robolectric!
public class RobolectricTestBase {

    protected HomeActivity activity;
    protected Context context;
    protected DatabaseHelper databaseHelper;

    @BeforeClass
    public static void setupClass() {
        // To redirect Robolectric to stdout
        System.setProperty("robolectric.logging", "stdout");
    }

    @Before
    public void setup() {
        activity = (HomeActivity) Robolectric.buildActivity(HomeActivity.class).create().get();
        assertNotNull(activity);
        context = activity.getApplicationContext();
        assertNotNull(context);
        databaseHelper = DatabaseHelper.getInstance(context);
        assertNotNull(databaseHelper);
    }

    @After
    public void tearDown() {
        databaseHelper.close();  //This is where singleton INSTANCE var is set to null
    }
}

Collectives™ on Stack Overflow

Java: Missing Database error

3 Answers 3

18 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

18 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related