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.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.