PI83805: DB2 TABLES ARE NOT RESOLVED IF UNQUALIFIED VIA JAVA RUNTIME WHERE THE DEFAULT SCHEMA IS DEFINED IN THE DB2 CONNECTION PROPERTIES

Rational Business Developer Fix Pack 2 (9.1.1.2) for 9.1.1
Rational Business Developer Fix Pack 2 (9.5.1.1) for 9.5

APAR status

• Closed as program error.

Error description

• It observed that access to DB2 tables are not resolved correctly
  if they are not fully qualified when run via Java applications
  when the default schema is defined in the driver, DB2 connection
  properties unlike when running in COBOL generated programs.
  
  When running the Java application where the applicable default
  schema is set within the Build Descriptor ie sqlSchema=DEVU
  along with useCurrentschema= YES errors are thrown indicating
  this table is not resolved correctly ie:
  getUser EGL0504E GET: "DEVU.DEVUTSE001_USER" is an undefined
  name.. SQLCODE=-204, SQLSTATE=42704,
  DRIVER=4.19.56[sqlstate:42704][sqlcode:-204]
  EGL0002I The error occurred in SJPBAT0B processing the getUser
  function. -204
  
  Its expected that it should be required to indicate the schema
  in the Build Descriptor or in the source code to ensure the code
  is independent of the running environment when deploying (Schema
  could be only within the properties file) which is the same
  behavior as in COBOL.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * RBD users who connect to DB2                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * It observed that access to DB2 tables are not resolved       *
  * correctly if they are not fully qualified when run via Java  *
  * applications when the default schema is defined in the       *
  * driver, DB2 connection properties unlike when running in     *
  * COBOL generated programs.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The problem is fixed.
  

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

  RATL BUS DEV

• Fixed component ID

  5724S5000

Applicable component levels

• R911 PSY

     UP

• R950 PSY

     UP