CODEWITHSUNDEEP
h2
Thomas Vervik
Thomas Vervik

Reputation: 4525

H2 tries to create database in invalid location

when I try to create a database in H2 in the web console with the following url

jdbc:h2:tcp://localhost/data/vervikMonitor

I get the following error:

IO Exception: "java.io.FileNotFoundException: 
C:\Program Files\H2\bin\data\vervikMonitor.lock.db (No access)"; 
"C:/Program Files/H2/bin/data/vervikMonitor.lock.db" [90031-162] 90031/90031 (Help)

I have a norwegian version of Windows, so the path to my program folder is C:/Programfiler/ - why does H2 try to access the english style c:/Program Files/, where is that reference stored?

Upvotes: 4

Views: 1815

Answers (1)

user647772
user647772

Reputation:

Try absolute paths (note the //):

jdbc:h2:tcp://localhost//data/vervikMonitor

Of course you must make sure that C:\data\vervikMonitor is writable. Or you can use a different directory :)

Upvotes: 2

Related Questions