You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by "Michael Kröz (JIRA)" <ji...@apache.org> on 2005/07/01 11:55:58 UTC
[jira] Commented: (OJB-52) KeyConstraintViolatedException during store
[ 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 problem.
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:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org