Grails, Hibernate, and Sequences with Oracle

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Grails, Hibernate, and Sequences with Oracle

thomj
I have an application that has an Oracle database where each table has a trigger that calls a sequence to get the next ID for that row. How do I configure my domains so that Hibernate doesn't specify the next ID on an insert and just lets Oracle and the trigger handle it?

Previously I had my domains setup to use the sequence generator and this seemed to work. I can't use this on our production systems because the DBA's will not let me grant select privileges to the sequence for Grails. This obviously breaks the generator for Hibernate.

Thanks!
Loading...