Java 8 Spring Data JPA Parameter binding

Question

In my @Repository interface I created custom find method with JPQL @Query that contains parameter (addressType).

from Address a where a.addressType = :addressType

In the method I did not specify @Param("addressType") on the parameter. So I am getting

java.lang.IllegalArgumentException: Name for parameter binding must not be null or empty! For named parameters you need to use @Param for query method parameters on Java versions < 8.

Okay, this is pretty much clear, but I am using Java 8. So what is special about Java 8 here?

Oh dear, you have omitted "SELECT a" from your JPQL query, so it is now illegal. — Neil Stockton
– Neil Stockton, Commented Feb 17, 2016 at 8:07

crusy · Accepted Answer · 2020-06-19 11:57:30Z

18

The answer given by @JB Nizet is correct, but I just wanted to point out the way to add the -parameters flag for the Java 8 compiler when using Eclipse. This is in Window -> Preferences:

Preferences setting

Maven also allows adding the flags in the pom itself:

<plugin>
    <groupId>org.apache.maven.plugins</groupId>
    <artifactId>maven-compiler-plugin</artifactId>
    <version>3.5.1</version>
    <configuration>
        <compilerArgs>
            <arg>-verbose</arg>
            <arg>-parameters</arg>
        </compilerArgs>
    </configuration>
</plugin>

To add parameters flag for Java 8 compiler when using IDEA IntelliJ

File > Settings > Build, Execution, Deployment > Compiler > Java Compiler

Java Compiler setting

edited Jun 19, 2020 at 11:57

crusy

1,5303 gold badges28 silver badges60 bronze badges

answered Feb 17, 2016 at 8:05

Aritz

31.8k16 gold badges147 silver badges232 bronze badges

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

4 Comments

Deva Over a year ago

Is this dependency or downlaod any jar files?

Aritz Over a year ago

It's a maven plugin @Deva

Deva Over a year ago

So, this will increase my project size when I create war file?

Abhijit Bashetti Over a year ago

@Aritz, Thank you sharing this and it worked like a charm... I added in the pom.xml as mentioned.

DocZerø · Accepted Answer · 2016-02-15 11:44:46Z

14

In Java 8, you can use reflection to access names of parameters of methods. This makes the @Param annotation unnecessary, since Spring can deduce the name of the JPQL parameter from the name of the method parameter.

But you need to use the -parameters flag with the compiler to have that information available.

See http://docs.oracle.com/javase/tutorial/reflect/member/methodparameterreflection.html.

edited Feb 15, 2016 at 11:44

DocZerø

8,60511 gold badges44 silver badges75 bronze badges

answered Jan 1, 2015 at 19:41

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

3 Comments

Andrii Karaivanskyi Over a year ago

Thanks for the answer. But I'm using Java8 and SpringData still asks me for the @Param annotation.

JB Nizet Over a year ago

Have you compiled your classes with the -parameters option, as explained in the page I linked to?

Andrii Karaivanskyi Over a year ago

No I did not try that, I decided just to stick with @Param annotation since code will not work without special compilation configuration. But this your comment explains what you meant in your main answer. Thank you!

Ortomala Lokni · Accepted Answer · 2020-05-13 09:56:49Z

0

Answer from JB Nizet and Xtreme Biker are both corrects. I just want to add that if you use Spring Boot the -parameters compiler flag is already added for you by spring-boot-starter-parent (Gradle or Maven) :

plugin {
    delegate.groupId('org.apache.maven.plugins')
    delegate.artifactId('maven-compiler-plugin')
    configuration {
        delegate.parameters('true')
    }
}

answered May 13, 2020 at 9:56

Ortomala Lokni

63.5k27 gold badges202 silver badges268 bronze badges

Collectives™ on Stack Overflow

Java 8 Spring Data JPA Parameter binding

3 Answers 3

4 Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related