Org.springframework.dao.EmptyResultDataAccessException:Incorrect result size:expected 1,actual 0

Two scenarios:

1. Replace queryForObject or queryForMap with the queryForList method, because both methods must have a value and cannot be empty.

2. Catch this anomaly and use Try/catch.

3. The result of this query is NULL, there is no data, so the hint acual is 0. The query is expected to have results and records, and the number of records is 1. Spring does not query the data in this query to error. The solution is to query for results, or to change the query method.

Org.springframework.dao.EmptyResultDataAccessException:Incorrect result size:expected 1,actual 0