Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I have been using @Id annotation for generation of primary keys.
I am using my SQL as the database. its working fine with mysql if I write @Id(generate=generatorType.AUTO)
but it is not working with Oracle database.
what should change in the annotation to make it portable for oracle and mysql.
It is studied that generatorType.AUTO is portable for any database vendor but its not true if used with Oracle.
Please put some lights on it.

Thanks.

It does work with oracle too