Read and write to SQLite database from two different Java applications

Question

I have two application. One of those should write data to database, and another should read data. But "reader" throw exception "database locked".

What ways can be found out of this situation.

Ted Xu · Accepted Answer · 2012-02-02 15:10:23Z

2

it seems that the database isolation level is set to the serializable, which is the highest one among four. since two applications can access the database simultaneously, the read-only one can read some uncommitted data while write-only one is updating data but not commit yet.

So, if you are sure you want to read data while another one is updating, you can change the isolation level of the database. hope it helps.

answered Feb 2, 2012 at 15:10

Ted Xu

1,0931 gold badge11 silver badges20 bronze badges

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

2 Comments

christo Over a year ago

I'm sorry but I cannot find example which set isolation level :(

Ted Xu Over a year ago

@christo based on your tag, I assume you are using sqlite, just set PRAGMA read_uncommitted = True; should slove your problem sqlite.org/sharedcache.html

Collectives™ on Stack Overflow

Read and write to SQLite database from two different Java applications

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related