PH60229: AN EMPTY ROW OF DATA WITH ONLY THE TERMINATOR CAUSES THE JDBC "INSERT" OPERATIONS TO FAIL BECAUSE OF NULL COLUMN RESTRICTIONS

APAR status

• Closed as program error.

Error description

• An empty row of data with only the terminator causes the JDBC
  "insert" operations to fail because of NULL column restrictions.
  

Local fix

• ITXCQ - ITX00062369
  TR / TR
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender users using JDBC adapter users,
  particularly those looking for the same behavior as the ODBC
  adapter.
  
  Problem Description:
  An empty row of data with only the terminator was causing JDBC
  "insert" operations to fail because of NULL column restrictions.
  
  
  
  Platforms Affected:
  All
  

Problem conclusion

• The JDBC adapter ignores empty data streams that only have a
  record terminator.
  
  Applies to:
  10.1.1.1, 10.1.2.1, 11.0.0.0
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next service pack or product release is available,
  
  check the IBM Transformation Extender Release Notes page:
  https://www.ibm.com/support/docview.wss?uid=swg27008337
  
  If the service pack or product release is available, download it
  
  from Fix Central:
  http://www.ibm.com/support/fixcentral/
  
  If the service pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  
  Interim Fix (LAIF) by opening a case:
  https://www.ibm.com/mysupport/
  
  Prior to version 9.0.0, IBM Transformation Extender was called
  IBM WebSphere Transformation Extender.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  ITX

• Fixed component ID

  5724Q2300

Applicable component levels