Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql to oracle

 
preethi Ayyappan
Ranch Hand
Posts: 518
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am doing a java project with mysql.I need to do the same project with oracle.What are the things i have to do to change the database connectivity.Any help will be appreciated.

Thanks.
 
karthikeyan Chockalingam
Ranch Hand
Posts: 259
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you have not used MySql specific SQL you can migrate easily. Incase you have used MySql specific SQL [ and followed design patterns like Factory /abstract factory] you can use Oracle specific implementation class.
[ May 31, 2008: Message edited by: karthi keyan ]
 
Baseet Ahmed
Ranch Hand
Posts: 225
Java Notepad Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
preethi,

You have to change the jdbc driver from your mysql to oracle.
For Oracle, you require classes12.zip/jar file, if you are not using JDBC ODBC Bridge driver.



Regards
Baseet Ahmed

******************
Do Make Nikah(Marriage/Wedding ceremony) simple(cheap/easy) so that it becomes difficult(expensive/hard) to do Rape.
-ISLAM-
******************
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic