Required HELP in Hibernate Conversion, SQL Server to Oracle
Joined: Apr 23, 2008
Hi there !,
Am using Struts 1. 2 , Spring ORM - Hibernate.
Am using the hibernate configuration files, model.hbm.xml files
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... ??
Joined: May 23, 2011
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.).