IBM Support

Database changes for Java Batch in 18.0.0.1

Question & Answer


Question

What changes have been made to the database table structure for the Java Batch job repository in 18.0.0.1

Answer

The Java Batch job repository has a new element introduced with the 18.0.0.1 fixpack. There is a new table named GROUPASSOCIATION.
Updating the job repository database to include this new element will enable Group Level Security enforcement in Java Batch. Attempting to utilize the new batch group security support without upgrading the database will result in javax.transaction.RollbackException messages in the runtime trace log with a root cause of:

org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Table/View '[SCHEMA].GROUPASSOCIATION' does not exist.

There are two ways to update the database to include this new element:

1. In the server configuration, for the databaseStore element associated with the batchPersistence configuration object, ensure that the createTables attribute has a value of "true". This will automatically bring the database up-to-date on the next server start.
2. If the createTables attribute is set to "false" instead, the user must manually update their database. The DDL statements for the new table structure can be generated using the ddlGen script located in the [wlp_home]/bin directory.

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Component":"Liberty","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"18.0.0.1","Edition":"Liberty"}]

Document Information

Modified date:
15 June 2018

UID

swg22014371