javax.el.PropertyNotFoundException: Property [coverage_description] not found on type [com.rtc_insurance.model.Plan]

Question

I'm new to spring so I don't fully understand yet how to make custom queries. I tried this code below but it's giving me some errors.

I have this 2 tables:

Plan Table

Plan Coverage

I want to get all the plan coverage description with a 'TEST123' plan_code.

This is my current code:

Plan.java

@Entity
@Table(name="plan")
public class Plan {
    /....

    @OneToMany(targetEntity=PlanCoverage.class, mappedBy="plan",cascade=CascadeType.ALL, fetch = FetchType.LAZY)
    private List<PlanCoverage> planCoverage;

    public List<PlanCoverage> getPlanCoverage() {
        return planCoverage;
    }

    public void setPlanCoverage(List<PlanCoverage> planCoverage) {
        this.planCoverage = planCoverage;
    }

    private String coverage_description;

    public String getCoverage_description() {
        return coverage_description;
    }

}

PlanCoverage.java

@Entity
@Table(name="plan_coverage")
public class PlanCoverage {

    @ManyToOne()
    @JoinColumn(name="plan_code", referencedColumnName = "plan_code",insertable=false, updatable=false)
    private Plan plan;

    public Plan getPlan() {
        return plan;
    }

    public void setPlan(Plan plan) {
        this.plan = plan;
    }

}

PlanRepository.java

public interface PlanRepository extends CrudRepository<Plan, String> {

    @Query(nativeQuery = true, value= "SELECT * FROM plan_coverage WHERE plan_code=:planCode")
    public List<Plan> findPlanCoverage(@Param("planCode") String planCode);
}

PlanController.java

@RequestMapping(value="/PlanDescription/{plan_code}", method=RequestMethod.GET)
    public ModelAndView planDescription(@PathVariable String plan_code) {
        ModelAndView model = new ModelAndView();
        Plan plan = planService.getPlanById(plan_code);
        model.addObject("planForm",plan);

        List<Plan> coverageList = planService.findByPlanCode(plan_code);
        model.addObject("coverageList",coverageList);

        model.setViewName("plan_description");
        return model;
    }

plan_description.jsp

<c:forEach items="${coverageList }" var="coverage">
  <span>${coverage.coverage_description}</span><br>
</c:forEach>

I want to access the coverage description but it's giving me this error.

Any help would be greatly appreciated.

Answer 1

Your Entity „Plan“ does not have a property (or simply speaking a „getter method“) that is called „coverage_description“. You need to define it first. Atm you only have „planCoverage“ as a useful property on the plan entity to use in your jsp page.