Spring Data JPA Autowired repository returns null

Question

I am using the following repository and controller to retrieve some records from the DB:

public interface TableARepository extends CrudRepository<TableA, Long>{
    @Query(value = "SELECT r FROM TableA r  WHERE r.Id = :Id", nativeQuery = true)
    public Rater getTableAById(@Param("Id") Long Id);
}

@RestController
public class TableAController {
    @Autowired
    TableARepository tableARepository;
    
    @GetMapping(value="/GetTableAById")
    public TableA getTableAById(@RequestParam String email) {
        TableA tableA = new TableA();
        tableA = tableARepository.getTableAById(email);
        return tableA;
    }
}

The following error appears once i invoke the REST api:

Cannot invoke com.TableARepository.getTableAById(Long) because this.tableARepository is null

Check if the package `TableARepository` resides in is being scanned. — Chaosfire, Oct 13 '22 at 08:44

score -1 · Answer 1 · answered Oct 13 '22 at 10:25

-1

add the annotation @Repository

@Repository
public interface TableARepository extends CrudRepository<TableA, Long>{
    @Query(value = "SELECT r FROM TableA r  WHERE r.Id = :Id", nativeQuery = true)
    public Rater getTableAById(@Param("Id") Long Id);
}

answered Oct 13 '22 at 10:25

Karim SNOUSSI

109
7

Tried it, did not work, same error. – StudentOfTheGame Oct 13 '22 at 11:16
`@Repository` does effectively nothing. See https://stackoverflow.com/questions/42691697/using-repository-annotation-when-implementing-jparepostiory-in-spring – Jens Schauder Oct 13 '22 at 13:01

Spring Data JPA Autowired repository returns null

1 Answers1