Java JPA Query with two Parameters

Question

I'm working with Java and the Spring Framework, and with hibernate. I wrote an Interface to get some inventory stuff by Querys, one for a Location, where the Inventory is and one for a ProductType:

    public interface ProductInventory extends Inventory<InventoryItem> {

      @Query("select i from InventoryItem i, ProductItem c where i.product = c and c.type = ?1")
      List<InventoryItem> findByProductType(ProductItem.ProductItem type);

      @Query("select i from InventoryItem i, ProductItem c where i.product = c and c.locationid = ?1")
      List<InventoryItem> findByProductLocation(long locationid);
    }

this is working perfect, but now i want to write an Query which selects the ProductType and the location:

     @Query("select i from InventoryItem i, ProductItem c where i.product = c and c.type = ?1 and c.locationid = ?1")
     List<InventoryItem> findByProductStandortAndType(ProductItem.ProductItemType type, long locationid);

but this isn't working. Maybe anyone can help me? Thanks a lot

Neil Stockton · Accepted Answer · 2014-11-25 18:35:34Z

2

So why are you not using the second parameter in the query? You have "?1" for the first parameter twice.

answered Nov 25, 2014 at 18:35

Neil Stockton

11.6k3 gold badges36 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Java JPA Query with two Parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related