Featuring various dbs such as :

• Sqlite
• postgres
• MariaDb
• MongoDb
• Cassandra
• H2 ...

Testing ORM such as Hibernate, manual JDBC, OpenJPA, EclipseLink...

Can run in memory or using file storage.

https://github.com/xerial/sqlite-jdbc

Directly load the DB from the code using the proper library which includes the server.

You may use SQLiteBrowser in order to get an interface to access the db.

The console is enabled in the application.yml - you may access the db using the following url :

http://localhost:9090/h2

Check the settings for the proper port and uri.

We use both Annotation and Config files (hbm.xml) to map our classes to tables.

Disable caching for proper debugging.

https://howtodoinjava.com/hibernate/hibernate-ehcache-configuration-tutorial/

Hibernate's query language (HSQL), which is similar to SQL except that it refers to the objects in the code rather than the tables in the database

See the Persister - it s an example of the facade pattern. Ex : RepositoryPattern

1. An interface definition that declares the persistence methods. This is usually a set of CRUD calls.
2. A set of facade classes that implement the interface and hide (encapsulate) the complexity of persistence behind simple CRUD calls.
3. A factory method (or injection) to select the appropriate persister for the application.