Hi, > I am considering using linked tables but I am not sure how they work.
H2 is open source, have a look at the classes TableLink, TableLinkConnection, LinkedIndex. > resultset = select * from greenplum_table > for each resultset_row > insert resultset_row into h2_table Or you could do: create table h2_table(...) as select * from linked_greenplum_table > However I do need to handle the > case when the H2 server is shutdown for maintenance. I guess you mean Greenplum is shutdown? > I plan to use > the backup and restore scripts to dump the in memory tables You don't need in-memory tables, you could use regular tables. Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
