I am trying to fetch data from a table in MySQL using JpaRepository. I am geeting an error by running code like -

Error creating bean with name 'chassiscontroller': Unsatisfied dependency expressed through field 'service': Error creating bean with name 'chassisserviceimpl': Unsatisfied dependency expressed through field 'dao': Error creating bean with name 'chassisdao' defined in com.ChassisInfo.chassis.dao.chassisdao defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Not a managed type: class com.ChassisInfo.model.chassismodel.

Controller

package com.ChassisInfo.chassis.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.bind.annotation.GetMapping;

import org.springframework.web.bind.annotation.RestController;
import com.ChassisInfo.chassis.service.chassisService;
import com.ChassisInfo.model.chassismodel;

@RestController
public class Chassiscontroller {
    
    @Autowired
    private chassisService service;
    
    @GetMapping("/chnum")
    public List<chassismodel> getchassisnumberinfo(){
        
        return service.getchassisnumberinfo();
        
    }

}

Service-

package com.ChassisInfo.chassis.service;

import java.util.List;

import com.ChassisInfo.model.chassismodel;

public interface chassisService{

    

    List<chassismodel> getchassisnumberinfo();
    

}

ServiceImpl-

package com.ChassisInfo.chassis.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.ChassisInfo.chassis.dao.chassisdao;
import com.ChassisInfo.model.chassismodel;


@Service
public class chassisserviceimpl implements chassisService {
    
    @Autowired
    private chassisdao dao;

    @Override
    public List<chassismodel> getchassisnumberinfo() {
        // TODO Auto-generated method stub
        return dao.findbychassisNumber();
    }

    
    
    

}

Dao-

package com.ChassisInfo.chassis.dao;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import com.ChassisInfo.model.chassismodel;

@Repository
public interface chassisdao extends JpaRepository<chassismodel,String> {
   
   @Query("Select * from chassis_master")
    List<chassismodel> findbychassisNumber();
}

Model-

package com.ChassisInfo.model;

public class chassismodel {
    private String vin;
    private String active;
    private String chassisNumber;
    private String chassisSeries;
    private String statusChangedTime;
    private String tag;
    private String truckid;
    private String id;
    private String chassis_number;
    private String chassis_series;
    private String status_changed_time;
    private String truck_id;
    
    public String getVin() {
        return vin;
    }

    public void setVin(String vin) {
        this.vin = vin;
    }

    public String getActive() {
        return active;
    }

    public void setActive(String active) {
        this.active = active;
    }

    public String getChassisSeries() {
        return chassisSeries;
    }

    public void setChassisSeries(String chassisSeries) {
        this.chassisSeries = chassisSeries;
    }

    public String getStatusChangedTime() {
        return statusChangedTime;
    }

    public void setStatusChangedTime(String statusChangedTime) {
        this.statusChangedTime = statusChangedTime;
    }

    public String getTag() {
        return tag;
    }

    public void setTag(String tag) {
        this.tag = tag;
    }

    public String getTruckid() {
        return truckid;
    }

    public void setTruckid(String truckid) {
        this.truckid = truckid;
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getChassis_number() {
        return chassis_number;
    }

    public void setChassis_number(String chassis_number) {
        this.chassis_number = chassis_number;
    }

    public String getChassis_series() {
        return chassis_series;
    }

    public void setChassis_series(String chassis_series) {
        this.chassis_series = chassis_series;
    }

    public String getStatus_changed_time() {
        return status_changed_time;
    }

    public void setStatus_changed_time(String status_changed_time) {
        this.status_changed_time = status_changed_time;
    }

    public String getTruck_id() {
        return truck_id;
    }

    public void setTruck_id(String truck_id) {
        this.truck_id = truck_id;
    }

    public String getChassisNumber() {
        return chassisNumber;
    }

    public void setChassisNumber(String chassisNumber) {
        this.chassisNumber = chassisNumber;
    }

}

CodePudding user response：

This is probably because you are missing the @EnableJpaRepositories(basePackages = "your.package.name") in you @SpringBootApplication

This is the Annotation to enable JPA repositories. Will scan the package of the annotated configuration class for Spring Data repositories by default.

CodePudding user response：

Try to use @RequiredArgsConstructor (lombok) in chassisserviceimpl, since dao field is not accessible for autowiring. Also add final for the field:

private final chassisdao dao;