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.

     
    • Anonymous - 2005-02-02

      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

         

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks