Schema Generation

This table lists the properties of the Schema Generation page of the persistence.xml Editor.


Note:

This page is not available for projects using the Generic platform.

Property Description Default

DDL Generation Type

Select the type of DDL generation:

  • None -- Do not generate DDL; no schema is generated.

  • Create Tables -- Create DDL for non-existent tables; leave existing tables unchanged.

  • Drop and Create Tables -- Create DDL for all tables; drop all existing tables.

None

Output Mode

Select the DDL generation target:

  • Both -- Generate SQL files and execute them on the database.

  • Database -- Execute SQL on the database only (do not generate SQL files).

  • SQL Script -- Generate SQL files only (do not execute them on the database).

DDL Generation Location

Specify where EclipseLink writes DDL output. Specify a file specification to a directory in which you have write access. The file specification may be relative to your current working directory or absolute. If it does not end in a file separator, then EclipseLink appends one that is valid for your operating system.

Create DDL File Name

Specify the file name of the DDL file that EclipseLink generates that contains SQL statements for creating tables for JPA entities. Specify a file name valid for your operating system.

createDDL.jdbc

Drop DDL File Name

Specify the file name of the DDL file that EclipseLink generates that contains SQL statements for dropping tables for JPA entities.

dropDDL.jdbc

Related references