There are now a number of pure Java SQL database systems which support being embedded ... and stop the embedded server and load it with test data. Both HSQLDB and Derby have embedded JDBC drivers ...

More than a decade ago, Google re-implemented the Java ... SQL is a declarative language: users specify what information they're looking for, but they leave it up to the database system to decide ...