FruitSubcategoryDao.java

package org.xmx0632.deliciousfruit.repository;

import java.util.List;

import javax.persistence.QueryHint;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.jpa.repository.QueryHints;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.xmx0632.deliciousfruit.entity.FruitSubcategory;

public interface FruitSubcategoryDao extends
		PagingAndSortingRepository<FruitSubcategory, Long>,
		JpaSpecificationExecutor<FruitSubcategory> {

	@Query("from FruitSubcategory f where f.fruitCategory is null")
	@QueryHints({ @QueryHint(name = "org.hibernate.cacheable", value = "true") })
	List<FruitSubcategory> getAllUnSelectedFruitSubcategory();

	@QueryHints({ @QueryHint(name = "org.hibernate.cacheable", value = "true") })
	FruitSubcategory findByFruitType(String fruitType);
}