You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by snowch <sn...@coralms.com> on 2009/04/28 16:42:39 UTC
Running SQL against legacy database.
I have a legacy database that until now I have been just using read-only. I
now have a need to update some fields. What are my options?
I have been using entities with 'no-auto-stamp="true"' mentioned, but I am
not sure what it does. Can anyone on this forum explain?
Alternatively, can I run SQL statements directly from my services to perform
these small db updates?
Many thanks in advance,
Chris
--
View this message in context: http://www.nabble.com/Running-SQL-against-legacy-database.-tp23278522p23278522.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Running SQL against legacy database.
Posted by Jacques Le Roux <ja...@les7arts.com>.
auto-stamp is mostly (if not only) used for synchronization between DBs.
Jacques
From: "snowch" <sn...@coralms.com>
>
> Hi Adrian,
>
> I wasn't sure if the entity engine would function properly with
> no-auto-stamp="true". I thought the auto-stamp fields may be required for
> versioning of the data.
>
> If the entity engine works ok read/write with no-auto-stamp="true", then I
> will do my updates using entitites.
>
> Many thanks,
>
> Chris
>
>
> Adrian Crum wrote:
>>
>> You have to set no-auto-stamp="true" on your legacy database because it
>> doesn't contain the necessary fields.
>>
>> You can use your legacy database the same as any OFBiz entity. There is
>> nothing special to do.
>>
>> Why do you need to run SQL directly? Is there something missing in the
>> entity engine that you need?
>>
>> -Adrian
>>
>> snowch wrote:
>>> I have a legacy database that until now I have been just using read-only.
>>> I
>>> now have a need to update some fields. What are my options?
>>>
>>> I have been using entities with 'no-auto-stamp="true"' mentioned, but I
>>> am
>>> not sure what it does. Can anyone on this forum explain?
>>>
>>> Alternatively, can I run SQL statements directly from my services to
>>> perform
>>> these small db updates?
>>>
>>> Many thanks in advance,
>>>
>>> Chris
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Running-SQL-against-legacy-database.-tp23278522p23279182.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: Running SQL against legacy database.
Posted by snowch <sn...@coralms.com>.
Hi Adrian,
I wasn't sure if the entity engine would function properly with
no-auto-stamp="true". I thought the auto-stamp fields may be required for
versioning of the data.
If the entity engine works ok read/write with no-auto-stamp="true", then I
will do my updates using entitites.
Many thanks,
Chris
Adrian Crum wrote:
>
> You have to set no-auto-stamp="true" on your legacy database because it
> doesn't contain the necessary fields.
>
> You can use your legacy database the same as any OFBiz entity. There is
> nothing special to do.
>
> Why do you need to run SQL directly? Is there something missing in the
> entity engine that you need?
>
> -Adrian
>
> snowch wrote:
>> I have a legacy database that until now I have been just using read-only.
>> I
>> now have a need to update some fields. What are my options?
>>
>> I have been using entities with 'no-auto-stamp="true"' mentioned, but I
>> am
>> not sure what it does. Can anyone on this forum explain?
>>
>> Alternatively, can I run SQL statements directly from my services to
>> perform
>> these small db updates?
>>
>> Many thanks in advance,
>>
>> Chris
>
>
--
View this message in context: http://www.nabble.com/Running-SQL-against-legacy-database.-tp23278522p23279182.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Running SQL against legacy database.
Posted by Adrian Crum <ad...@hlmksw.com>.
You have to set no-auto-stamp="true" on your legacy database because it
doesn't contain the necessary fields.
You can use your legacy database the same as any OFBiz entity. There is
nothing special to do.
Why do you need to run SQL directly? Is there something missing in the
entity engine that you need?
-Adrian
snowch wrote:
> I have a legacy database that until now I have been just using read-only. I
> now have a need to update some fields. What are my options?
>
> I have been using entities with 'no-auto-stamp="true"' mentioned, but I am
> not sure what it does. Can anyone on this forum explain?
>
> Alternatively, can I run SQL statements directly from my services to perform
> these small db updates?
>
> Many thanks in advance,
>
> Chris