Column mapping-related issues

You might encounter a unrecoverable error and warning when you run a Java™ Integration stage job that uses JavaBeans.

Symptoms

  1. You might encounter the following unrecoverable error when you run a Java Integration stage job that uses JavaBeans: 
    Com.ascential.e2.common.CC_Exception: JavaBeans could not be set.
Class name: userClass
The mapping from columns to bean properties was not defined. 
Launch the Column mapping editor to define the column mappings for the bean.
Bean class name: userInputBean   
at com.ibm.is.cc.javastage.connector.CC_JavaLinkImpl.setBeanInfo 
(CC_JavaLinkImpl.java: 146)
at com.ibm.is.cc.javastage.connector.CC_JavaInputLinkImpl.setBeanClass 
(CC_JavaInputLinkImpl.java: 128)
at com.ibm.is.cc.javastage.connector.CC_JavaAdapter.updateLinkWithBeanInfo 
(CC_JavaAdapter.java: 208)
at com.ibm.is.cc.javastage.connector.CC_JavaAdapter.preRunNode 
(CC_JavaAdapter.java: 421)
  2. You might encounter the following warning when you run a Java Integration stage job that uses JavaBeans:
    com.ascential.e2.common.CC_Exception: JavaBeans could not be set. 
Class name: userOutputBean
Type mismatch occurred. Column name: aaa, Column type class: java.sql.Date, 
Bean property name: bbb, Bean property type class: java.lang.String, 
Bean class name: userOutputBean
at com.ibm.is.cc.javastage.connector.CC_JavaLinkImpl.setBeanInfo 
(CC_JavaLinkImpl.java: 146)
at com.ibm.is.cc.javastage.connector.CC_JavaOutputLinkImpl.setBeanClass 
(CC_JavaOutputLinkImpl.java: 278)
at com.ibm.is.cc.javastage.connector.CC_JavaAdapter.updateLinkWithBeanInfo 
(CC_JavaAdapter.java: 218)
at com.ibm.is.cc.javastage.connector.CC_JavaAdapter.preRunNode 
(CC_JavaAdapter.java: 421)

Resolving the problem

This unrecoverable error might occur because you specified userInputBean for an input link by coding getBeanForInput() in your user class userClass, but you did not set column mapping for that link.

The warning might occur because you might have specified userOutputBean for an output link and also configured that link, but, you might have selected a wrong DataStage® column aaa of which column type is java.sql.Date and map it into the JavaBean property bbb of which type is java.lang.String.

To fix the issues, perform the following actions:
  1. Verify the link property Usage - Column mapping.
  2. Click Configure to update the link property.
  3. You can see the current setting on Column Mapping Editor. Modify the mapping by selecting the required setting from the list of each DataStage column.
  4. If you want to see all the JavaBeans properties, click Browse Objects. You can see and select them by clicking check boxes on the Select Bean Properties dialog.
  5. If you want to save new selections, click OK on the Select Bean Properties dialog and click Finish on the Column Mapping Editor.