Update record is not working in OFBiz latest head

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

Update record is not working in OFBiz latest head

Divesh Dutta
Hello Developers,

I just found a weird problem while updating records in demo.ofbiz.org. I
tried it by following three ways:

1) Processed sql query from sql processor.
    Results : 1) It shows me "1 row affected"
                   2) But record does not get updated
 
2) Also tried to overwrite from "XML data import"
    Result : Record is not updated when I go that particular entity in
webtools

3) Also tried to update directly by going to that particular entity.

    Result: But the result is same as above given.

Anyone else is coming across same problem? Also found same result in
local machine.

Thanks
--
Divesh

Reply | Threaded
Open this post in threaded view
|

Re: Update record is not working in OFBiz latest head

Scott Gray-2
An update using the sql processor worked fine for me on demo.ofbiz.org

Regards
Scott

On 4/09/2009, at 8:44 PM, Divesh Dutta wrote:

> Hello Developers,
>
> I just found a weird problem while updating records in  
> demo.ofbiz.org. I tried it by following three ways:
>
> 1) Processed sql query from sql processor.
>   Results : 1) It shows me "1 row affected"
>                  2) But record does not get updated
> 2) Also tried to overwrite from "XML data import"
>   Result : Record is not updated when I go that particular entity in  
> webtools
>
> 3) Also tried to update directly by going to that particular entity.
>
>   Result: But the result is same as above given.
>
> Anyone else is coming across same problem? Also found same result in  
> local machine.
>
> Thanks
> --
> Divesh
>


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

Re: Update record is not working in OFBiz latest head

Sumit Pandit-3
In reply to this post by Divesh Dutta
Hello Divesh,

Please name the entity and field for which you are trying to update  
the values.

Thanks And Regards
Sumit Pandit

On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:

> Hello Developers,
>
> I just found a weird problem while updating records in  
> demo.ofbiz.org. I tried it by following three ways:
>
> 1) Processed sql query from sql processor.
>   Results : 1) It shows me "1 row affected"
>                  2) But record does not get updated
> 2) Also tried to overwrite from "XML data import"
>   Result : Record is not updated when I go that particular entity in  
> webtools
>
> 3) Also tried to update directly by going to that particular entity.
>
>   Result: But the result is same as above given.
>
> Anyone else is coming across same problem? Also found same result in  
> local machine.
>
> Thanks
> --
> Divesh
>

Reply | Threaded
Open this post in threaded view
|

Re: Update record is not working in OFBiz latest head

Divesh Dutta
In reply to this post by Scott Gray-2
Hello Scott,

 Have you checked entity again, after running your query ? Have you
cross-checked that your changes are reflecting back?

Thanks
--
Divesh


Scott Gray wrote:

> An update using the sql processor worked fine for me on demo.ofbiz.org
>
> Regards
> Scott
>
> On 4/09/2009, at 8:44 PM, Divesh Dutta wrote:
>
>> Hello Developers,
>>
>> I just found a weird problem while updating records in
>> demo.ofbiz.org. I tried it by following three ways:
>>
>> 1) Processed sql query from sql processor.
>>   Results : 1) It shows me "1 row affected"
>>                  2) But record does not get updated
>> 2) Also tried to overwrite from "XML data import"
>>   Result : Record is not updated when I go that particular entity in
>> webtools
>>
>> 3) Also tried to update directly by going to that particular entity.
>>
>>   Result: But the result is same as above given.
>>
>> Anyone else is coming across same problem? Also found same result in
>> local machine.
>>
>> Thanks
>> --
>> Divesh
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: Update record is not working in OFBiz latest head

Divesh Dutta
In reply to this post by Sumit Pandit-3
Hi Sumit,

This is not the problem with any particular entity or field. This is the
case with all the entities.

Thanks
--
Divesh


Sumit Pandit wrote:

> Hello Divesh,
>
> Please name the entity and field for which you are trying to update
> the values.
>
> Thanks And Regards
> Sumit Pandit
>
> On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:
>
>> Hello Developers,
>>
>> I just found a weird problem while updating records in
>> demo.ofbiz.org. I tried it by following three ways:
>>
>> 1) Processed sql query from sql processor.
>>   Results : 1) It shows me "1 row affected"
>>                  2) But record does not get updated
>> 2) Also tried to overwrite from "XML data import"
>>   Result : Record is not updated when I go that particular entity in
>> webtools
>>
>> 3) Also tried to update directly by going to that particular entity.
>>
>>   Result: But the result is same as above given.
>>
>> Anyone else is coming across same problem? Also found same result in
>> local machine.
>>
>> Thanks
>> --
>> Divesh
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: Update record is not working in OFBiz latest head

Pranay Pandey-2
It doesn't show you any error message and at the same time doesn't  
update a specific record in the db.

Thanks & Regards
--
Pranay Pandey
HotWax Media | www.hotwaxmedia.com
Ext: 442 | Direct: +91 98260 35576 | Skype: pranay.pandey

On Sep 4, 2009, at 2:37 PM, Divesh Dutta wrote:

> Hi Sumit,
>
> This is not the problem with any particular entity or field. This is  
> the case with all the entities.
>
> Thanks
> --
> Divesh
>
>
> Sumit Pandit wrote:
>> Hello Divesh,
>>
>> Please name the entity and field for which you are trying to update  
>> the values.
>>
>> Thanks And Regards
>> Sumit Pandit
>>
>> On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:
>>
>>> Hello Developers,
>>>
>>> I just found a weird problem while updating records in  
>>> demo.ofbiz.org. I tried it by following three ways:
>>>
>>> 1) Processed sql query from sql processor.
>>>  Results : 1) It shows me "1 row affected"
>>>                 2) But record does not get updated
>>> 2) Also tried to overwrite from "XML data import"
>>>  Result : Record is not updated when I go that particular entity  
>>> in webtools
>>>
>>> 3) Also tried to update directly by going to that particular entity.
>>>
>>>  Result: But the result is same as above given.
>>>
>>> Anyone else is coming across same problem? Also found same result  
>>> in local machine.
>>>
>>> Thanks
>>> --
>>> Divesh
>>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: Update record is not working in OFBiz latest head

Sumit Pandit-3
In reply to this post by Divesh Dutta
Hello Divesh,

I tried to update directly the field firstName of Person entity, and  
it is updated successfully.

You  can see it at - https://demo.ofbiz.org/webtools/control/FindGeneric?entityName=Person&find=true&VIEW_SIZE=50&VIEW_INDEX=0
Where I have changed the firstName of partyId = 10000 and assign it to  
"Rishi". You can also change it and assign some other name like  
"Sumit" to it.
Please verify.

Are you trying to change description field of any entity ?

--
Thanks And Regards
Sumit Pandit

On 04-Sep-09, at 2:37 PM, Divesh Dutta wrote:

> Hi Sumit,
>
> This is not the problem with any particular entity or field. This is  
> the case with all the entities.
>
> Thanks
> --
> Divesh
>
>
> Sumit Pandit wrote:
>> Hello Divesh,
>>
>> Please name the entity and field for which you are trying to update  
>> the values.
>>
>> Thanks And Regards
>> Sumit Pandit
>>
>> On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:
>>
>>> Hello Developers,
>>>
>>> I just found a weird problem while updating records in  
>>> demo.ofbiz.org. I tried it by following three ways:
>>>
>>> 1) Processed sql query from sql processor.
>>>  Results : 1) It shows me "1 row affected"
>>>                 2) But record does not get updated
>>> 2) Also tried to overwrite from "XML data import"
>>>  Result : Record is not updated when I go that particular entity  
>>> in webtools
>>>
>>> 3) Also tried to update directly by going to that particular entity.
>>>
>>>  Result: But the result is same as above given.
>>>
>>> Anyone else is coming across same problem? Also found same result  
>>> in local machine.
>>>
>>> Thanks
>>> --
>>> Divesh
>>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: Update record is not working in OFBiz latest head

Sumit Pandit-3
In reply to this post by Divesh Dutta
Hello Divesh,

Please refer *EntityLabels.xml before updating anything. You need to  
update the entry as well(if there is any).

--
Thanks And Regards
Sumit Pandit


On 04-Sep-09, at 2:37 PM, Divesh Dutta wrote:

> Hi Sumit,
>
> This is not the problem with any particular entity or field. This is  
> the case with all the entities.
>
> Thanks
> --
> Divesh
>
>
> Sumit Pandit wrote:
>> Hello Divesh,
>>
>> Please name the entity and field for which you are trying to update  
>> the values.
>>
>> Thanks And Regards
>> Sumit Pandit
>>
>> On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:
>>
>>> Hello Developers,
>>>
>>> I just found a weird problem while updating records in  
>>> demo.ofbiz.org. I tried it by following three ways:
>>>
>>> 1) Processed sql query from sql processor.
>>>  Results : 1) It shows me "1 row affected"
>>>                 2) But record does not get updated
>>> 2) Also tried to overwrite from "XML data import"
>>>  Result : Record is not updated when I go that particular entity  
>>> in webtools
>>>
>>> 3) Also tried to update directly by going to that particular entity.
>>>
>>>  Result: But the result is same as above given.
>>>
>>> Anyone else is coming across same problem? Also found same result  
>>> in local machine.
>>>
>>> Thanks
>>> --
>>> Divesh
>>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: Update record is not working in OFBiz latest head

Divesh Dutta
Oh!

Thanks Sumit. I got this now. Actually I was updating the description
for ProductFeatureCategory entity. So I went to "Label Manager" and
updated the value for the "Key", I was working on. But I have another
concern here is:

We should prepare UILabels only for seed data. Not In case of other
entities having "description" fields.

If we need to manage "description" field for many languages, then we can
do some thing like it is done in 'DemoProductI18nData.xml'. WDYT?

Thanks
--
Divesh


Sumit Pandit wrote:

> Hello Divesh,
>
> Please refer *EntityLabels.xml before updating anything. You need to
> update the entry as well(if there is any).
>
> --
> Thanks And Regards
> Sumit Pandit
>
>
> On 04-Sep-09, at 2:37 PM, Divesh Dutta wrote:
>
>> Hi Sumit,
>>
>> This is not the problem with any particular entity or field. This is
>> the case with all the entities.
>>
>> Thanks
>> --
>> Divesh
>>
>>
>> Sumit Pandit wrote:
>>> Hello Divesh,
>>>
>>> Please name the entity and field for which you are trying to update
>>> the values.
>>>
>>> Thanks And Regards
>>> Sumit Pandit
>>>
>>> On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:
>>>
>>>> Hello Developers,
>>>>
>>>> I just found a weird problem while updating records in
>>>> demo.ofbiz.org. I tried it by following three ways:
>>>>
>>>> 1) Processed sql query from sql processor.
>>>>  Results : 1) It shows me "1 row affected"
>>>>                 2) But record does not get updated
>>>> 2) Also tried to overwrite from "XML data import"
>>>>  Result : Record is not updated when I go that particular entity in
>>>> webtools
>>>>
>>>> 3) Also tried to update directly by going to that particular entity.
>>>>
>>>>  Result: But the result is same as above given.
>>>>
>>>> Anyone else is coming across same problem? Also found same result
>>>> in local machine.
>>>>
>>>> Thanks
>>>> --
>>>> Divesh
>>>>
>>>
>>
>