Multiple access to a single derby database

Question

I have created a simple java desktop application using derby database, I have used embedded driver to connect the database.

The problem is derby database can't access by multiple time using embedded database.

If more than one client application tries to access the database, shared lock occurs.

How can I make the database access by the multi user at the same time?

What driver I want to use for that?

Answer 1

Embedded Derby cannot be booted (opened) by multiple JVMs, though multiple accesses from the JVM which booted the database are allowed. If you want to access the same Derby database from multiple applications (JVMs), you should use Derby Network Server.