The approach I've always used was to put the data in the sequence value
entity itself, and then you have granular control over each
entity/sequence too. When migrating from an older version of OFBiz
usually you'll migrate the sequence values as well too.
On the other hand there may be reasons why that won't work, though I
can't think of any off the top of my head (and I haven't run into any).
Is there something you've run into that would prevent you from taking
this approach?
-David
On Wed, 2009-07-08 at 19:08 +0530, Ashish Vijaywargiya wrote:
> In SequenceUtil.java file line #112 is responsible to generate the first
> sequence id for all the tables where primary key is auto generated.
> By changing this value I can change the start sequence Id for the tables.
> Here is the line from that file:
>
> public static final long startSeqId = 10000;
>
> Isn't it good to move this value in some property file?
>
> The reason for this change is as follows:
> Suppose a I am using OFBiz 4.0.
> Now I am migrating data which has Party Records in the range of 50,000 or
> more.
> The sequence ids for party is having sequence id started from 10000, 10001
> ... and so on.
> And the client is having similar range of data for Order and other
> associated entities.
>
> This move will help us to do changes in property file instead of changing
> java code snippet.
>
> Thoughts?
> --
> Ashish
Locked
