Thanks Ashish. Btw I observe a typo in the log message. foregn --> foreign

I hope someone could fix it :)

Vikas

On Jul 10, 2009, at 1:28 PM, ash...@apache.org wrote:

Author: ashish
Date: Fri Jul 10 07:58:40 2009
New Revision: 792826

URL: http://svn.apache.org/viewvc?rev=792826&view=rev
Log:
[java] 2009-07-10 13:09:23,343 (main) [ GenericDelegator.java: 258:WARN ] [RelFKNameGT18] The foregn key name (length:19) was greater than 18 characters in length for relation InvoiceItemAssocType of entity InvoiceItemAssoc.

This thing always confuses me. I was in impression that the maximum length allowed for fk-name is 20 but came to know that it is 18.
Thanks Vikas for report, will remember this in future :-).

Modified:
   ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml

Modified: ofbiz/trunk/applications/accounting/entitydef/ entitymodel.xml
URL: 
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml?rev=792826&r1=792825&r2=792826&view=diff
= = = = = = = = ====================================================================== --- ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml (original) +++ ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml Fri Jul 10 07:58:40 2009
@@ -1284,14 +1284,14 @@
      <prim-key field="invoiceItemSeqIdTo"/>
      <prim-key field="invoiceItemAssocTypeId"/>
      <prim-key field="fromDate"/>
- <relation type="one" fk-name="IN_ITMASC_TYP_IIASC" rel-entity- name="InvoiceItemAssocType"> + <relation type="one" fk-name="INITMASCTYP_IIASC" rel-entity- name="InvoiceItemAssocType">
        <key-map field-name="invoiceItemAssocTypeId"/>
      </relation>
- <relation type="one" fk-name="IN_ITMASSC_FIITM" title="From" rel-entity-name="InvoiceItem"> + <relation type="one" fk-name="INITMASC_FIITM" title="From" rel-entity-name="InvoiceItem"> <key-map field-name="invoiceIdFrom" rel-field- name="invoiceId"/> <key-map field-name="invoiceItemSeqIdFrom" rel-field- name="invoiceItemSeqId"/>
      </relation>
- <relation type="one" fk-name="IN_ITMASSC_TIITM" title="To" rel-entity-name="InvoiceItem"> + <relation type="one" fk-name="INITMASC_TIITM" title="To" rel- entity-name="InvoiceItem">
        <key-map field-name="invoiceIdTo" rel-field-name="invoiceId"/>
<key-map field-name="invoiceItemSeqIdTo" rel-field- name="invoiceItemSeqId"/>
      </relation>
@@ -1311,7 +1311,7 @@
      <field name="hasTable" type="indicator"></field>
      <field name="description" type="description"></field>
      <prim-key field="invoiceItemAssocTypeId"/>
- <relation type="one" fk-name="IN_ITASC_TYP_PARNT" title="Parent" rel-entity-name="InvoiceItemAssocType"> + <relation type="one" fk-name="INITMASCTYP_PRNT" title="Parent" rel-entity-name="InvoiceItemAssocType"> <key-map field-name="parentTypeId" rel-field- name="invoiceItemAssocTypeId"/>
      </relation>
    </entity>



Reply via email to