Migrate Java Code talking to MySql database to Oracle 11g
751317Mar 1 2010 — edited Mar 1 2010Hi,
I have java application which stores and retrieves data from mysql database (very simple scheme 10 tables or so) I am using spring jdbc framework for connection to DB.
Now my task is to migrate this application to utilize Oracle Database and I am already installing an instance on my dev box of oracle 11 g.
I was wondering if someone can suggest what differences in doing the conversion I should expect to come across. What would be the adapter that my java code should use and does my DAO layer change at all in terms or sql code. I do not use any stored procedures only sql embedded in my code.
Any advice will be appreciated.
Thank you.