To demonstrate how to run simple SELECT statement and get result back as a list of defined object models.

DBquerryAsListTest.java

@SpringBootTest
class DBquerryAsListTest {

  @Autowired
	@Qualifier("testSetupDataSource")
	DataSource testSetupDataSource;

  JdbcTemplate jdbcTemplate;
  
  @Test
  void runSelectQuerryTest() {
    jdbcTemplate = new JdbcTemplate(testSetupDataSource);
    List<TestDataResponseModel> dataResponses = jdbcTemplate.query("SELECT * FROM vw_subscriptions WHERE instanceId in (?, ?);", new LiteDBBeanPropertyRowMapper<>(TestDataResponseModel.class), instanceId, upgradeInstanceId);
    assertTrue(dataResponses.size() > 0);
  }
}