Is it possible to connect to and query the CTP HyperSQL database using a remote SQL client? If so, what connect string would be used?
CTP allows remote connections to the embedded HyperSQL database on port 9002.
Most likely you will need to open that port in the firewall on the server OS.
Then you should be able to connect via
Is it possible to connect from a remote computer?
something like: jdbc:hsqldb:hsql://my.ctp.server.com:9002/em
jdbc:hsqldb:http://my.ctp.server.com:9002/em I meant to say.
Yes, connecting from a remote server will work if you change the host name in the URL and there is no firewall blocking port 9002.