Inconsistency in SQLite-DB between Eclipse-project and SQLite Manager

Question

I am developing a Java-application, which is using an SQLite-database. To have a better view of the data and to change the tables easier, I am using the Firefox plugin "SQLite Manager".

The sqlite-database is placed in my src-folder (src/db/db.sqlite). If I open the database from that location, the database shows old entries.

Instead, I have a method in my code, which is reading all data from the table, and writing it into a .docx. Here I can see the data, I previously wrote into the table in another method.

It looked like Eclipse was locking the database-file somehow. Copying it to another location, and reopen it from there with the SQLite-Manager, still showed old entries.

Edit: Now I added another column to my table and deleted the content of the table with the SQLite Manager. If I export the content of my table to a .docx again, I get en empty .docx, which tells me that the database now is consistent again with what is shown in the SQLite Manager.

I didn't manage to find an answer to that behaviour in the web. Does anyone know, why this happens?

@cricket_007 You were right. Choosing it from the /bin-directory gave me the correct database. — KJaeg
– KJaeg, Commented Jun 12, 2016 at 12:15
If you post this as an answer, I would like to mark it as the top answer. — KJaeg
– KJaeg, Commented Jun 12, 2016 at 12:31

Community · Accepted Answer · 2017-05-23 12:31:48Z

1

In Eclipse, your database is probably copied to the bin/ directory because you've included it under the src/ directory.

You should move your database file somewhere where you can load it from the resource loader instead of referencing the direct filepath on your disk.

edited May 23, 2017 at 12:31

CommunityBot

11 silver badge

answered Jun 12, 2016 at 15:36

OneCricketeer

193k20 gold badges146 silver badges276 bronze badges

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

Collectives™ on Stack Overflow

Inconsistency in SQLite-DB between Eclipse-project and SQLite Manager

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related