APAR status
Closed as program error.
Error description
Calling remove method on an EJB that has a relationship with
an object of its same type, getting database error when trying
to remove.
.
For DB2, the following exception occurs:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000]
SQL0407N
Assignment of a NULL value to a NOT NULL column "TBSPACEID=2,
TABLEID=224, COLNO=5" is not allowed. SQLSTATE=23502
Local fix
The fix will contain changes to LinkManaerImpl.java to find all
associations before the remove() is called. so that during the
remove(), there is no need to call any more finders for foreign
key associations.
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users of EBJs *
* calling the remove method on an EJB that *
* has a relationship with an object of its *
* same type. *
****************************************************************
* PROBLEM DESCRIPTION: During ejbRemove() if a finder is *
* triggered, ejbStore() will be called *
* on the bean. As fkey may already be *
* NULL, database will complain about the *
* foreign key that can not be null. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
During ejbRemove(), during the remove management of all the
related CMRs and their cmrs, if a finder is triggered,
ejbStore() will be called on the bean. As fkey may already be
NULL, database will complain about the foreign key that can not
be null.
Calling remove method on an EJB that has a relationship with
an object of its same type, we generate a database error.
For DB2, the following exception occurs:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000]
SQL0407N
Assignment of a NULL value to a NOT NULL column "TBSPACEID=2,
TABLEID=224, COLNO=5" is not allowed. SQLSTATE=23502
Problem conclusion
A flag will be added in
ConcreteBeanStatefulInstanceExtensionImpl.inRemove(). The flag
is set during ejbRemove() call and reset after the call.
Temporary fix
a test fix is now available
Comments
APAR information |
APAR number |
PQ79369 |
Reported component name |
WAS BASE 5.0 |
Reported component ID |
5630A3600 |
Reported release |
00W |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2003-10-08 |
Closed date |
2004-03-23 |
Last modified date |
2004-03-23 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Publications Referenced
Applicable component levels |
R003 PSY |
UP |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
|