Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Required HELP in Hibernate Conversion, SQL Server to Oracle

 
Vicky Vijay
Ranch Hand
Posts: 125
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there !,

Am using Struts 1. 2 , Spring ORM - Hibernate.

Am using the hibernate configuration files, model.hbm.xml files

Question:

What are the necessary parameters I need to take care to make my project database Independent.. !!

i.e., Let say, Current project is using SQL Server DB

If I need to convert the existing project to ORACLE based...


What are the procedures/Pre-requisite i should ensure to make conversion faster/easier conversion... ??


 
Bogdan Baraila
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello.
If you don't have any sql native request in the application (that means that you are using just HQL, Criteria queries) then to move from a database to another you just need to change the driver database and then in the hibernate config file to replace the: url, hibernate.dialec and the jdb driver className.

Of course you need to have a similar arhitecture in both databases (same tables, same sequences (the hibernate_sequence is usually used), same stored procedures etc.).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic