Re: svn commit: r792826 - /ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: svn commit: r792826 - /ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml

Vikas Mayur-3
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, [hidden email] 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 | Threaded
Open this post in threaded view
|

Re: svn commit: r792826 - /ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml

Vikas Mayur-3
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, [hidden email] 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 | Threaded
Open this post in threaded view
|

Re: svn commit: r792826 - /ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml

Ashish Vijaywargiya
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 <[hidden email]>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, [hidden email] 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>
>>>
>>>
>>>
>>
>