title: How do I allow multiple users to connect to my H2 database simultaneously?
body: <p>I am using H2 for database management, and this is what I would like to do:</p>
  
  <p>I would like to allow multiple users to access a database at the same time. I've read a bit about "MULTI_THREADED=TRUE", "LOCK_FILE=NO", and "AUTO_SERVER=TRUE". I've also read that "LOCK_FILE=NO" can be dangerous, because it can corrupt the database. I definitely would not want this, so I'm assuming that is a bad way to go. I've also tried to close the connection immediately after a record is accessed, whether it is being read from or written to. So far, nothing seems to work. The application is not allowing me to read from or write to the database if the database has been connected to in a separate instance of the application (ex: on another computer). Once I completely close the application on one computer, I am able to access the database records.</p>
  
  <p>How do I allow multiple users to connect to the H2 database at the same time without compromising the safety of the database?</p>