This content has been marked as final.
Show 6 replies
-
1. Re: Oracle Sequence grows inconsistently
tcunning May 26, 2009 8:29 PM (in response to tschungelbuch)Are you using the sequence on multiple tables?
-
2. Re: Oracle Sequence grows inconsistently
tschungelbuch May 27, 2009 2:53 AM (in response to tschungelbuch)No, I don't.
In addition the sequence does not use the cache option. -
3. Re: Oracle Sequence grows inconsistently
tcunning May 27, 2009 6:59 PM (in response to tschungelbuch)Could a transaction rolling back be causing the gap?
-
4. Re: Oracle Sequence grows inconsistently
tschungelbuch May 28, 2009 6:57 AM (in response to tschungelbuch)No, it happens always, and is reproducible.
-
5. Re: Oracle Sequence grows inconsistently
kconner Jun 8, 2009 9:48 AM (in response to tschungelbuch)As the manipulation is purely within oracle you would need to examine the database interactions between JBoss AS and Oracle in order to discover any possible interaction which could lead to this behaviour.
Kev -
6. Re: Oracle Sequence grows inconsistently
tschungelbuch Jun 9, 2009 6:18 AM (in response to tschungelbuch)Dear Kevin
Thank you for your reply.
Do you know what I could use to analyze the interaction between Oracle and JBoss AS?
Kind regards
tschungelbuch