The column name XYZ was not found in this ResultSet

Question

I wrote a native query in spring boot. (shown below) . This is sowing me error "The column name seq_id was not found in this ResultSet.". But when Iam removing distinct and putting * then the result is coming. Here seq_id is a sequence here.

@Query(value = " SELECT DISTINCT DEPOT FROM  {h-schema}mt_schedule_task where schedule_name=? AND department=? ", nativeQuery=true)

What's the object for this querying result? An entity? Or a String? — LHCHIN, Jun 12 '19 at 05:15
it is done now. It was entity . Now I changed to String. thanks — Neha, Jun 13 '19 at 07:39

score 0 · Answer 1 · answered Jun 13 '19 at 06:32

0

I think "DEPOT" is a column name.Commonly native query only return object.

Check this one click

answered Jun 13 '19 at 06:32

Sana

360
3
13

The column name XYZ was not found in this ResultSet

1 Answers1