HyperSQL Connection from a Remote SQL Client

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

Comments

  • Matt LoveMatt Love Posts: 63 admin

    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=em

  • jefftuckerbofajefftuckerbofa Posts: 116

    Is it possible to connect from a remote computer?

    something like: jdbc:hsqldb:hsql://my.ctp.server.com:9002/em

    Thanks,

    JT

  • jefftuckerbofajefftuckerbofa Posts: 116

    jdbc:hsqldb:http://my.ctp.server.com:9002/em I meant to say.

    JT

  • Matt LoveMatt Love Posts: 63 admin

    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.

Sign In or Register to comment.