$2 referential integrity violation

From: Dhruti Ramani (dhrutiraman..ahoo.com)
Date: Wed Nov 23 2005 - 09:50:19 EST

Next message: Gentry, Michael $Contractor$: "RE: $2 referential integrity violation"

Previous message: Jürgen Saar: "working on database with cayenne and other applications"
Next in thread: Gentry, Michael $Contractor$: "RE: $2 referential integrity violation"
Reply: Gentry, Michael $Contractor$: "RE: $2 referential integrity violation"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

  In my application, I have relation M to 1 between Deal and annuityissuer.(Deal can have one issuer but one issuer can be associated with many deals) Now in system Deal has issuer but when i try to delete that issuer it raises following execption.

  org.postgres.util.PSQLExecption: ERROR: $2 referential integrity violation - key in annuityissuer still referenced from deal.

  In the modeler i have marked Delete Rule as "Nullify" in both objects. I am not database person, Am I missing something?

  Thanks,
  Denna

---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.

Next message: Gentry, Michael $Contractor$: "RE: $2 referential integrity violation"
Previous message: Jürgen Saar: "working on database with cayenne and other applications"
Next in thread: Gentry, Michael $Contractor$: "RE: $2 referential integrity violation"
Reply: Gentry, Michael $Contractor$: "RE: $2 referential integrity violation"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Wed Nov 23 2005 - 09:50:21 EST