<changeSet id="create_jobItem" author="m">
    <createTable tableName="job_item" schemaName="service">
        <column name="id" type="int" autoIncrement="true">
            <constraints primaryKey="true" nullable="false"/>
        </column>
        <column name="language" type="varchar(255)" />
        <column name="description" type="text" />
    </createTable>
</changeSet>

<changeSet id="add_jobItem1" author="m">
    <insert tableName="JOB_ITEM" schemaName="service">
        <column name="id">99989</column>
        <column name="language">C#</column>
        <column name="description">position for C#</column>
    </insert>
</changeSet>

@Rule
public DAOTestRule database = DAOTestRule.newBuilder()
        .addEntityClass(JobItem.class).build();

Connection connection = DriverManager.getConnection(url, user, password);
        database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection(connection));

final long savedId = 99989L;
    JobItem jobItem = database.inTransaction(() -> {
        return dao.getById(savedId);
    });

No entity found for query

datasourceFactory:
  driverClass: org.h2.Driver
  user: sa
  password:
  url: jdbc:h2:mem:jobservice;INIT=create schema if not exists jobservice;set schema service
  validationQuery: "/* MyService Health Check */ SELECT 1"
  logValidationErrors: true
  initialSize: 2
  minSize: 2
  maxSize: 8
  minIdleTime: 1 minute
  properties:
      hibernate.dialect: org.hibernate.dialect.H2Dialect
      hibernate.default_schema: lis
      hibernate.id.new_generator_mappings: false
      hibernate.show_sql: false