WASdev/sample.batch.templateddls

Name: sample.batch.templateddls

Owner: WASdev

Description: Sample DDL files to create batch runtime tables.

Created: 2014-08-27 14:18:47.0

Updated: 2014-09-19 15:05:57.0

Pushed: 2015-05-22 21:24:41.0

Homepage:

Size: 253

Language: null

GitHub Committers

UserMost Recent Commit# Commits

Other Committers

UserEmailMost Recent Commit# Commits

README

Update -

Old tables (from previous beta versions) will no longer work.

Batch DDL templates no longer required

Since the DB tables will now be auto-created on first access, the DDL templates are no longer required.

It is still possible to generate a DDL based on the server configuration, so that it can be customized and used to create the database tables manually.

We will probably post a DB2 z/OS sample template shortly.

Instructions for manually creating tables

As an alternative to relying on the default auto-creation of batch persistence database tables, you can also follow these instructions to manually create the tables.

  1. Edit your server configuration (server.xml) so that your batch persistence references the database you wish to use to store the batch persistence tables within.

    • This chain of references consists of a batchPersistence element using a jobStoreRef attribute to reference a databaseStore. The databaseStore element provides some configuration options such as schema and tablePrefix and also refers to a DataSource with connection info to a specific database of a specific database product type.

  2. Run the ddlGen script:

    lGen <server name>

  3. Customize the generated DDL (i.e. hand off the DDL to your DBA for customization for your DB installation).

  4. OPTIONAL: If you wish you can eliminate the possibility that your manually-created tables might not be used while the batch feature fails over to its auto-created tables unexpectedly. To turn off table auto-creation (and remove this possibility), on the databaseStore element you can set the createTables attribute to “false”, e.g.:

    abaseStore ... createTables="false">
References
Getting Started links
WLP Beta Knowledge Center links
This work is supported by the National Institutes of Health's National Center for Advancing Translational Sciences, Grant Number U24TR002306. This work is solely the responsibility of the creators and does not necessarily represent the official views of the National Institutes of Health.