Cannot generate Oracle DDL for Entity using Identity Key Generator

When trying to generate DDL for my entity model the following error prompt and complain identity key generator is not supported.

This problem is caused by the database connection in your project was specified to use the old Oracle dialect. To solve this problem:

1. Go to Tools > DB > Database Configuration…
   

   Open database configuration dialog

2. Press the green down arrow button next to Driver field.
   

   Open database configuration dialog

3. Select org.hibernate.dailect.Oracle12cDialect.
   

   Select Oracle 12c Dialect

4. Press OK to confirm the change.

Now you will able to generate DDL for your entity with primary key specified to use identity as key generator.

 

Related Know-how

Using Reference Path for JDBC Driver in Database Connection Why I cannot generate ERD from class model? How to customize the name of entity index How to specify SQL Server FileGroup in Entity

Related Link

Oracle Database Design Tool (Tutorial) Oracle Database Design with Entity Relationship Diagram (Tutorial) Database Configuration (User’s Guide)