What's the difference about database file locking between Oracle and H2?

122 Views Asked by At

If we want an data file able to visit by more than one H2 server, we may have to add FILE_LOCK=NO to the jdbc url. But H2 documentation Database File Locking mentioned that this is unsafe as another process is able to open the same database, possibly leading to data corruption. What's the potential risk here if we use h2 in java application? Does oracle has the same risk if we don't apply file_lock to oracle?

0

There are 0 best solutions below