PH55211: JDBC SELECT FAILS WHEN RESULTS CONTAIN NULL VALUES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• JDBC SELECT fails when results contain NULL values
  Fetch failed with SQL code -1, sqlstate 00000, no error text
  available error on running JDBC calls on resultset with NULL
  value
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH55211                                 *
  *                      JDBC SELECT fails when results contain  *
  *                      NULL values and abends on server        *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  PH55211
  JDBC SELECT fails when results contain NULL values and
  abends on server
  

Problem conclusion

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:

Modules/Macros

• AVZCACM4 AVZCRDBD AVZCSECR AVZCSQOP AVZCTROF AVZCTRON AVZCTVRD
  AVZO319D AVZO319N AVZO31AD AVZO31AN AVZO31BD AVZO31BN AVZO31CD
  AVZO31CN AVZO31DD AVZO31DN AVZO649D AVZO649N AVZO64AD AVZO64AN
  AVZO64BD AVZO64BN AVZO64CD AVZO64CN AVZO64DD AVZO64DN AVZOBRSQ
  AVZOCXIN AVZODF9D AVZODF9N AVZODFAD AVZODFAN AVZODFBD AVZODFBN
  AVZODFCD AVZODFCN AVZODFDD AVZODFDN AVZOINAS AVZOPPA  AVZOSXMX
  AVZPB    AVZSIN00 AVZSQ29D AVZSQ29N AVZSQ2BN AVZSQ2CN AVZSQ2DN
  AVZSQL9D AVZSQL9N AVZSQLBN AVZSQLCN AVZSQLDN AVZSQLPR
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels

• R110 PSY UI93681

     UP23/09/23 P F309

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.