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

jefftuckerbofa
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:

Comments

  • Matt Love
    Matt Love Posts: 100 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

  • jefftuckerbofa
    jefftuckerbofa Posts: 234 ✭

    Is it possible to connect from a remote computer?

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

    Thanks,

    JT

  • jefftuckerbofa
    jefftuckerbofa Posts: 234 ✭

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

    JT

  • Matt Love
    Matt Love Posts: 100 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.

Categories

Tagged