Network File based Databases with Java for multi application access

[drdespair]

Hello all.

I am trying to figure our what would be the appropriate database to use if I am limited to storing the database on a local network drive and it must allow multiple users using instances of the same desktop application to go in and update individual records without locking up the whole database per connection. From what I understand JavaDB can only have 1 active connection in that type of setup, or am I mistaken?

Thank you!

DrD

[Tolls]

In those situations you need a single database server that controls what goes on in the database.
You can't maintain integrity in the database file if you have multiple different database servers accessing it.

[drdespair]

I am coming from a VBA background. I have a tool made from excel forms that users use to update records in an Access Database. ADODB commands like:

rsData.Open "SomeTable", sConnect, adOpenForwardOnly, adLockOptimistic

allow to control the type of Locking that happens on the record.
Database servers are out of the question in my environment :( it has to be files on a network drive.

[JosAH]

JavaDB has two drivers: an embedded one for a single user and a network one for multiple users; if you use the network driver you should start a JavaDB server first. (it's all in the (excellent) documentation).

kind regards,

Jos

[drdespair]

So far all proposals here call for a server approach, this is not possible in my environment, I am not allowed to run my own server in the environment I am using, and they wont let me use existing servers ether. The data needs to be store in a file on a network drive and allow to multiple users to access for reading and updates individual records.