PK41548: DATA TYPE MISSING OF OCC COLUMN WHEN TOP-DOWN EJB TO RDB MAPPING W/ ORACLE 10

6.1.1.4: WebSphere Application Server Toolkit Version 6.1.1 Fix Pack 4

APAR status

• Closed as program error.

Error description

• The data type of OCC column that is generated for Oracle 10 is m
  issing if a top-down EJB to RDB mapping is used.
  

Local fix

• Manually set OCC column type to NUMBER(19,0)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users creating a top-down Oracle         *
  *                 backend mapping for Container Managed        *
  *                 Persistence Enterprise JavaBeans.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: The OCC column generated for top-down   *
  *                      Oracle backends is missing a data type. *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When creating an Oracle backend for CMP EJBs where an OCC
  column is needed, the generated OCC column in the Database
  metadata is missing a data type
  

Problem conclusion

• The generated Oracle Database backend metadata will now map
  the OCC column to a NUMBER(19,0) data type.  The fix for this
  APAR is currently targeted for inclusion in Rational
  Application Developer v7.0.0.4 and WebSphere
  Application Server Toolkit v6.1.1.4.  Please refer to the
  Recommended Updates page for WebSphere Application Server
  Toolkit fixpack delivery information:
  http://www.ibm.com/support/docview.wss?uid=swg27004980
  

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

  WEBAPP SERVER A

• Fixed component ID

  5724J0820

Applicable component levels

• R610 PSY

     UP