[OJB-52] KeyConstraintViolatedException during store

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Invalid
• Affects Version/s: 1.0.3
• Fix Version/s: 1.0.4
• Environment: ojb 1.0.3, hsqldb from ojb-blank, enriched with junit, ojb-junit; java 1.4.2_04
• Assignee: Unassigned
• Reporter: Micha K
• Created: 26/Jun/05 00:18
• Updated: 15/Nov/05 02:49
• Resolved: 15/Nov/05 02:49

Description

Hi,
I am getting a KeyConstraintViolatedException during store of an object structure.
I supplied a test that shows this. Can someone verify that this is really a bug?

The actual exception message was this:
testThree(TestArguments)org.apache.ojb.broker.KeyConstraintViolatedException: SQL failure while insert object data for class Someclass, PK of the given object is [ Id=1], object was **Someclass ** Id: 1 text:some attribute, exception message is [Integrity constraint violation: SOMECLASS_FK_1 table: OTHERCLASS in statement [INSERT INTO Someclass (Id,otherclassID,text) VALUES (1,2,'some attribute') ]], SQL code [23000]
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImpl.java:266)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:1754)