http://www.bea.com/ns/weblogic/920/domain
element create-table-ddl-file

Model

<create-table-ddl-file>string</create-table-ddl-file>

Disallowed substitutions (block)

none (extensions, restrictions and substitutions are allowed)

Substitution group exclusion (final)

none (extensions and restrictions are allowed)

Usage

Documentation

Specifies the DDL (Data Definition Language) file to use for creating the JDBC store's backing table.

• This field is ignored when the JDBC store's backing table, WLStore, already exists.

• If a DDL file is not specified and the JDBC store detects that a backing table doesn't already exist, the JDBC store automatically creates the table by executing a preconfigured DDL file that is specific to the database vendor. These preconfigured files are located in the weblogic.jar file in the weblogic/store/io/jdbc/ddl directory.

• If a DDL file is specified and the JDBC store detects that a backing table doesn't already exist, then the JDBC store searches for the DDL file in the file path first, and then if the file is not found, it searches for it in the CLASSPATH. Once found, the SQL within the DDL file is executed to create the JDBC store's database table. If the DDL file is not found and the backing table doesn't already exist, the JDBC store will fail to boot.

Privileges: Read/Write

Redeploy or Restart required: Changes take effect after you redeploy the module or restart the server.

MBean Attribute: JMSJDBCStoreMBean.CreateTableDDLFile

Fundamental Facets

equality, non-numeric, unbounded, unordered, countable infinite value space

White Space Processing

collapse