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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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.).
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Required HELP in Hibernate Conversion, SQL Server to Oracle
 
Similar Threads
JDBC with SQL server 2000
Looking for advice on configuring a new project using Spring and Hibernate.
JSP cannot connect to Oracle on remote machine
Hibernate Native SQL versus iBATIS
Oracle stored procedures and Hibernate