Skip to main content



      Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » teneo:circular loop on DB2 error
teneo:circular loop on DB2 error [message #615872] Thu, 13 March 2008 17:03
Eclipse UserFriend
Hi Martin,

I'm using teneo with DB2 and on certain section of my meta-data during my
database initialize returns me an error which is essentially a loop -
table a is connect to table b to table c to table a.

DB21034E The command was processed as an SQL statement because it was not
a valid Command Line Processor command. During SQL processing it
returned: SQL20254N FOREIGN KEY "NVGTNLMN_LYTLMNTR" is not valid since it
would cause
table "DB2INST1.NAVIGATIONELEMENT" to be delete-connected to itself
through a cycle that contains a delete rule of either RESTRICT or SET
NULL. Reason code = "1". SQLSTATE=42915

DB2 was able to pinpoint where this happens and am able to replicate it on
a small sample.

If I make a substitution change in one of the element (for loop:Text and
copy Text into Preference), the problem goes away.

eg

<xs:complexType name="Preference">
<xs:sequence>
<xs:element name="value" type="loop:Text" minOccurs="0"
maxOccurs="unbounded"/> <--- use actual Text here
</xs:sequence>
<xs:attribute name="name" type="xs:string" use="required"/>
</xs:complexType>

I'm not sure if this is a bug or not. Perhaps changing my settings on how
I generate jdo might be a workaround for this problem. Currently I am using

FETCH_CONTAINMENT_EAGERLY = "true"
JOIN_COLUMN_NAMING_STRATEGY = "simple"
MAXIMUM_SQL_NAME_LENGTH = "18"
INHERITANCE_MAPPING = JOINED/SINGLE_TABLE (tried both)

Is there any other settings that you think I can try? I sent you my simple
sample just in case you want to try it. Thanks.

Julia
Previous Topic:[Teneo] Is there a way to separate notation that define column length?
Next Topic:[CDO 0.8M5] Persisting Enums troubles
Goto Forum:
  


Current Time: Fri Jul 04 16:45:36 EDT 2025

Powered by FUDForum. Page generated in 0.04125 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top