PH63019: JAVA.SQL.SQLEXCEPTION: JZ00B: NUMERIC OVERFLOW, USING ITX JDBC ADAPTER TO READ TINYINT COLUMN WITH NUMBERS GREATER THAN 128

APAR status

• Closed as program error.

Error description

• When using the IBM Sterling Transformation Extender (ITX) JDBC
  adapter to read a data field from a Sybase database that is
  defined as the TINYINT datatype an exception may occur when
  trying to read values greater than 128.
  
  Example adapter trace for this exception:
  
  <2124-1700-08/05/24 16:06:56>:    Starting transaction.
  <2124-1700-08/05/24 16:06:56>:    Caught exception:
  java.sql.SQLException
  JZ00B: Numeric overflow.
  java.sql.SQLException: JZ00B: Numeric overflow.
    at com.sybase.jdbc42.jdbc.ErrorMessage.raiseError(ErrorMessag
  e.java:839)
    at
  com.sybase.jdbc42.jdbc.Convert.checkByteOflo(Convert.java:1813)
    at com.sybase.jdbc42.tds.TdsInt.getByte(TdsInt.java:84)
    at com.sybase.jdbc42.jdbc.SybResultSet.getByte(SybResultSet.j
  ava:400)
    at com.hcl.hip.adapters.m4jdbc.M4JdbcClient.readNextRow(M4Jdb
  cClient.java:3246)
    at com.hcl.hip.adapters.m4jdbc.M4JdbcClient.readRows(M4JdbcCl
  ient.java:2490)
    at com.hcl.hip.adapters.m4jdbc.MAdapterImpl.get(MAdapterImpl.
  java:184)
    at com.hcl.hip.tools.adapterdriver.MAdapterImpl.get(MAdapterI
  mpl.java:115)
  
  <2124-1700-08/05/24 16:06:56>:    Get operation failed: JZ00B:
  Numeric overflow.
  <2124-1700-08/05/24 16:06:56>:    Caught exception:
  com.hcl.hip.adapters.m4base.MBaseException
  JZ00B: Numeric overflow.
  com.hcl.hip.adapters.m4base.MBaseException: JZ00B: Numeric
  overflow.
    at com.hcl.hip.adapters.m4jdbc.MAdapterImpl.get(MAdapterImpl.
  java:191)
    at com.hcl.hip.tools.adapterdriver.MAdapterImpl.get(MAdapterI
  mpl.java:115)
  
  <2124-1700-08/05/24 16:06:57>:    Committing transaction.
  

Local fix

• ITXCQ - ITX00062618
  PB / GK
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender users using jdbc adapter.
  
  Problem Description:
  Numeric overflow exception (java.sql.SQLException) when using
  ITX JDBC adapter to read TINYINT column with numbers greater
  than 127.
  
  Platforms Affected:
  All
  

Problem conclusion

• Unsigned tinyint values (numbers greater than 127) were not
  being read and leading to an exception. Now, these values will
  be handled during read 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