Key is not present in table error hibernate

[zabet tyan]

Hi, I am trying to save something into database, but i am getting this error:

14:10:12,690 INFO  [STDOUT] Hibernate: select nextval ('public.delivery_restriction_history_seq')

14:10:12,690 INFO  [STDOUT] Hibernate: insert into public.delivery_restriction_history (name, id) values (?, ?)

14:10:12,706 INFO  [STDOUT] Hibernate: select deliveryre_.change_date as change3_29_ from public.delivery_restriction_history deliveryre_ where delive
ryre_.id=?

14:10:12,706 INFO  [STDOUT] Hibernate: insert into public.del_res_del_type_xref (delivery_restriction_id, delivery_type_id) values (?, ?)

14:10:12,706 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null

14:10:12,706 ERROR [JDBCExceptionReporter] Batch entry 0 insert into public.del_res_del_type_xref (delivery_restriction_id, delivery_type_id) values (62, 343) was aborted.

  Call getNextException to see the cause.

14:10:12,706 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 23503

14:10:12,706 ERROR [JDBCExceptionReporter] ERROR: insert or update on table "del_res_del_type_xref" violates foreign key constraint "fk_delivery_restr
iction_delivery_type"  Detail: Key (delivery_restriction_id)=(62) is not present in table "delivery_restriction".

What I don't understand is that the values delivery_restriction_id = 62 delivery_type_id = 343 are clearly present from this line:

Batch entry 0 insert into public.del_res_del_type_xref (delivery_restriction_id, delivery_type_id) values (62, 343) was aborted

but why does hibernate complain that key is not present. I look in both tables (delivery_restriction and delivery_type) and the id's are there.

Here's del_res_del_type_xref's script

CREATE TABLE del_res_del_type_xref
(
  delivery_restriction_id integer NOT NULL,
  delivery_type_id integer NOT NULL,
  CONSTRAINT fk_delivery_restriction_delivery_type FOREIGN KEY (delivery_restriction_id)
      REFERENCES delivery_restriction (id) MATCH SIMPLE
      ON UPDATE RESTRICT ON DELETE RESTRICT,
  CONSTRAINT fk_delivery_type_del_res_del_type FOREIGN KEY (delivery_type_id)
      REFERENCES delivery_type (id) MATCH SIMPLE
      ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITH (OIDS=FALSE);

any ideas?

[Reehan Lalkhanwar]

The error only says that delivery_restriction_id = 62 is not present in delivery_restriction table.
Did you check the DB? Did you run the query on delivery_restriction for id=62 and did you get any results?

[Paul Sturrock]

iririr zz, please check your private messages.

[zabet tyan]

Yes it's there, if I run this sql command manually it works fine:

insert into public.del_res_del_type_xref (delivery_restriction_id, delivery_type_id) values (62, 343)

That's what surprises me.

Thanks

[Bear Bibeault]

"iririr zz", please check your private messages for an important administrative matter. Failure to do so will result in the removal of your account.

[Cameron Wallace McKenzie]

I'm wondering what the primary key is for this table?

-Cameron McKenzie

[zabet tyan]

Ok solved the problem. apparently one of my other hbm files were mapping to this table as well and it didn't like the changes when they came from the original table.

Thanks guys