Hi getting this exception.any idea how to remove this
Caused by: java.sql.BatchUpdateException: Missing key in referenced table for referential constraint (webadrep.det_fk).
at com.informix.jdbc.IfxPreparedStatement.executeBatch(IfxPreparedStatement.java:3437)
at com.dhl.auditdatamgr.dao.AuditDAO.setDetailedAuditData(AuditDAO.java:94)
... 1 more
You did not tell us the type of database, show us the update statement, or show us the table definitions. Also, I suspect this is a database question, not a Java question.
But, from the error message, I would say that you are updating a field to a value that does not exists in another table which is defined as a foreign key to the column you are updating. The value needs to be in the foreign key table first.
Hi the databse is informix
I can not show the daatbase stament as entering the statement through telent means manuaaly any how I have screenshot of database
constarint name referenced column refrencing table refrencing column
det_fk iata_codedetail auditatiata
facility_codedetail auditatfacility
It still appears you are trying to update a column with a value that does not exist in the foreign table. The only way the update will work is if you add the value in the foreign key table first.
Try performing the update manual in whatever tool informix uses and get it working there first.
