Results 1 to 8 of 8

Thread: roo oracle sequence exception

Threaded View

  1. #1
    Join Date
    Jun 2011
    Posts
    6

    Default roo oracle sequence exception

    Hi, I tried looking up spring roo forum for similar issue, 89627-ROO-test-doesnot-work-with-Oracle-DB. Ironically I m using roo 1.1.4 which is supposed to have this issue fixed. oracle 11g.

    I added the following annotations to my java class for it to use sequence.
    My sequence is defined in my schema and I m able to execute a select seq.nextval from dual using an external tool.
    But with the app when I try to insert data, I run into sequence not found and it mentions hibernate_seq does not exist. I could not find references of hibernate_seq in all generated files.
    I m not sure of how to make make insert statements use specific sequence than hibernate_seq.

    Code:
    @RooJavaBean
    @RooToString 
    @RooEntity(identifierField = "pk_id", identifierColumn = "pk_id", table = "TABLE_NAME", schema = "SCHEMA_NAME")
    @SequenceGenerator(sequenceName="pk_id_seq",name="pkIdSeq")
    Any help would be much appreciated.

    thank you,
    Kay.
    Last edited by k_123; Jun 1st, 2011 at 03:19 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •