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.
Any help would be much appreciated.
@RooEntity(identifierField = "pk_id", identifierColumn = "pk_id", table = "TABLE_NAME", schema = "SCHEMA_NAME")