HSQLDB in Client/Server mode with inmem db.

agm
2005-02-01
2014-01-19
  • agm
    agm
    2005-02-01

    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:
    server.port=9001
    database.0=mem:rtedb
    dbname.0=rtedb

    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?

    Cheers.

     
    • the second, commented out jdbc url appears to be correct:

      "jdbc:hsqldb:hsql[s]://host:port/rtedb"

      The server properties appears to be fine.

       
    • agm
      agm
      2005-02-02

      It doesn't work.

      I found two kinds of error...

      It says db not found...
      Or
      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....

       
      • Fred Toussi
        Fred Toussi
        2005-02-02

        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