MySQL Forums
Forum List  »  Newbie

DataIntegrityViolationException error message is truncated
Posted by: don cidula
Date: October 23, 2023 10:51AM

The following is a foreign key violation. My question is, why is the output of the error message truncated?

org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [INSERT INTO tbl_1 (`id`, `sd_id`, `code`, `tx_id`, `tx_sd_id`, `offset_tx_id`, `offset_tx_sd_id`) VALUES(5093, 1, '542332423', 770557, 1, 770558, 1) ON DUPLICATE KEY UPDATE `id`=5093, `sd_id`=1, `code`='542332423', `tx_id`=770557, `tx_sd_id`=1, `offset_tx_id`=770558, `offset_tx_sd_id`=1]; Cannot add or update a child row: a foreign key constraint fails (`schema_test1`.`tbl_1`, CONSTRAINT `fk_tbl_1_offset_trans` FOREIGN KEY (`offset_tx_id`, `offset_tx_sd_id`) REFERENCES ); nested exception is java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`schema_test1`.`tbl_1`, CONSTRAINT `fk_tbl_1_offset_trans` FOREIGN KEY (`offset_tx_id`, `offset_tx_sd_id`) REFERENCES )

Is there an option/configuration etc.., that would display/output the full error message instead of a truncated message?

Options: ReplyQuote


Subject
Written By
Posted
DataIntegrityViolationException error message is truncated
October 23, 2023 10:51AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.