How do I allow multiple users to connect to my H2 database simultaneously? How do I allow multiple users to connect to my H2 database simultaneously? database database

How do I allow multiple users to connect to my H2 database simultaneously?


It looks like you are using H2 in embedded mode, which only allows one database connection at a time. See connection modes in the documentation for details.

If you need support for multiple connections, including from multiple application instances, then you need to start H2 in server mode instead and use the appropriate connection URLs for this mode.


AUTO_SERVER=TRUE allows multiple connections mode.