LI74394: THE UNIVERSAL JDBC DRIVER (JCC) DOES NOT RETURN METADATA WHEN RUNNING A JAVA ROUTINE WHICH RETURNS EMPTY RESULTSET

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• The Universal JDBC Driver (JCC) does not return metadata along
  with the result code, when the JCC driver is used to run a
  Java stored procedure, which results in empty resultset.
  The same Java stored procedure executed using legacy JDBC driver
  returns the metadata correctly.
  
  Incorrect JCC driver output:
  ============================
  
  db2 call EMPTYRS
  
    Return Status = 0
  
  Expected legacy JDBC driver output:
  ==================================
  
  db2 call EMPTYRS
  Result set 1
    --------------
  
    COL1
    ---------
  
    0 record(s) selected.
  
    Return Status = 0
  

Local fix

• Use legacy JDBC driver for running the Java stored procedures:
  
  db2set DB2_USE_DB2JCCT2_JROUTINE=OFF
  <restart instance>
  

Problem summary

• USERS AFFECTED:
  Users running Java routines.
  
  PROBLEM DESCRIPTION:
  The Universal JDBC Driver (JCC) does not return metadata
  along with the result code, when the JCC driver is used to run a
  Java stored procedure.
  
  PROBLEM SUMMARY:
  The Universal JDBC Driver (JCC) does not return metadata when
  running a stored procedure, which results in empty resultset.
  
  Incorrect JCC driver output:
  ============================
  
  db2 call EMPTYRS
  
    Return Status = 0
  
  Expected output:
  ================
  
  db2 call EMPTYRS
  Result set 1
    --------------
  
    COL1
    ---------
  
    0 record(s) selected.
  
    Return Status = 0
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, FixPak 5 (s091123).
  

Temporary fix

• Use legacy JDBC driver for running the Java stored procedures:
  db2set DB2_USE_DB2JCCT2_JROUTINE=OFF
  <restart instance>
  

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

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R810 PSN

     UP

• R820 PSN

     UP

• R910 PSN

     UP

• R950 PSN

     UP