Menu

#230 Database server paths in addition to aliases in db URL

closed
nobody
engine (144)
1
2010-10-14
2008-10-07
No

Hello,

Currently HSQLDB requires configuration of each database in server.properties. Some other databases, e.g. Derby and Interbase, allow users to provide server database paths in connection url. This approach obviates configuration of each database in server.propertis.

It'd be nice to add such feature to HSQLDB. We use HSQLDB to store code review results. We'd like to use different databases for each project. The current design will limit us to 10 projects per server. With the new aproach the limitation will be lifted.

I see it work as follows:
- There fill be a new connection url syntax, e.g.
jdbc:hsqldb:serverfile://<server>/<server path> like jdbc:hsqldb:serverfile://localhost/C:\db\mydb
- The server will use default parameters for new databases.
- The server will open database files on first connect and close with some delay (e.g. 1 minute) after the last connection to this database is closed.
---
Regards, Pavel.

Discussion

  • Fred Toussi

    Fred Toussi - 2009-05-21

    This sort of thing already exists in 1.8 and 1.9, but not well documented. The property server.remote_open is set when the server is started. After this, the path of the database can be specified on URL. You need to look at the code for details.

     
  • Fred Toussi

    Fred Toussi - 2009-09-20

    Also, 1.9 does not limit the databases to 10.

     
  • Fred Toussi

    Fred Toussi - 2009-09-20
    • status: open --> closed
     
  • Fred Toussi

    Fred Toussi - 2010-10-14
    • priority: 5 --> 1
     

Log in to post a comment.