Spring Framework: findBy throws Illegal Argument Exception

Question

This is my Entity Class.

@Entity
public class Profile {

@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private Long profileId;

@Transient
private String name;

@ElementCollection(fetch = FetchType.EAGER)
private Map<String, String> trNames;     //Key: LanguageCode, Value: translated text
...
}

ProfileRepository Class

public interface ProfileRepository extends JpaRepository<Profile, Long> {

//This method should go through the Map Collection and return a profile whose name matches the given parameter value.
Profile findByTrNames(String code, String name);

}

I created a JUnit Test Class to test this method. This line of code

Profile found = repository.findByTrNames("en", "Interview IT");

throws an exception.

org.springframework.dao.InvalidDataAccessApiUsageException: Parameter value [en] did not match expected type [java.util.Map]; nested exception is java.lang.IllegalArgumentException: Parameter value [en] did not match expected type [java.util.Map]
    at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:301)
    at etc..

Could anyone please help me?

Thank you very much.

Predrag Maric · Accepted Answer · 2014-12-12 09:42:45Z

2

This should work

@Query("select p from Profile p where p.trNames[?1] = ?2")
Profile findByTrNames(String code, String name);

UPDATE

JIRA ticket is created to support this feature: https://jira.spring.io/browse/DATAJPA-643

edited Dec 12, 2014 at 9:42

answered Dec 11, 2014 at 14:14

Predrag Maric

24.5k5 gold badges57 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

kk-dev11 Over a year ago

great.. It does indeed. :) Could you please perhaps explain why it threw an exception? Why did it expect a type of java.util.Map?

Predrag Maric Over a year ago

spring-data constructs the query based on your declared method name which is findByTrNames. Since trNames is of type Map, it expects the parameter to be also a Map. I agree it could be a little smarter when it comes to Map fields in entities, since they are somewhat specific and it makes sense that two params in the method could be interpreted as key and value.

Oliver Drotbohm Over a year ago

@Pedrag - Any chance you open a ticket in the JIRA for improved Map binding? I am sure we can sketch something out.

Predrag Maric Over a year ago

@OliverGierke Thanks for the suggestion, I've opened a ticket for this, updated my answer with issue reference

Collectives™ on Stack Overflow

Spring Framework: findBy throws Illegal Argument Exception

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related