Was unable to run HSQLDB in client/server mode and create/use the in memory database.
Is this supported? If so...What are the properties needs to be set.
Here is what i had tried:
in "server.properties" specified:
And in client connection tried:
// In Mem URL.
String url = "jdbc:hsqldb:mem://host:port/rtedb";;
// Client/Server URL.
// String url = "jdbc:hsqldb:hsql://host:port/rtedb";;
In the first case (:mem:)it wasn't connecting to the specified server. It seems to be running as embedded database (on its own).
In second case (:hsql: or :hsqls:) it seem to be always expecting database file.
Am i missing anything?
the second, commented out jdbc url appears to be correct:
The server properties appears to be fine.
It doesn't work.
I found two kinds of error...
It says db not found...
Starts writing into default testsdb (as data is entered).
From the answer it seems the Client/Server mode for in-mememory db is supported. Has any one tried this....
There is no problem in 1.7.3 or 1.8.0.RC7. Just test with database manager and get the URL's right. Also check that your computer doesn't block access to its port 9001