How to create a @Onetomany relationship in JPA, in 3 tables that already exist in the database?

Question

I want to create a relationship @OneToMany in JPA using 3 tables I have already created in my database (I don’t want it to create the tables for me), the tables are Usuario, Perfil and UsuarioPerfil. for this I am using the following code snippet in my User class.

@OneToMany(fetch = FetchType.EAGER)
List<Perfil> perfisPermitidos = new ArrayList<Perfil>();

The problem is when running the code the following Exception is launched

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'nomedomeubanco.Usuario_Perfil' doesn't exist

I know he does this because JPA tries to create the User_profile table automatically to use as an intermediate table, but I want him to use my table UsuarioPerfil which already exists in my bank for exactly that purpose.

So that being said my question is how do JPA map the table UsuarioPerfil as relationship table and do not try to create a default table which in this case is the table Usuario_Perfil?

Answer 1

Hi

That depends on the strategy you use. create, create-drop, validate, update

If you are using spring boot for example you can set it up like this

# Hibernate ddl auto (create, create-drop, validate, update)
  spring.jpa.hibernate.ddl-auto=update 

There is an example in the link below

https://www.oracle.com/technetwork/pt/articles/dsl/crud-rest-sb2-hibernate-5302424-ptb.html!