IBM Support

DDL generation for Java Batch feature might produce an empty file

Troubleshooting


Problem

A Liberty server configured with the Java Batch feature might be used to generate DDL statements using the scripts, ddlGen.sh or ddlGen.bat. You might notice that the script reports successful completion, but the generated file is empty (0 bytes).

Symptom

You attempt to run the script, ddlGen.sh or ddlGen.bat, for a server configured with the Java Batch feature. The script indicates successful completion, but the output file produced is empty.

Diagnosing The Problem

Observe that when you run the ddlGen script, an empty output file is produced when the target server is configured with the Java Batch feature.

Resolving The Problem

To prevent the error, modify the server configuration to add the attribute, createTables="false", to the databaseStore element that is used for the Java Batch feature. The databaseStore element is referenced from the batchPersistence configuration element or a default databaseStore, if you do not explicitly define it.

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF014","label":"iOS"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"},{"code":"PF013","label":"Inspur K-UX"},{"code":"PF022","label":"OS X"}],"Version":"16.0.0.4","Edition":"Liberty","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 November 2019

UID

swg21994400