I am using the dtdgen command to create a new form description xml and
xsd schema for a new table, to be used in the web editor. The resulting
xml and xsd for the forms contains attributes:
"addProcessList", "editProcessList", deleteProcessList",
but the webediter/loader wants an attribute <add><processRef> etc.
It seems like the dtdgen is not using the same schema format as the
webeditor/loader. If I modify the forms description xml output by the
dtdgen to look like the forms51_be.xml (to have the <add><processRef>
format) then the new data will load from the web editor. I would like
to understand the problem, rather than edit the output as a workaround.
Form description xml output from dtdgen:
<form name="TEMPITEM"
usage="editCreate"
addProcessList="massLoader"
editProcessList="massLoader"
deleteProcessList="massLoader"
transformFileURI=""
IDResolveKeysPackage=""
description="" >
<field name="CATENTRY_ID" fieldDescription="CATENTRY_ID" ... etc
Modified to this (as is in the form description file installed with the
product) will work:
<form name="TEMPITEM" usage="editCreate" description="" >
<processList>
<add>
<processRef name="transformer"/>
<processRef name="resolver"/>
<processRef name="loader"/>
</add>
<edit>
<processRef name="transformer"/>
<processRef name="loader"/>
</edit>
<delete>
<processRef name="transformerForDelete"/>
<processRef name="loaderForDelete"/>
</delete>
</processList>
<field name="CATENTRY_ID" fieldDescription="CATENTRY_ID" ... etc
The error is in the log from the loader:
2002.06.13 10:02:04.625 java.lang.Class Oracle.initializeDriverManager
MassLoader
Db2/com/ibm/wca/dbconnect/DbConnectionImplIDProperty.properties,
MassLoader, MassLoader1.2.3 [Version: 1.10 -- 02/02/20 13:18:12]
2002.06.13 10:02:04.687 java.lang.Class main MassLoader
Exception Message: [IBM][CLI Driver] SQL1013N The database alias name
or database name "NULL" could not be found. SQLSTATE=42705
The loader log when it does work:
2002.06.03 09:12:36.265 java.lang.Class Oracle.initializeDriverManager
MassLoader
Db2/com/ibm/wca/dbconnect/DbConnectionImplIDProperty.properties,
MassLoader, MassLoader1.2.3 [Version: 1.10 -- 02/02/20 13:18:12]
2002.06.03 09:12:36.296 java.lang.Class
DB2.DbConnectionImpl::setOperationMode MassLoader
Connection initialized for operating mode: sqlimport.
2002.06.03 09:12:36.296 java.lang.Class
DB2.DbConnectionImpl::setOperationMode MassLoader
Connection initialized for operating mode: 1.