The column name is not valid in springboot

Question

I wrote native query but I'm getting an error:

The column name covidSymptomId is not valid.

What's wrong?

CovidSymptom.java

 @Data
 @AllArgsConstructor
 @NoArgsConstructor
 @Entity
 @Table(name="CovidSymptom")
 public class CovidSymptom {

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "covidSymptomId")
private int id;

@ManyToOne
@JoinColumn(name = "covidId")
private Covid covidSymptom;

@Column(name = "symptom")
private String symptom;
}

CovidSymptomDao.java

@Query(nativeQuery = true,value = "Select symptom From CovidSymptom GROUP BY symptom order by count(covidSymptomId) desc")
List<CovidSymptom> getMost3SymptomOffCovid();

As per the question guide, please do not post images of code, data, error messages, etc. - copy or type the text into the question. Please reserve the use of images for diagrams or demonstrating rendering bugs, things that are impossible to describe accurately via text. — Dale K
– Dale K, Commented Dec 30, 2021 at 18:51
What value would you show for that column? You are aggregating by a different column, so either you select an aggregation such as COUNT or MIN, or you remove the association. — Charlieface
– Charlieface, Commented Dec 30, 2021 at 21:06

SledgeHammer · Accepted Answer · 2021-12-30 19:32:59Z

1

You need to include all columns that are mapped in your query. So:

Select covidSymptomId, symptom....

answered Dec 30, 2021 at 19:32

SledgeHammer

7,7668 gold badges54 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kadri Over a year ago

Now I'm getting " Column 'CovidSymptom.covidSymptomId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause." this error.

Charlieface Over a year ago

@Kadri That's because you are aggregating, and that column is not in the GROUP BY so it needs an aggregation function

Med Cezir · Accepted Answer · 2021-12-31 01:10:04Z

1

I'm not sure why you're getting a column name problem, since your select query returns a list of "symptom"(String), whilst your method provides a list of "CovidSymptom" (Object).

answered Dec 31, 2021 at 1:10

Med Cezir

212 bronze badges

Collectives™ on Stack Overflow

The column name is not valid in springboot

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related