Regrading creating new Entities

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

Regrading creating new Entities

GNANASHANKAR
The problem I'm having is when I use webtools to export the data I get
a SQL error because the entity engine adds the following ofbiz columns
to the SQL query:

LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP,
CREATED_STAMP,
CREATED_TX_STAMP


Since the table is not an ofbiz entity the columns do not exist and
the generated query will fail.  Is there a way to specify in the
entity model to only use those columns that are explicitly defined in
the definition file?
Reply | Threaded
Open this post in threaded view
|

Re: Regrading creating new Entities

Jacques Le Roux
Administrator
There is a parameter no-auto-stamp for entities

Jacques

From: "Gnanashankar Shanmugam" <[hidden email]>

> The problem I'm having is when I use webtools to export the data I get
> a SQL error because the entity engine adds the following ofbiz columns
> to the SQL query:
>
> LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP,
> CREATED_STAMP,
> CREATED_TX_STAMP
>
>
> Since the table is not an ofbiz entity the columns do not exist and
> the generated query will fail.  Is there a way to specify in the
> entity model to only use those columns that are explicitly defined in
> the definition file?
>

Reply | Threaded
Open this post in threaded view
|

Re: Regrading creating new Entities

GNANASHANKAR
hi jacques,  In EntityEngine.xml, where i have to give no-auto-stamp
parameter for entities..any explain clearly..Advance thanks..

On Wed, Sep 30, 2009 at 2:24 PM, Jacques Le Roux <
[hidden email]> wrote:

> There is a parameter no-auto-stamp for entities
>
> Jacques
>
> From: "Gnanashankar Shanmugam" <[hidden email]>
>
>  The problem I'm having is when I use webtools to export the data I get
>> a SQL error because the entity engine adds the following ofbiz columns
>> to the SQL query:
>>
>> LAST_UPDATED_STAMP,
>> LAST_UPDATED_TX_STAMP,
>> CREATED_STAMP,
>> CREATED_TX_STAMP
>>
>>
>> Since the table is not an ofbiz entity the columns do not exist and
>> the generated query will fail.  Is there a way to specify in the
>> entity model to only use those columns that are explicitly defined in
>> the definition file?
>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Regrading creating new Entities

Jacques Le Roux
Administrator
It's an attribute of Entity, see entitymodel.xml

Jacques

From: "Gnanashankar Shanmugam" <[hidden email]>

> hi jacques,  In EntityEngine.xml, where i have to give no-auto-stamp
> parameter for entities..any explain clearly..Advance thanks..
>
> On Wed, Sep 30, 2009 at 2:24 PM, Jacques Le Roux <
> [hidden email]> wrote:
>
>> There is a parameter no-auto-stamp for entities
>>
>> Jacques
>>
>> From: "Gnanashankar Shanmugam" <[hidden email]>
>>
>>  The problem I'm having is when I use webtools to export the data I get
>>> a SQL error because the entity engine adds the following ofbiz columns
>>> to the SQL query:
>>>
>>> LAST_UPDATED_STAMP,
>>> LAST_UPDATED_TX_STAMP,
>>> CREATED_STAMP,
>>> CREATED_TX_STAMP
>>>
>>>
>>> Since the table is not an ofbiz entity the columns do not exist and
>>> the generated query will fail.  Is there a way to specify in the
>>> entity model to only use those columns that are explicitly defined in
>>> the definition file?
>>>
>>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: Regrading creating new Entities

GNANASHANKAR
hi jacques,
 i created new component called entitytest, in that entitytest component
entitymodel.xml, i created new entity called Planet. given below i wrote
entity like

<entity entity-name="Planet" package-name="org.ofbiz.entitytest">
    <field name="planetId" type="id-ne"/>
    <field name="planetName" type="name"/>
    <field name="fromDate" type="date-time"/>
    <field name="thruDate" type="date-time"/>
    <prim-key field="planetId"/>
    <index name="PLANET_NAME_IDX" unique="true">
    <index-field name="planetName"/>
    </index>
   </entity>

in the above entity where i have to specific parameter no-auto-stamp.

On Wed, Sep 30, 2009 at 3:00 PM, Jacques Le Roux <
[hidden email]> wrote:

> It's an attribute of Entity, see entitymodel.xml
>
>
> Jacques
>
> From: "Gnanashankar Shanmugam" <[hidden email]>
>
>> hi jacques,  In EntityEngine.xml, where i have to give no-auto-stamp
>> parameter for entities..any explain clearly..Advance thanks..
>>
>> On Wed, Sep 30, 2009 at 2:24 PM, Jacques Le Roux <
>> [hidden email]> wrote:
>>
>>  There is a parameter no-auto-stamp for entities
>>>
>>> Jacques
>>>
>>> From: "Gnanashankar Shanmugam" <[hidden email]>
>>>
>>>  The problem I'm having is when I use webtools to export the data I get
>>>
>>>> a SQL error because the entity engine adds the following ofbiz columns
>>>> to the SQL query:
>>>>
>>>> LAST_UPDATED_STAMP,
>>>> LAST_UPDATED_TX_STAMP,
>>>> CREATED_STAMP,
>>>> CREATED_TX_STAMP
>>>>
>>>>
>>>> Since the table is not an ofbiz entity the columns do not exist and
>>>> the generated query will fail.  Is there a way to specify in the
>>>> entity model to only use those columns that are explicitly defined in
>>>> the definition file?
>>>>
>>>>
>>>>
>>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Regrading creating new Entities

Scott Gray-2
<entity entity-name="Planet" package-name="org.ofbiz.entitytest" no-
auto-stamp="true">

Regards
Scott

On 30/09/2009, at 10:51 PM, Gnanashankar Shanmugam wrote:

> hi jacques,
> i created new component called entitytest, in that entitytest  
> component
> entitymodel.xml, i created new entity called Planet. given below i  
> wrote
> entity like
>
> <entity entity-name="Planet" package-name="org.ofbiz.entitytest">
>    <field name="planetId" type="id-ne"/>
>    <field name="planetName" type="name"/>
>    <field name="fromDate" type="date-time"/>
>    <field name="thruDate" type="date-time"/>
>    <prim-key field="planetId"/>
>    <index name="PLANET_NAME_IDX" unique="true">
>    <index-field name="planetName"/>
>    </index>
>   </entity>
>
> in the above entity where i have to specific parameter no-auto-stamp.
>
> On Wed, Sep 30, 2009 at 3:00 PM, Jacques Le Roux <
> [hidden email]> wrote:
>
>> It's an attribute of Entity, see entitymodel.xml
>>
>>
>> Jacques
>>
>> From: "Gnanashankar Shanmugam" <[hidden email]>
>>
>>> hi jacques,  In EntityEngine.xml, where i have to give no-auto-stamp
>>> parameter for entities..any explain clearly..Advance thanks..
>>>
>>> On Wed, Sep 30, 2009 at 2:24 PM, Jacques Le Roux <
>>> [hidden email]> wrote:
>>>
>>> There is a parameter no-auto-stamp for entities
>>>>
>>>> Jacques
>>>>
>>>> From: "Gnanashankar Shanmugam" <[hidden email]>
>>>>
>>>> The problem I'm having is when I use webtools to export the data  
>>>> I get
>>>>
>>>>> a SQL error because the entity engine adds the following ofbiz  
>>>>> columns
>>>>> to the SQL query:
>>>>>
>>>>> LAST_UPDATED_STAMP,
>>>>> LAST_UPDATED_TX_STAMP,
>>>>> CREATED_STAMP,
>>>>> CREATED_TX_STAMP
>>>>>
>>>>>
>>>>> Since the table is not an ofbiz entity the columns do not exist  
>>>>> and
>>>>> the generated query will fail.  Is there a way to specify in the
>>>>> entity model to only use those columns that are explicitly  
>>>>> defined in
>>>>> the definition file?
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Regrading creating new Entities

GNANASHANKAR
Hi Scott and jacques,
 thank you lot..i got answer..unwanted field are removed from entity..

On Wed, Sep 30, 2009 at 3:40 PM, Scott Gray <[hidden email]>wrote:

> <entity entity-name="Planet" package-name="org.ofbiz.entitytest"
> no-auto-stamp="true">
>
> Regards
> Scott
>
>
> On 30/09/2009, at 10:51 PM, Gnanashankar Shanmugam wrote:
>
>  hi jacques,
>> i created new component called entitytest, in that entitytest component
>> entitymodel.xml, i created new entity called Planet. given below i wrote
>> entity like
>>
>> <entity entity-name="Planet" package-name="org.ofbiz.entitytest">
>>   <field name="planetId" type="id-ne"/>
>>   <field name="planetName" type="name"/>
>>   <field name="fromDate" type="date-time"/>
>>   <field name="thruDate" type="date-time"/>
>>   <prim-key field="planetId"/>
>>   <index name="PLANET_NAME_IDX" unique="true">
>>   <index-field name="planetName"/>
>>   </index>
>>  </entity>
>>
>> in the above entity where i have to specific parameter no-auto-stamp.
>>
>> On Wed, Sep 30, 2009 at 3:00 PM, Jacques Le Roux <
>> [hidden email]> wrote:
>>
>>  It's an attribute of Entity, see entitymodel.xml
>>>
>>>
>>> Jacques
>>>
>>> From: "Gnanashankar Shanmugam" <[hidden email]>
>>>
>>>  hi jacques,  In EntityEngine.xml, where i have to give no-auto-stamp
>>>> parameter for entities..any explain clearly..Advance thanks..
>>>>
>>>> On Wed, Sep 30, 2009 at 2:24 PM, Jacques Le Roux <
>>>> [hidden email]> wrote:
>>>>
>>>> There is a parameter no-auto-stamp for entities
>>>>
>>>>>
>>>>> Jacques
>>>>>
>>>>> From: "Gnanashankar Shanmugam" <[hidden email]>
>>>>>
>>>>> The problem I'm having is when I use webtools to export the data I get
>>>>>
>>>>>  a SQL error because the entity engine adds the following ofbiz columns
>>>>>> to the SQL query:
>>>>>>
>>>>>> LAST_UPDATED_STAMP,
>>>>>> LAST_UPDATED_TX_STAMP,
>>>>>> CREATED_STAMP,
>>>>>> CREATED_TX_STAMP
>>>>>>
>>>>>>
>>>>>> Since the table is not an ofbiz entity the columns do not exist and
>>>>>> the generated query will fail.  Is there a way to specify in the
>>>>>> entity model to only use those columns that are explicitly defined in
>>>>>> the definition file?
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>