[Tm4j-developers] [ tm4j-Bugs-975455 ] SQLException when deleting a player from an association

[SourceForge.net <no...@so...>]

Bugs item #975455, was opened at 2004-06-18 17:18
Message generated for change (Comment added) made by kal_ahmed
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=391879&aid=975455&group_id=27895

Category: Hibernate Impl
Group: TM4J 0.9.4
Status: Open
>Resolution: Accepted
Priority: 5
Submitted By: Andy Peel (atpeel)
>Assigned to: Kal Ahmed (kal_ahmed)
Summary: SQLException when deleting a player from an association

Initial Comment:
I'm getting this when trying to remove a topic that is
a player in an association:

	java.sql.SQLException: ERROR:  update or delete on
"tmobjects" violates foreign key constraint
"fk61e7b90dc6f0e22b" on "member_players"

I was expecting it to be a TMAPI TopicInUseException or
at least a TM4J IntegrityViolationException.

Looking at the destroy method in the Hibernate
TopicImpl, and bearing in mind that I'm not familiar
with the TM4J schema, it doesn't seem to do a check for
this case.

Kal thinks this might be a missing rule from the
Hibernate backend.

----------------------------------------------------------------------

>Comment By: Kal Ahmed (kal_ahmed)
Date: 2004-06-18 19:43

Message:
Logged In: YES 
user_id=176992

Validated with a new unit test.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=391879&aid=975455&group_id=27895