From the research , it seems like the oracle sequence is disappearing when we have DDL set in update mode. It seems like a bug in hibernate/grails when connecting to oracle. It works fine in mysql etc.
The suggestion was to add to add to domain class
static mapping = {
id generator:'sequence', params:[sequence:'ANY_WORD']
}
ahonor
commented
12 years ago
From sharadr:
From the research , it seems like the oracle sequence is disappearing when we have DDL set in update mode. It seems like a bug in hibernate/grails when connecting to oracle. It works fine in mysql etc.
The suggestion was to add to add to domain class
static mapping = { id generator:'sequence', params:[sequence:'ANY_WORD'] }
http://www.solveitproblems.net/2012/02/grails-oracle-sequence-problem-ora.html
This would need to be tested for any issues against other databases etc so we don't create regression.