JPA: Delete Row on Compound Primary Key that has JoinColumns

[William Powell]

I am trying to delete a row. My Entity has a 3 part compound primary key where 2 of them are foreign key JoinColumns. When I call the built in "delete()" on the JpaRepository and pass in the entity it errors on one of the 2 JoinColumns in the Primary Key.

Error:
Failed to convert property value of type 'java.lang.String' to required type 'MyTableEntity' for property 'join_column_property_name'

Can anyone help?

[Rob Spoor]

Welcome to the Ranch!

Can you show us some of your code? We won't need the full entities, but the relevant fields (and possible embedded id classes) need to be shown. Can you also show your JPA query?

[Tim Holloway]

My memory is really fuzzy here, but if I recall, the Spring JpaRepository feature provided a generic finder/CRUD service so that you wouldn't have to code a lot of repetitive stuff.

The downside was that it was somewhat limited in what it could handle. It may be that you have exceeded those limits and are going to have to code your Repository/DAO the hard way.