Question: Bulk insert and dynamic schema loading
I am new to H2 database and java. I have started working on these from past 1 month. I needs some assistance regarding H2 database.
Overview of my work :
I get the query from reporting engine. Query is split and only the select with where is run on the underlying database(file structure). The results needs to stored in H2 database and the actual query(with orderby and groupby ) needs to run.
Which type of connection mode to use? (in memory/embedded).
Schema is dependent on query. So how to load schema and create table dynamically?
Which the best way to insert bulk data and fetch in H2 database ?
Any help is much appreciated.