How to avoid sql exceptions when two java desktop applications uses same SQLite db

Question

I see some answers about this but they do not point in my direction.

When writing to SQLite all concurrent reads/writes will throw an exception.
This is going to be a problem for my setup since i have:

java background service
java Desktop gui application

Both accessing the same SQLite on the same computer.
Is there some global Singelton setup to deal with this.

Any ides would be grate

What driver are you using to access SQLite? It sounds like you just need to turn on the concurrency features — Brendan Long
– Brendan Long, Commented Nov 18, 2011 at 23:13

Brendan Long · Accepted Answer · 2011-11-18 23:29:59Z

1

From the sqlite4java page:

Single-threaded model - each SQLite connection is confined to a single thread, all calls must come from that thread. Application may open several connections to the same database from different threads. Along with the Serializable isolation level from SQLite, this feature facilitates writing very clean and predictable code.

So you need to either:

Have a dedicated thread that talks to SQLite
Open a new connection for each thread

answered Nov 18, 2011 at 23:29

Brendan Long

54.5k21 gold badges154 silver badges194 bronze badges

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

4 Comments

Erik Over a year ago

It sound like i should use a singelton class for the db connection. What do you think?. Just found this example: danfolkes.com/2011/05/20/…

Brendan Long Over a year ago

@Erik - A singleton won't work if you're accessing it from multiple threads.

Erik Over a year ago

I will actually not have multiple threads. Another thing is this with that i have two java applications. you say turn on the concurrency features. Does that mean that my "reads/write" will be synchronized and go into wait mode if the other java app have the write lock.

Brendan Long Over a year ago

@Erik - It sounds like the library you're using is fine with two programs using the same database by default, and yes it will use some kind of locking.

Collectives™ on Stack Overflow

How to avoid sql exceptions when two java desktop applications uses same SQLite db

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related