Dear All,
compliments. I have a hard time with URIs under Windows (simply because
I do not know this OS very well.)
In our own Java code, all URIs are defined as:
groovy> URI uri = new URI("file:/C:/Users/manticore/.manticore/ifrsbox");
groovy> File f = new File(uri);
Result: C:\Users\manticore\.manticore\ifrsbox <-- OK!
Based on that understanding, I would have specified the H2 connection
string as:
jdbc:h2:file:/C:/Users/manticore/.manticore/ifrsbox
But this gives me
General error: "java.nio.file.InvalidPathException: Illegal char <:> at index
2: /C:/Users/manticore/.manticore/ifrsbox" [50000-201] HY000/50000 (Help)
Instead, the following seems to work as H2 connection string:
jdbc:h2:file:C:/Users/manticore/.manticore/ifrsbox
jdbc:h2:C:/Users/manticore/.manticore/ifrsbox (wow!)
but fails as URI:
groovy> URI uri = new URI("file:C:/Users/manticore/.manticore/ifrsbox");
groovy> File f = new File(uri);
Exception thrown
java.lang.IllegalArgumentException: URI is not hierarchical
at java.io.File.<init>(Unknown Source)
at ConsoleScript11.run(ConsoleScript11:2)
Now I have two questions please:
1) is that a Bug or a Feature? (in my opinion,
"jdbc:h2:file:/C:/Users/manticore/.manticore/ifrsbox" was more logical than
"jdbc:h2:file:C:/Users/manticore/.manticore/ifrsbox" and especially
"jdbc:h2:C:/Users/manticore/.manticore/ifrsbox")
2) if it was a feature, then what would be the best way to get the DB File Name
from a Connection URL, given the three different Schemes like
"jdbc:h2:C:/Users/manticore/.manticore/ifrsbox",
"jdbc:h2:file:C:/Users/manticore/.manticore/ifrsbox" and
"jdbc:h2:tcp://localhost/C:/Users/manticore/.manticore/ifrsbox"
Thank you already and best regards
Andreas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/f5fa46ef649440a76650285583f54a2a869212f2.camel%40manticore-projects.com.
