Where to place SQLite 3 database for use in a Java Project in Eclipse

My Eclipse Java project path is as follows: ~/workspace/PayrollApp/src/org/username/payrollapp/payroll.db

I had placed the SQLite database file payroll.db in the above path, and found it was not getting used when I ran the Java program.

Upon inspecting the contents of ~/workspace/PayrollApp, I found that payroll.db was there with 0 bytes. That implied that the file needs . . . → Read More: Where to place SQLite 3 database for use in a Java Project in Eclipse

Write Ahead Logging in SQLite 3.7.0 version and above

So far, SQLite did support transaction control, but entirely in memory. Version 3.7.0+ of SQLite now have a Write-Ahead Logging feature that allow more speed and flexibility to SQLite to manage record locking and journal management. This feature is called ‘wal’ in SQLite 3.7.0+. To activate WAL on a SQLite database, start up SQLite and . . . → Read More: Write Ahead Logging in SQLite 3.7.0 version and above

Use SQLite with Java

In order to use SQLite 3 with Java, you need to do the following steps on your Linux or Windows box. I have deliberately kept off specific commands.

Install SQLite3 from your Linux distribution repository. You can also download the Windows edition if you use Windows. Visit https://bitbucket.org/xerial/sqlite-jdbc and download the JDBC driver. I downloaded . . . → Read More: Use SQLite with Java

September 2019
M T W T F S S
« Aug    
 1
2345678
9101112131415
16171819202122
23242526272829
30