managing auto increment primary key id without using triggers
909650Jan 10 2012 — edited Jan 11 2012Hi, we have many table in our database with autoincrement primary key ids setup the way they are in MySQL since we are in the process of migrating to Oracle from MySQL. Now in oracle I recently learnt that implementing this requires creating a sequence and a trigger on the id field for each such table. We have like 30 -40 tables in our schema and we want to avoid using database triggers in our product, since management of database is out of scope for our software appliance.
What are my options in implementing the auto increment id feature in oracle... apart from manually specifying the id in the code and managing it in the code which would change a lot of existing insert statements. Some info about our application environement: grails-groovy, hibernate, oracle,mysql support