Btukfyl

I'm working on a Spring Boot project, and need to write Unit Tests for my Repository and service layers. However, I'm unable to get the ball rolling as none of my unit tests work. i always get some kind of configuration errors.

This is my test class:

@RunWith(SpringRunner.class)

@DataJpaTest

public class PersonRepositoryIntegrationTest {



    @Autowired

    private TestEntityManager testEntityManager;



    @Autowired

    private PersonRepository personRepository;



    private void createPerson() {

        Person p = new Person();

        p.setName("Sriram");

        p.setEmail("sriram@xxxyyy.in");

        this.testEntityManager.persist(p);

        this.testEntityManager.flush();



        Person p2 = new Person();

        p2.setName("John Doe");

        p2.setEmail("john.doe@xxxyyy.in");

        this.testEntityManager.persist(p2);

        this.testEntityManager.flush();

    }



    @Test

    public void testMethod() {

        this.createPerson();



        Person found = personRepository.findByEmail("sriram@xxxyyy.in");



        assertThat(found.getName()).isEqualTo("Sriram");

    }

}

When I run this, I get the following error:

java.lang.IllegalStateException: Failed to load ApplicationContext

Caused by: org.h2.jdbc.JdbcSQLException: Table "ALL_SEQUENCES" not found; SQL statement:

 select sequence_name from all_sequences  union select synonym_name   from all_synonyms us, all_sequences asq  where asq.sequence_name = us.table_name    and asq.sequence_owner = us.table_owner [42102-197]

This is just one of the many config errors I've been getting for the past day. The error above was when I was following this tutorial step by step. Doesn't seem to work.

This is my POM

<dependencies>

    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-data-jpa</artifactId>

    </dependency>

    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-web</artifactId>

    </dependency>



    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-devtools</artifactId>

        <scope>runtime</scope>

    </dependency>

    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-tomcat</artifactId>

        <scope>provided</scope>

    </dependency>

    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-test</artifactId>

        <scope>test</scope>

    </dependency>

    <dependency>

        <groupId>com.oracle</groupId>

        <artifactId>ojdbc6</artifactId>

        <version>11.1.0</version>

    </dependency>

    <dependency>

        <groupId>com.h2database</groupId>

        <artifactId>h2</artifactId>

        <scope>test</scope>

    </dependency>

</dependencies>

As you may have noted I'm using Oracle DB actually, but starting a H2 DB for test purposes.

Can anyone help me out why I'm getting the error? Should I have a separate application.properties with DB configuration for my test classes?

I can provide more information if you need, but I need to crack this.

Appreciate any help I can get. Thanks!

**EDIT: ** application.properties added as requested by Anand

hibernate.dialect = org.hibernate.dialect.Oracle10gDialect

hibernate.hbm2ddl.auto=create

hibernate.cache.use_second_level_cache=true

hibernate.cache.use_query_cache=true

jdbc.url=jdbc:oracle:thin:@localhost:1521:xe

jdbc.username=tm

jdbc.password=tm

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver

hibernate.cache.region.factory_class=org.hibernate.cache.ehcache.EhCacheRegionFactory