Unable to connect to a zipped H2 database when the zip file is in User home directory.

[GoogleCodeExporter]

What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)
1. Create backup of existing h2 database "BACKUP TO USER_HOME/data.zip"
2. Start H2 Console and have JDBC URL as jdbc:h2:zip:~/data.zip!/h2Database
3. Click on Test Connection

What is the expected output? What do you see instead?
Expected "success" but seeing the following message:
IO Exception: java.io.FileNotFoundException: ~\data.zip (The system cannot 
find the path specified); listFiles zip:~/data.zip!/ [90031-118] 
90031/90031

What version of the product are you using? On what operating system, file
system, and virtual machine?
Version: 1.2.124, OS: Windows XP SP3

Do you know a workaround?
No. But, it looks like FileSystemZip.java is not translating "~" to 
USER_HOME directory.

How important/urgent is the problem for you?
It is important for this to work as this is blocking our project build.

In your view, is this a defect or a feature request?
This is a defect

Please provide any additional information below.

Original issue reported on code.google.com by varmakda...@gmail.com on 30 Nov 2009 at 11:20

[GoogleCodeExporter]

I will implement this for the next release.

Original comment by thomas.t...@gmail.com on 4 Dec 2009 at 11:06

• Changed state: Accepted

[GoogleCodeExporter]

Thanks for looking into it.

Original comment by varmakda...@gmail.com on 5 Dec 2009 at 11:02

[GoogleCodeExporter]

Supported in version 1.2.125

Original comment by thomas.t...@gmail.com on 6 Dec 2009 at 6:49

• Changed state: Fixed