Hi,

I have a J2EE application that uses hibernate with mysql database,now I want to run it with Oracle database with minimum changed to my code.

I understand I have to change my cgf files for changing the dialect,but is there any way to restrict changes to hbm files and java file (mapping class,if required to change).

for eg:- in mysql hbm I am using org.hibernate.id.IdentityGenerator for identity where as for Oracle I have to use sequence.

for this change I have to modify all hbm files,is there any way to do this by not modifying hbm files ?

I found one solution on web that says extend SequenceGenerator and override configure but I am not sure if
1) I can use it with same hbm file (Id generator)
2) Is it good idea to modify hibernate code?

Cheers
-Praful

In the case of the generator I also use the native generator. This delegates to the native method of the database, eg sequence on Oracle and Identity on MySQL.

Thanks a Buch David,will try that

-Praful