Where are the Database Files Stored?
When using database URLs like jdbc:h2:~/test, the database is stored
in the user directory. For Windows, this is usually C:\Documents and
Settings\ or C:\Users\. If the base directory is
not set (as in jdbc:h2:test), the database files are stored in the
directory where the application is started (the current working
directory). When using the H2 Console application from the start menu,
this is /bin. The base directory can be set in
the database URL. A fixed or relative path can be used. When using the
URL jdbc:h2:file:data/sample, the database is stored in the directory
data (relative to the current working directory). The directory is
created automatically if it does not yet exist. It is also possible to
use the fully qualified directory name (and for Windows, drive name).
Example: jdbc:h2:file:C:/data/test