Re: getNextSequenceId without discontinuity

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

Re: getNextSequenceId without discontinuity

BJ Freeman
From an emails yesterday:

When you look at the code you'll find it most certainly will skip, in
fact the default sequencing is designed for skipping to be okay in order
to perform better.

If you want a more strict sequence then take a look at the invoiceId
generation in the createInvoice service. It is configurable and some of
the options are meant to make things sequential. Be aware though that
because of the way transactions work by default (ie the transaction
isolation done), depending on the transaction isolation it can be
possible for skips to happen (ie because of phantom reads, etc), it's
just not as likely.

-David

I am looking for a similar solution.


STELTZLEN Charles sent the following on 4/24/2009 5:54 AM:

> Hi,
>
> I'am using a getNextSequenceId to generate my id for invoice entity.
>
> My problem is that the specifications of my client include the fact that
> the invoice id must have any discontinuity in these sequences (00001,
> 00002, 00003,...).
>
> For my knowlegde of ofbiz, the actual getNextSequence don't guaranted
> this requirement (don't check the highest sequence before giving a
> sequence).
>
> Am I wrong ?
>
> Is there something that can fit my whishes in ofbiz standard ?
>
> Charles.
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
Systems Integrator.