Multiple H2 Databases

[dgoadby]

I have a control application where I want to use an in-memory database
for the live data and a copy of configuration data and a file based
database (ideally multi-user) which will contain the archived data,
configurations etc.

I know that I can have either in a single application but can I have
both from the same application? If not then I guess I will need to run
a separate server application to get it running and then run the in-
memory application with my main program.

Anyone done anything like this?

David.

[Thomas Mueller]

Hi,

Sorry, I don't understand, is your question whether you can open
multiple databases within the same application? Sure, that's not
problem. Or do you want to open the same database from multiple
processes? In this case, see
http://h2database.com/html/features.html#connection_modes

Regards,
Thomas

[dgoadby]

Hi Thomas,

Yes, I meant to open multiple databases from the same application. But
I also will want to share the file based version with other
applications/users too.

Thanks for the answers - I will now try it for real!

Regards

David

On Feb 16, 7:01 pm, Thomas Mueller <thomas.tom.muel...@gmail.com>
wrote: