1 Reply Latest reply on Jul 11, 2014 5:45 AM by wdfink

    Hibernate and Oracle: Sequence Issue




      I'm trying to persist a record in my Oracle database but I receive this message: ORA-06576: not a valid function or procedure name”.


      In my server.log I found the statement that Hibernate creates, it's “call next value for MYSEQUENCE”. When I execute this same statement using SQL Developer I receive the same message ORA-06576. So I understand that my Oracle 10.2 does not support this syntax "next for <sequence>".


      I tryed to change the Hibernate dialect to OracleDialect, Oracle8iDialect, Oracle9iDialect, Oracle10gDialect... but the the statement that it generates is the same for all of them ("call next value for...")


      Would you have any suggestion?


      This is how I my class is annotated:


      @Table(name = "TB_MOVIMENTO")
      @SequenceGenerator(sequenceName = "MYSEQUENCE", name = "hardSeq", allocationSize = 1)
      public class Movimento implements Serializable {
        @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "hardSeq")
        @Column(name = "ID_MOVIMENTO")
        private Long idMovimento;