File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes Required HELP in Hibernate Conversion,  SQL Server to Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Required HELP in Hibernate Conversion,  SQL Server to Oracle" Watch "Required HELP in Hibernate Conversion,  SQL Server to Oracle" New topic
Author

Required HELP in Hibernate Conversion, SQL Server to Oracle

Vicky Vijay
Ranch Hand

Joined: Apr 23, 2008
Posts: 125
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

Joined: May 23, 2011
Posts: 43
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.).
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Required HELP in Hibernate Conversion, SQL Server to Oracle
 
Similar Threads
Looking for advice on configuring a new project using Spring and Hibernate.
Hibernate Native SQL versus iBATIS
JDBC with SQL server 2000
JSP cannot connect to Oracle on remote machine
Oracle stored procedures and Hibernate