Generating a data definition language file from a JPA project

You can generate a data definition language (DDL) file for your JPA project

About this task

To generate a DDL file for a JPA project:

Procedure

  1. In the Package Explorer view, right-click the JPA project and select JPA Tools > Generate DDL....
  2. The JPA tools create a file name Table.ddl in the META-INF directory of your JPA project.

What to do next

You can use the Table.ddl file to generate tables for your entity beans in a database. To generate the tables:
  1. Right-click the Table.ddl file and click Open With > SQL File Editor.
  2. In the SQL File Editor, enter the connection profile information (type, name and database) at the top of the editor window.
  3. In the editor, right-click and select Execute All.
  4. Check the SQL Results view to see if the table generation was successful.

Feedback