Friday, May 23, 2008

From Mysql to Oracle: Grails application migration

From Mysql to Oracle: Grails application migration Today I have finished migration of our Grails prototype. Originally we did develop it for MySQL, but the final system have to work with Oracle. This post summarize troubles and differences I was facing. User creation Since I am not Oracle administrator, it took me some time to put together script that creates user and appropriate rights for the Grails application. Use the script for development only. CREATE user grails IDENTIFIED BY grass