Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrate Java Code talking to MySql database to Oracle 11g

751317Mar 1 2010 — edited Mar 1 2010
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2010
Added on Mar 1 2010
7 comments
1,198 views