I have a lookup table in MongoDB - about 1 million records - JSON dump is just over 200MB.
I'd like to get rid of the requirement for MongoDB and use something embedded in my webapp (running on Tomcat 8).
Ideally I would be able to deploy a file or set of files with, or alongside, the webapp, and the embedded library would read it from there. The webapp does not need to be able to make updates.
I would be perfectly happy having a separate standalone utility application to generate this file(set), e.g. reading the JSON dump from mongo. I also don't mind if I have to write this utility myself (presumably embedding the same DB library).
I see lots of options for embedded databases in Java, but I haven't played with any of them. Everything I've read about has support for updates, transactions, etc. which I don't need, but if they don't get in the way and don't make life more difficult for me I don't really care I guess.
Finally, ease of use and simplicity/elegance of client code is more important to me than performance (within reason).
Is there any particular candidate best suited to this scenario?