[hibernate-dev] Sequence Pool

[Janario Oliveira]

Thanks Steve,

I'm going to open a Feature Request.

Sorry for the wrong list :)


On Wed, Feb 11, 2015 at 12:23 PM, Steve Ebersole <steve at hibernate.org>
wrote:

> First, this is a list for discussing the development of the Hibernate
> projects, not for user/usage questions.
>
> As to your question... Yes 50 was an unfortunately choice as the default
> within the spec group.  At the moment there is no global "ignore the
> specified increment value" setting, and even though you did not explicitly
> specify it the way annotations and the JDK work we have no way of telling
> that[1].
>
> I'd be open to this as a Feature Request.
>
> [1] To code consuming annotations @SequenceGenerator(name="blah") and
> @SequenceGenerator(name="blah", increment=50) look exactly the same.  Well,
> there is *a* way, but it requires us using Jandex (or similar annotation
> processing library) that parses the source representation of the
> annotation.  Then @SequenceGenerator(name="blah") and
> @SequenceGenerator(name="blah", increment=50) look different in terms of
> the value for increment.  I have tentatively scheduled looking at moving to
> Jandex for 5.0, or 5.1, or 6.0
>
>
> On Feb 9, 2015 8:40 AM, "Janario Oliveira" <janarioliver at gmail.com> wrote:
>
>> Hi guys,
>>
>> I am migrating some code base and I have some problems using sequence.
>> As I see it works with a pool together to allocationSize. But it expects
>> that the sequence have the same increment by (50 as default).
>>
>> Is there a global configuration that disable pool and always read from the
>> sequence?
>>
>> In my case scripts are generated manually and everyone will have to
>> remember to add increment by 50 or allocationSize = 1.
>>
>>
>> Also this would change order creation vs order id.
>> e.g.
>> If I create 2 rows with hibernate it will keep pooling from 1 to 50. (id 1
>> and 2)
>> After that some procedure or script can create another one with nextval of
>> the sequence. (id 51)
>> Next hibernate create another row. (id 3)
>>
>> The right order of creation is: 1, 2, 51, 3
>> But ordering by id will load a wrong order.
>> _______________________________________________
>> hibernate-dev mailing list
>> hibernate-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>>
>