Junit with H2 DB

TestConfig.java

@Configuration
@ComponentScan(basePackages={"com.dummy.data"})
public class TestDBConfig {
    
    @Bean
    public JdbcTemplate jdbcTemplate()
    {
        return new JdbcTemplate(h2DataSource());
    }
    
    @Bean
	public NamedParameterJdbcTemplate namedParameterJdbcTemplate(){
		return new NamedParameterJdbcTemplate(h2DataSource());
	}
    
    @Bean
    public static PropertySourcesPlaceholderConfigurer propertySourcesPlaceholderConfigurer() {
       return new PropertySourcesPlaceholderConfigurer();
    }

    @Bean
    public DataSource h2DataSource() {
		EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
		EmbeddedDatabase db = builder
			.setType(EmbeddedDatabaseType.H2)
			.build();
		return db;
    }
    
}

TestDummy.java

@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest(classes = TestConfig.class, properties = { "spring.cloud.config.enabled=false",
"spring.profiles.active=test", "logging.level.org.springframework.jdbc.core.JdbcTemplate=debug" })
@SqlGroup({ @Sql(executionPhase = ExecutionPhase.BEFORE_TEST_METHOD, scripts = {
		"classpath:sql-file-in-resource-dir.sql" }) })

public class TestDummy {

  @Autowired
	JdbcTemplate jdbcTemplate;
  
  // autowire DAO object
  
  @Test
	public void testMethod() throws Exception {
    // mock autowired DAO object
    		//Mockito.when(daoObject.methodName())
				//.thenReturn(someData);
		//jdbcTemplate.execute("SQL statment here");
    //assertNotNull(list);
    //assertEquals(2, list.size());

	}
  
}

Further ref https://www.logicbig.com/tutorials/spring-framework/spring-data-access-with-jdbc/jdbc-tests.html