오류

songi Jeon·2021년 4월 2일
0

Error updating database. Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect integer value: ',' for column isp.t_board2.RE_SEQ at row 1

The error may involve com.open.Board2.insertReviewContents-Inline

The error occurred while setting parameters

SQL: / boardVO.insertContents / INSERT INTO t_board2( SEQ , RE_SEQ , CONT , RGST_ID ) VALUES ( (SELECT IFNULL(MAX(TS.SEQ)+1,1) FROM t_board2 TS) ,? ,? ,? )

Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect integer value: ',' for column isp.t_board2.RE_SEQ at row 1

; SQL []; Data truncation: Incorrect integer value: ',' for column isp.t_board2.RE_SEQ at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect integer value: ',' for column isp.t_board2.RE_SEQ at row 1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect integer value: ',' for column isp.t_board2.RE_SEQ at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3971) ~[mysql-connector-java-5.1.45.jar:5.1.45]

해결: 쿼리 id 겹침
profile
비전공자가 백엔드 개발자 도전하는 블로그

0개의 댓글