8:39 a.m.
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.
8:23 a.m.
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(a)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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
7:05 a.m.
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(a)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(a)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(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>
3583
days inactive
3586
days old
2 comments
2 participants
participants (2)
-
Janario Oliveira -
Steve Ebersole