Relative Content

Tag Archive for constraintviolationexception

How to Solve Constraint Voilation Exception

org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Cannot add or update a child row: a foreign key constraint fails (testing_soft.test_master, CONSTRAINT test_master_ibfk_1 FOREIGN KEY (TICKET_NO, LINE_NO, SAMPLE_NO, TEST_ID, BARCODE_NO) REFERENCES ticketbarcode (TICKET_NO, LINE_NO, SA) Constraint violation occurred: could not execute statement [Cannot add or update a child row: a foreign key constraint fails (testing_soft.test_master, CONSTRAINT test_master_ibfk_1 FOREIGN KEY (TICKET_NO, LINE_NO, SAMPLE_NO, TEST_ID, BARCODE_NO) REFERENCES ticketbarcode (TICKET_NO, LINE_NO, SA)] [insert into TEST_MASTER (BARCODE_NO,LINE_NO,SAMPLE_NO,TEST_ID,TEST_Name,test_result,test_type) values (?,?,?,?,?,?,?)]