I am just curious about usage of H2 on GAE, as memory-only database with keep the content as long as the virtual machine is alive (DB_CLOSE_DELAY=-1). Database will be small approx 10MB with requirement to have top performance.
On daily manner I would like to do the backup of complete database to external store which is on my local computer. So there are question: 1) Is it possible to access this database on GAE remotely using TCP/IP or SSL/TLS (An example database URL is: jdbc:h2:tcp://localhost/ mem:db1) ? 2) If not is it possible to generate backup (like by SQL commands BACKUP, SCRIPT) and not to store it on local file system but sent it e.g. like backup-servlet response ? 3) Last possible way I thing will work is that I program the backup manually querying every table as a response of backup-servlet. 4) I have I fundamental question if H2 can be runned as memory-only database on GAE, I do not know if GAE is not running my application as cluster on several JVM's so then H2 in memory-only mode is not functional because it can be used only on the same JVM/class loader (mentioned in http://www.h2database.com/html/features.html#memory_only_databases: Accessing the same database in this way only works within the same virtual machine and class loader environment.) thanks for reponse: can save me time to start work on something which is not possible --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
