Wrong column type in jpa many to many relationship

Question

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 ?

Why would you tell something the type ? The PK field(s) of the entities DEFINE the types. You haven't shown them ... — Neil Stockton, May 23 '16 at 10:16
Thanks you helped me find my mistake. The wrong type was because of a field type in my database — anais1477, May 23 '16 at 13:32

score 0 · Accepted Answer · answered May 23 '16 at 13:33

0

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

answered May 23 '16 at 13:33

anais1477

466
1
17
36

Wrong column type in jpa many to many relationship

1 Answers1