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

Important: This capability is supported only for projects that target WebSphere® Application Server for Version 7.0 feature packs, Version 8.0, and Version 8.5.
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 Tables from Entities....
  2. The data definition language file is created in the META-INF directory of your JPA project. Select the database connection and specify the file name and the schema. Click Finish.

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.
  3. In the editor, right-click and select Execute All.
  4. Check the SQL Results view to verify that the table generation is successful.
Icon that indicates the type of topic Task topic
Timestamp icon Last updated: July 17, 2017 21:58

File name: t_generateDDL.html