Cause: java.sql.SQLException

🌳 에러 코드

---

 

org.springframework.jdbc.UncategorizedSQLException:

### Error updating database. Cause: java.sql.SQLException: Incorrect integer value: '/images/null_1685338402834/7ba0f1cf89ed40649c8c082e0275067d.jpg' for column 'userId' at row 1

### The error may exist in file [/Users/hongyuri/Desktop/메가스터디 IT/language/workspace/Language/bin/main/mappers/liveMapper.xml]

### The error may involve com.language.live.dao.LiveMapper.insertLive-Inline

### The error occurred while setting parameters

### SQL: INSERT INTO `live` ( `userId` ,`content` ,`ImagePath` ,`createdAt` ,`updatedAt` ) VALUES ( ? ,? ,? ,NOW() ,NOW() )

### Cause: java.sql.SQLException: Incorrect integer value: '/images/null_1685338402834/7ba0f1cf89ed40649c8c082e0275067d.jpg' for column 'userId' at row 1

; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect integer value: '/images/null_1685338402834/7ba0f1cf89ed40649c8c082e0275067d.jpg' for column 'userId' at row 1; nested exception is java.sql.SQLException: Incorrect integer value: '/images/null_1685338402834/7ba0f1cf89ed40649c8c082e0275067d.jpg' for column 'userId' at row 1

 

 

 

 

 

 

 

 

 

 

🌳 해결 방법

---

🌾 원인 :  int userId  -> String userId로  오류,     BO에서 Mapper로 리턴할때 리턴값 오류. 

 

🌾 해결 방법 : BO와 Mapper 리턴값을 다시 확인 후, ImagePath -> userId로 고치기,   userId   int로 수정.

 

 

 

 

 

 

Before

 

- Mapper

 

 

- BO

 

 

 

 

 

After

 

- Mapper

 

 

 

 

 

 

- BO