Problems connecting to a database. Java/SQLite

Question

try {
    con = DriverManager.getConnection("jdbc:sqlite:db/Freepark.sqlite");
} catch (SQLException e) {
    // TODO Auto-generated catch block
    System.out.println("error al buscar la base de datos");
}

I am trying to do my first queries on an SQL database but I am having problems connecting to it. I think the problem is the URL for sure. The project name is BaseTest and inside project folder I have a subfolder called db and inside it is Freepark.sqlite. When I run the project the println message appears so I know that the problem is the URL. Things like class.forName are already done above this code sample.

Woot4Moo · Accepted Answer · 2010-12-03 17:58:18Z

2

First and foremost don't swallow the exception, which is what you are doing and why you are unable to figure out the root cause.

answered Dec 3, 2010 at 17:58

Woot4Moo

24.4k19 gold badges103 silver badges156 bronze badges

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

Comments

hvgotcodes · Accepted Answer · 2010-12-03 17:59:09Z

2

You are losing all of the exception information in your catch block. let the exception bubble up or otherwise print it.

you need to do something like

Class.forName("org.sqlite.JDBC");  
connection = DriverManager.getConnection("jdbc:sqlite:pathtodb");

answered Dec 3, 2010 at 17:59

hvgotcodes

121k33 gold badges209 silver badges237 bronze badges

Collectives™ on Stack Overflow

Problems connecting to a database. Java/SQLite

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related