| 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.).
|
|
 |
|
|
subject: Required HELP in Hibernate Conversion, SQL Server to Oracle
|
|
|
0
