Search code examples
javajpamany-to-manyjoincolumn

Wrong column type in jpa many to many relationship

I have the following many-to-many relationship

@ManyToMany
@JoinTable(
        name="response"
        , joinColumns={
            @JoinColumn(name="id_response", referencedColumnName="id_response")
            }
        , inverseJoinColumns={
            @JoinColumn(name="id_request")
            }
        )
private List<Transaction> transactions;

I get the following exception :

Wrong column type in response for column id_response.  Found: varchar, expected: integer

Is it possible to add a parameter to @JoinColumn to explicitly tell it is a String value ? Any other solution ?

Solution

  • I found my mistake : The wrong type was because of a field type in my database.