Column count doesn't match value count at row 1 메세지가 발생한다면
DB에 insert하는 데이터의 개수와 컬럼의 개수가 일치하는지 확인해보시길~
; bad SQL grammar []; nested exception is java.sql.SQLException: Column count doesn't match value count at row 1
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
'Programming > RDB' 카테고리의 다른 글
[ mysql ] Data truncation: Data too long for column, column text type (0) | 2020.11.20 |
---|---|
Mysql BLOB타입 TEXT로 변경하기 (0) | 2019.09.09 |
데이터베이스(DB) 파티셔닝이란? (0) | 2019.02.19 |
[ Mysql ] java.sql.SQLNonTransientConnectionException (0) | 2019.01.15 |