PK92976: INCORRECT SCHEMA SEPARATOR USED FOR INFORMIX TABLES

APAR status

• Closed as program error.

Error description

• When an entity's default schema is overridden, OpenJPA will
  fully qualify (schema + table) any SQL generated involving that
  entity.  With Informix, OpenJPA is using the ":" character
  instead of the "." character for the separating character
  between the schema and table names.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server Feature Pack for EJB 3.0             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Cannot utilize JPA entities with        *
  *                      non-default schemas with Informix.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using OpenJPA with the Informix database,
  operations with entities that are backed by tables not in the
  user's default schema fail.  An example Exception is as follows:
  
  org.apache.openjpa.persistence.PersistenceException: Database
  not found or no system permission. {SELECT
  t0.floatValColumnPrecision, t0.floatValColumnScale,
  t0.intValColName, t1.intValCol, t0.notNullable,
  t0.stringValColumnLength, t0.stringValEager,
  t0.stringValOptional, t0.uniqueConstraintString,
  t0.uniqueString FROM jpaschema:ACfgFldEn t0 INNER JOIN
  jpaschema:AltColumnTable t1 ON t0.id = t1.ATTRCONFIGFIELD_ID
  WHERE t0.id = ?} [code=-329, state=IX000]
  

Problem conclusion

• The problem is due to OpenJPA's dictionary for the Informix
  database having the incorrect schema separator character.  The
  dictionary has been corrected to use the correct "." schema
  separator character instead of the incorrect ":" character.
  
  The fix for this APAR is currently targeted for inclusion in
  fix pack 6.1.0.29.  Please refer to the Recommended Updates
  page for delivery information:
  http://www.ibm.com/support/docview.wss?rs=180&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

  WAS EJB3 FEATUR

• Fixed component ID

  5724J0851

Applicable component levels

• R610 PSY

     UP