the connection details were hardcoded to hsqlsdb. the schema creation used the hibernate.cfg.xml. so in the database integration test set ups, the schema was created in e.g. the oracle database and the test was run against the hsqldb in memory, resulting in a table not found exception.

fix is to fetch the connection details from the hibernate configuration and use those to create the sal connection manually.