Spring data JDBC custom query

Question

I have defined the following custom database query.

@Query("select po.* from purchase_order po where po.purchase_order_number = :purchaseOrderNumber")
List<PurchaseOrder> findByPurchaseOrderNumber(String purchaseOrderNumber);

This query always return null regardless of the value of purchas. On the other hand, if I replace the dynamic parameter purchaseOrderNumber in the query with a hard-coded value (as the one depicted below) it perfectly works.

@Query("select po.* from purchase_order po where po.purchase_order_number = "10")
List<PurchaseOrder> findByPurchaseOrderNumber(String purchaseOrderNumber);

I would appreciate it if someone can help me to understand why my query with the dynamic PurchaseOrderNumber doesn't work?

Please post the actual code you use. The one you posted so far as working doesn't even compile. Also please activate logging of the SQL statement and show the SQL statements that get executed including the bind parameters. stackoverflow.com/a/15520137/66686 — Jens Schauder
– Jens Schauder, Commented Oct 6, 2022 at 8:32

johnnyutts · Accepted Answer · 2022-10-04 20:57:59Z

0

Specify the name of the query parameter

@Query("select po.* from purchase_order po where po.purchase_order_number = :purchaseOrderNumber")
List<PurchaseOrder> findByPurchaseOrderNumber(@Param("purchaseOrderNumber") String purchaseOrderNumber);

answered Oct 4, 2022 at 20:57

johnnyutts

1,4521 gold badge9 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Spring data JDBC custom query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related