You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by as...@apache.org on 2009/07/10 09:58:40 UTC
svn commit: r792826 -
/ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
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>
Re: svn commit: r792826 - /ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
It was crystal clear to me Vikas :-).
Someone having framework access will take care of it soon.
--
Ashish
On Fri, Jul 10, 2009 at 6:57 PM, Vikas Mayur <vi...@hotwaxmedia.com>wrote:
> Sorry, If I wasn't clear. I was referring to the following part of the log
> that is generated by the system.
>
> [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.
>>
>
> Vikas
>
>
> On Jul 10, 2009, at 1:56 PM, Vikas Mayur wrote:
>
> 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, ashish@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>
>>>
>>>
>>>
>>
>
Re: svn commit: r792826 - /ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
Posted by Vikas Mayur <vi...@hotwaxmedia.com>.
Sorry, If I wasn't clear. I was referring to the following part of the
log that is generated by the system.
> [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.
Vikas
On Jul 10, 2009, at 1:56 PM, Vikas Mayur wrote:
> 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, ashish@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>
>>
>>
>
Re: svn commit: r792826 - /ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
Posted by Vikas Mayur <vi...@hotwaxmedia.com>.
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, ashish@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>
>
>