Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.
HyperSQL Connection from a Remote SQL Client
Options
jefftuckerbofa
Posts: 234 ✭
in CTP
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?
Thanks,
JT
Tagged:
0
Comments
-
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
jdbc:hsqldb:hsql://localhost:9002/em
username=em
password=em0 -
Is it possible to connect from a remote computer?
something like: jdbc:hsqldb:hsql://my.ctp.server.com:9002/em
Thanks,
JT
0 -
jdbc:hsqldb:http://my.ctp.server.com:9002/em I meant to say.
JT
0 -
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.
0