Browse DevX
Sign up for e-mail newsletters from DevX


Tip: How to Pass Parameters in @Query

Learn how to pass parameters to an SQL query written with @Query via @Param or positional parameters.


Passing parameters to an SQL query written via @Query can be done via @Param or via positional parameters:

// via @Param
@Query(value = "SELECT p FROM Product p WHERE p.department=:department")
List fetchByDepartment(@Param("department") String department);

// via positional parameters
@Query(value = "SELECT p FROM Product p WHERE p.department=?1")
List fetchByDepartment(String department);


Visit the DevX Tip Bank


Octavia Andreea Anghel is a senior PHP developer currently working as a primary trainer for programming teams that participate at national and international software-development contests. She consults on developing educational projects at a national level. She is a coauthor of the book "XML Technologies--XML in Java" (Albastra, ISBN 978-973-650-210-1), for which she wrote the XML portions. In addition to PHP and XML, she's interested in software architecture, web services, UML, and high-performance unit tests.
Thanks for your registration, follow us on our social networks to keep up-to-date