How to set up SQLite for Java under Ubuntu?

Question

I would like to use SQLite for some database functionality with a Java program I am implementing, but I don't know how to install SQLite and make it work with Java under Ubuntu.

Any help is appreciated

cdeszaq · Accepted Answer · 2012-03-28 19:04:30Z

3

You will need a JDBC driver for SQLite in order to access it from your java app.

Then, to set up sqlite under ubuntu apt-get install cl-sql-sqlite3 sqlitebrowser.

Sqlite browser is quite practical. Nevertheless, I would suggest you consider that sqlite is not the easiest way to deploy a java database. You should have a look at javadb.

edited Mar 28, 2012 at 19:04

cdeszaq

31.4k27 gold badges123 silver badges176 bronze badges

answered Aug 20, 2011 at 15:28

Snicolas

38.2k15 gold badges118 silver badges177 bronze badges

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

1 Comment

SL5net Over a year ago

your link to JDBC driver for SQLite is dead ( 20210305123557 )

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

I'd recomment SQLJet.

What is SQLJet

SQLJet is an independent pure Java implementation of a popular SQLite database management system. SQLJet is a software library that provides API that enables Java application to read and modify SQLite databases.

Check out their tutorial.

To install, just download the Library and add it to your classpath.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Aug 20, 2011 at 15:27

dertkw

7,8585 gold badges39 silver badges45 bronze badges

Collectives™ on Stack Overflow

How to set up SQLite for Java under Ubuntu?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related