[Spring] 오류: 연산자 없음: numeric = character varying Error 해결방법

---

지정된 이름 및 인자 형식고 일치하는 연산자가 없습니다.

 

명시적 형변환자를 추가해야 할 수도 있습니다.

---

Problem

 

 

 

The data went in the columns well  as you can see 

 

But 

 

 

 

 

Then There is a problem  "오류 연산자 없음 : numeric = character varying"

 

Why did this problem arise?

 

And what's the matter ?

 

 

The problem is mean that we have to change Data type as you know 

 

 

 

 

 

as you can see The colum ID's  data type is "numeric" 

 

So we need to chnage ID to numeric type!

 

 

 

 

We have to use

Cast ( #{Column} AS NUMERIC )

Cast ( #{Column} AS INTEGER )

 

Finally I would change my mapper file like this 

 

I can resolve my problem 

 

I import the data json form So I use always String Type

 

we you got this problem, you can resolve like this.

 

 

Result

 

 

detail

 

 

 

 

 

modification

 

 

 

 

Registration

 

 

 

 

LOG

 

 

 

gottcha

 

 

Thank you  

 

---

 

To be continue..