[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3928) Oracle Sequence grows inconsistently

[Tschungel Buch (JIRA)]

Oracle Sequence grows inconsistently
------------------------------------

                 Key: HHH-3928
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3928
             Project: Hibernate Core
          Issue Type: Bug
         Environment: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
JBoss_SOA_Platform 4.3.GA
org.springframework.orm.hibernate3
            Reporter: Tschungel Buch


I have a view which is accessing a sequence via a function call within the view.
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?


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira