Cfrgtkky

        Impl.java

        ------------------------------------------------------------------

         public List<SearchDTO> findByCriteria(SearchCriteriaDTO SearchCriteriaDTO) {

                CriteriaBuilder builder = entityManager.getCriteriaBuilder();

                CriteriaQuery<Search> query = builder.createQuery(Search.class);

                Root<Search> repls = query.from(Search.class);

final int QUERY_LIMIT = Integer.parseInt(queryLimit);

    List<UUID> statusIds = SearchCriteriaDTO.getStatusIds();

    if (statusIds != null && !statusIds.isEmpty()) {

        predicates.add(builder.and(repl.get("statusId").in(statusIds)));

    }

        -----------------------------

below is the test class for impl class.

        impltest.java

        ---------------------------

//mocking the services.

     @Mock

        private SearchMapper SearchMapper;

        @Mock

        private SearchRepository SearchRepository;



        @Mock

        private CriteriaBuilder criteriaBuilder;



        @Mock

        private Root root;



        @Mock

        private EntityManager entityManager;

        @Rule

        public ExpectedException thrown = ExpectedException.none();



        @Mock

        CriteriaQuery<Search>  criteriaQuery;



        @Mock

        Root<UUID> statusId;



        @Mock

        Path<String> path;



        @Mock

        Expression expr;



        @Mock

        Predicate predicate;



        @Mock

        TypedQuery<Member> querymem;



        @Mock

        Root<Search> rSearchRootMock;



        @InjectMocks



        private SearchServiceImpl SearchService;



      @Value("${query.limit}")



        String queryLimit;



        @Before

        public void init() {



            MockitoAnnotations.initMocks(SearchService);

            SearchRootMock = mock(Root.class);

        }

          @Test

            public void test_findby_criteria() {

        hen(entityManager.getCriteriaBuilder()).thenReturn(criteriaBuilder); when(criteriaBuilder.createQuery(Search.class)).thenReturn(criteriaQuery);

                when(criteriaQuery.from(Search.class)).thenReturn(SearchRootMock);

                Path statusIdMock = mock(Path.class);



                //when(Integer.parseInt(queryLimit)).thenReturn(1);

                String status = "statusId";



                Expression<String> doublePath = root.get(status);

                when(root.get((status))).thenReturn((Path) doublePath);

                when(criteriaBuilder.upper(root.<String>get(status))).thenReturn(expr);

                when(criteriaBuilder.equal(expr,status.toUpperCase())).thenReturn(predicate);



                when(root.get("statusId")).thenReturn(path);

                when(this.SearchService.findByCriteria(SearchCriteriaDTO)).thenReturn(Searches);



        here i am trying to mock the predicate but getting null point exception due to root.get("statusId").

        please let me know how to mock it.

here are the issues

how to handle and mock the @Value("${query.limit}") where i am reading limit from application properties file.
getting null point exception in predicate line.
predicates.add(builder.and(repl.get("statusId").in(statusIds)));

     not able to map the column name here for repl.get("statusId") where getting null.

please help me to solve this problem.Thanks

below is the error
java.lang.NumberFormatException: For input string: "${query.limit}"

at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

at java.lang.Integer.parseInt(Integer.java:569)

at java.lang.Integer.parseInt(Integer.java:615)

at com.capturerx.cumulus4.replenishment.impl.ReplenishmentSearchServiceImplTest.test_findby_criteria_for_success(ReplenishmentSearchServiceImplTest.java:118)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)

at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)

at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)

at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)

at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)

at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)

at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)

at org.junit.rules.ExpectedException$ExpectedExceptionStatement.evaluate(ExpectedException.java:239)

at org.junit.rules.RunRules.evaluate(RunRules.java:20)

at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)

at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:252)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)

at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)

at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)

at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)

at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)

at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)

at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)

at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)

at org.junit.runners.ParentRunner.run(ParentRunner.java:363)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)

at org.junit.runner.JUnitCore.run(JUnitCore.java:137)

at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)

at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:51)

at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)

at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)

getting java.lang.NullPointerException at line
query.select(replenishments).where(predicates.toArray(new Predicate[predicates.size()]));