Adding Schema name to entity in Spring data?

Question

I am getting an error when using an Oracle DB and Spring Data. The error is:

ORA-00942: table or view does not exist

The cause of this error is that the user I am connecting with does not have access to the tables in the schemas I wish to connect to.

I read that 2 fixes to this are to create synonyms in my database or to specify the schema that each entity/table belongs to.

I am going to try the Schema approach first. How do I do so?

My example entity below, a Dog in the Vet Schema:

@Entity
@Table(name = "Dog")
public class Dog
{
    @Id
    private String id;

    @Column(name = "NAME")
    private String name;

    @Column(name = "Owner")
    private String owner;

  //getters and setters etc...

Answer 1

The @Table annotation provides the schema attribute:

@Table(name = "Dog", schema = "Vet")