IBM Support

PK75616; 7.0.0.1: not insertable, not nullable, and not updatable column issue

Download


Abstract

An exception is thrown when an entity is persisted if it contains a field marked as non-nullable and non-insertable.

Download Description

PK75616 resolves the following problem:

ERROR DESCRIPTION:
A "read-only" column (indicated by insertable=false, updatable=false, nullable=false) is checked for a null value even though it will never be inserted or updated by the JPA provider. The column obtains its value from the database and should not be considered by the JPA provider.

LOCAL FIX:

PROBLEM SUMMARY:

USERS AFFECTED:
All users of Java Persistence API (JPA) with WebSphere Application Server V7.0 entities. A field in the entity must be annotated as nullable=false and either insertable=false and updatable=false

PROBLEM DESCRIPTION:
An exception is thrown when an entity is persisted if it contains a field marked as non-nullable and non-insertable.

RECOMMENDATION:
None

The JPA provider checks for nullable before checking for insertable or updatable.

PROBLEM CONCLUSION:
When a new entity is inserted the check for whether a value may be null is no longer done if the field is not insertable.

When an entity is updated, the check for whether a value may be set to null is no longer done if the field is not updatable.

In short if the field will not be modified the JPA provider does not enforce whether it may be set to null.

The fix for this APAR is currently targeted for inclusion in fixpack 7.0.0.3. Please refer to the Recommended Updates page for delivery information:


http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

Prerequisites

Please download the UpdateInstaller below to install this fix.

[{"PRLabel":"UpdateInstaller","PRLang":"US English","PRSize":"7250000","PRPlat":{"label":"AIX","code":"PF002"},"PRURL":"http://www.ibm.com/support/docview.wss?rs=180&uid=swg21205991"}]

Installation Instructions

Please review the readme.txt for detailed installation instructions.

[{"INLabel":"Readme","INLang":"US English","INSize":"7623","INURL":"ftp://public.dhe.ibm.com/software/websphere/appserv/support/fixes/PK75616/readme.txt"}]
Off
[{"DNLabel":"7.0.0.1-WS-WAS-IFPK75616","DNDate":"12/17/2008","DNLang":"US English","DNSize":"36124","DNPlat":{"label":"AIX","code":"PF002"},"DNURL":"ftp://public.dhe.ibm.com/software/websphere/appserv/support/fixes/PK75616/7.0.0.1-WS-WAS-IFPK75616.pak","DNURL_FTP":" ","DDURL":"http://public.dhe.ibm.com:7618;sw_websphere;appserv/support/fixes/PK75616/7.0.0.1-WS-WAS-IFPK75616.pak"},{"DNLabel":"7.0.0.0-WS-WAS-IFPK75616","DNDate":"12/17/2008","DNLang":"US English","DNSize":"36121","DNPlat":{"label":"AIX","code":"PF002"},"DNURL":"ftp://public.dhe.ibm.com/software/websphere/appserv/support/fixes/PK75616/7.0.0.0-WS-WAS-IFPK75616.pak","DNURL_FTP":" ","DDURL":"http://public.dhe.ibm.com:7618;sw_websphere;appserv/support/fixes/PK75616/7.0.0.0-WS-WAS-IFPK75616.pak"}]

Technical Support

Contact IBM Support using SR (http://www-306.ibm.com/software/support/probsub.html), visit the WebSphere Application Server Support Web site (http://www.ibm.com/software/webservers/appserv/was/support/), or contact 1-800-IBM-SERV(U.S. only).

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"EJB Container","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.0;7.0.0.1","Edition":"Network Deployment","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
15 June 2018

UID

swg24021553