ddl-generation.output-mode

Thank you for your feedback!

- best for offline viewing and printing

- best for most mobile devices

- best for Amazon Kindle devices

Share to:

Use eclipselink.ddl-generation.output-mode to specify where TopLink generates and writes the DDL.

Values

Table 5-30 Opens a new window describes this persistence property's values.

Table 5-30 Valid Values for ddl-generation.output-mode

Value Description

Value	Description
`both`	DDL will be generated and written to both the database and a file. If `eclipselink.ddl-generation` is set to `create-tables`, then `eclipselink.create-ddl-jdbc-file-name` is written to `eclipselink.application-location` and executed on the database. If eclipselink.ddl-generation is set to `drop-and-create-tables`, then both `eclipselink.create-ddl-jdbc-file-name` and `eclipselink.drop-ddl-jdbc-file-name` are written to `eclipselink.application-location`, and both SQL files are executed on the database.
`database`	(Default) DDL will be generated and written to the database only.
`sql-script`	DDL will be generated and written to a file only. If `eclipselink.ddl-generation` is set to `create-tables`, then `eclipselink.create-ddl-jdbc-file-name` is written to `eclipselink.application-location`. It is not executed on the database. If `eclipselink.ddl-generation` is set to `drop-and-create-tables`, then both `eclipselink.create-ddl-jdbc-file-name` and eclipselink.drop-ddl-jdbc-file-name are written to `eclipselink.application-location`. Neither are executed on the database.

both

DDL will be generated and written to both the database and a file.

If eclipselink.ddl-generation is set to create-tables, then eclipselink.create-ddl-jdbc-file-name is written to eclipselink.application-location and executed on the database.
If eclipselink.ddl-generation is set to drop-and-create-tables, then both eclipselink.create-ddl-jdbc-file-name and eclipselink.drop-ddl-jdbc-file-name are written to eclipselink.application-location, and both SQL files are executed on the database.

database

(Default) DDL will be generated and written to the database only.

sql-script

DDL will be generated and written to a file only.

If eclipselink.ddl-generation is set to create-tables, then eclipselink.create-ddl-jdbc-file-name is written to eclipselink.application-location. It is not executed on the database.
If eclipselink.ddl-generation is set to drop-and-create-tables, then both eclipselink.create-ddl-jdbc-file-name and eclipselink.drop-ddl-jdbc-file-name are written to eclipselink.application-location. Neither are executed on the database.

Usage

Examples

See Example 5-17 Opens a new window for information on how to use this persistence property.