Hi All,
How can write single mapping for multiple database? Ie My hbm file should work in MySql as well as Oracle.I have used "native" generator class also.But no luck.
Is it possible ? Or Should I use different file for each database?
Can any one please help me?

Thanks in advance.

Regards,
Prabakar.

No, you don't need to use different mappings for different DB dialects. Using the native id generator works fine in both MySQL and ORACLE.

You might need to supply some parameters to the native ID generator, that's all. Specifically, when you are using ORACLE you can supply a sequence name. This is ignored when you are using a DB dialect that doesn't support sequences (e.g. SQLServer or MySQL).

Anyway, if you can't get this to work for you it is most likely a problem in your mapping (which you didn't post so I can't help you with that... please read the posting guidelines :) ).

Thanks .It woks fine.The problem is with the mapping file.

Regards,
Prabakar.