PH63414: ITX MAPS UNABLE TO INSERT DATA INTO SYBASE TINYINT COLUMN VIA JDBC WHEN VALUE IS GREATER THAN 127

APAR status

• Closed as program error.

Error description

• When using an IBM Sterling Transformation Extender (ITX) map
  with the JDBC adapter.  Parsing of an unsigned TINYINT value
  (numbers greater than 127) results in a
  java.lang.NumberFormatException, and are not getting written to
  the Database.
  

Local fix

• ITXCQ - ITX00062676
  PB / PB
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender users using jdbc adapter.
  
  Problem Description:
  Unable to insert data into SYBASE TINYINT column via JDBC when
  value is greater than 128.
  
  Platforms Affected:
  All
  

Problem conclusion

• Parsing of unsigned tinyint values (numbers greater than 127)
  was resulting in java.lang.NumberFormatException, and were not
  getting written to the DB. Now, these values will be handled
  during write operation, along with the unsigned values of the
  other data types of smallint, int and bigint.
  
  Applies to:
  10.1.1.1, 10.1.2.1 11.0.0.0, 11.0.1.0
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next fix pack or product release is available,
  check the IBM Transformation Extender product Release Notes
  page:
  https://www.ibm.com/support/pages/node/318755
  
  If a fix pack release is available, download it from Fix
  Central:
  http://www.ibm.com/support/fixcentral/
  
  If a new product release is available, download it from
  PassportAdvantage:
  https://www.ibm.com/software/passportadvantage/pao_customer.html
  
  
  If the fix pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a support Case:
  https://www.ibm.com/mysupport
  

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