Is it possible to create a new database within embedded hype

[kimberley.scott]

Hiya,

JBoss-3.2.2RC1/Jetty-4.2.9

These are probably real newbie questions, so please forgive me for appearing a tad daft.

I'm considering whether it's feasible to use the embedded hypersonic plugin to host multiple tiny databases. I have a series of small apps that have a small number of tables each. The site is remote and has a certain amount of lockdown in place and the client is wary of installing mySQL for some reason. If I could use the embedded hsqldb to create mini-dbs that can 'travel' with the web-app that would be most helpful. Otherwise I'm going to have use xml files which is going to be a data integrity pain.

If this can't be done does anyone have any idea how to have hsql be available and deployable 'inside' a web app?

Any ideas anyone?

Kimbo.

[jonlee]

Hypersonic is capable of supporting small databases if you are happy with that. You will probably want the support tools to create and manage the databases other than from JDBC. Check the SourceForge entry and get the package and the documentation and you should be away. Just read through the webdocs to get an idea of whether it is suitable for your needs and what mode you want - probably file rather than all in memory. The utilities will also help you backup the data.

See http://hsqldb.sourceforge.net/ for more information.