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

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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira