Oracle Sequence grows inconsistently

[tschungelbuch]

I have a view which is accessing a sequence via a function call within the view.

This is the environment:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
JBoss_SOA_Platform 4.3.GA
org.springframework.orm.hibernate3


The call in the view looks like below:

CREATE VIEW vw_hibernate_test AS
SELECT fr.id ID,
 CASE WHEN LAG (fr.id) OVER (ORDER BY fr.id) = fr.id
 THEN
 LPAD (xmt_edi.f_get_seq_edi_isa_value (0), 9, '0')
 ELSE
 LPAD (xmt_edi.f_get_seq_edi_isa_value (1), 9, '0')
 END isa13
 FROM funding_report fr
 WHERE issue_date > SYSDATE-100
;

Now this works as expected when called within oracle, but when calling the same via the JBOSS hibernate layers the sequece starts to grow leaving gaps in between the sequence, normally after 11 correct sequences there is a gap of 2.

Is there anything I missed in the configuration of hibernate?

[tcunning]

Are you using the sequence on multiple tables?

[tschungelbuch]

No, I don't.

In addition the sequence does not use the cache option.

[tcunning]

Could a transaction rolling back be causing the gap?

[tschungelbuch]

No, it happens always, and is reproducible.

[kconner]

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

[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