db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Kröz (JIRA) <j...@apache.org>
Subject [jira] Commented: (OJB-52) KeyConstraintViolatedException during store
Date Fri, 01 Jul 2005 09:55:58 GMT
    [ http://issues.apache.org/jira/browse/OJB-52?page=comments#action_12314880 ] 

Michael Kröz commented on OJB-52:

I did some further research on this and found out, that the people of kodo jdo had the same

See this from http://www.solarmetric.com/Software/Documentation/3.3.3/docs/sql_errors.html:
HSQL	-8	23000	 Integrity constraint violation in statement %s 	 
Attempted modification of a row that would cause a violation of referential integrity constraints.
Make sure to enable  SQL statement ordering.

They solve this with the mentioned SQL statement ordering. The Link to SQL statement ordering,
where you can
read yourself is here: http://www.solarmetric.com/Software/Documentation/3.3.3/docs/ref_guide_dbsetup_fks.html

A workaround would be to change the used database.

> KeyConstraintViolatedException during store
> -------------------------------------------
>          Key: OJB-52
>          URL: http://issues.apache.org/jira/browse/OJB-52
>      Project: OJB
>         Type: Bug
>     Versions: 1.0.3
>  Environment: ojb 1.0.3, hsqldb from ojb-blank, enriched with junit, ojb-junit
> java 1.4.2_04
>     Reporter: Michael Kröz
>     Priority: Minor
>  Attachments: TestArguments.java, TestArguments.java
> 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)

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org

View raw message