bug in cascade-delete with relationships in Jboss CMP

After posting in forum and after discussing with Mr Alexey Loubyansky ...i'm posting bug report...forum's url is :- http://www.jboss.org/index.html?module=bb&op=viewtopic&t=57379

This bug came to me while mapping CMP..and the situtation like:-

here are 3 tables which are OperationDetail, Permission and SwitchPermission ... where OperationDetail is parent of Permission which have not-null foreign key in Permission say(OperationDetailID)... and Permission is an Parent of SwitchPermission....There is a cascade-delete set between Permission and SwitchPermission..... and when i tries to delete
Permission then i got from the trace that it tries put "null" on the OperationDetailID which is a not-null FK in Permission table... and then the
error occurs .....this is exactly what happens.. even after that i had set a <not-null/> in the jbosscmp-jdbc.xml...then also its not working ....This is basically what happening ......

here is the whole Trace
-------------------------------------------------------------------------------
Start method=remove
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current transaction in MI is
TransactionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_REQUIRED for remove
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in with tx Transa
ctionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] Begin invoke, key=130
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] entryPromotion
, entry=key: 130, object: 1cfd020, entry: 6906a1
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] Begin invoke, key=13
0
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] invoke called
for ctx org.jboss.ejb.EntityEnterpriseContext@1cfd020, tx=TransactionImpl:XidImpl [FormatId=257, Gl
obalId=le52//117, BranchQual=]
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] register, ctx
=org.jboss.ejb.EntityEnterpriseContext@1cfd020, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=l
e52//117, BranchQual=]
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.PermissionEJB]
Store command NOT executed. Entity is not dirty or scheduled for batch cascade delete: pk=130
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMRFieldBridge.PermissionEJ
B.UserEJB_permission] Read ahead cahce load: cmrField=UserEJB_permission pk=130
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PermissionEJB] load dat
a: entity=PermissionEJB pk=130
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PermissionEJB] No prelo
ad data found: entity=PermissionEJB pk=130
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding i
s null in ProxyFactoryFinder
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start method=findByPrimaryKey
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current transaction in MI is
TransactionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_REQUIRED for findByPrimary
Key
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in with tx Transa
ctionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get instance org.jboss.ejb.
plugins.EntityInstancePool@c5a196#0#class com.le.nms.persistence.security.UserBean
2004-12-07 17:42:21,656 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.UserEJB#find
ByPrimaryKey] Executing SQL: SELECT UserID FROM users WHERE UserID=?
2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.UserEJB#find
ByPrimaryKey] Set parameter: index=1, jdbcType=VARCHAR, value=raj
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.EntityInstancePool] 0/100 Free instance:org.jbo
ss.ejb.plugins.EntityInstancePool@c5a196#null#null#false#class com.le.nms.persistence.security.UserB
ean
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TxInterceptorCMT: In finally
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.LogInterceptor] End method=findByPrimaryKey
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding i
s null in ProxyFactoryFinder
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start method=<no method>
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current transaction in MI is
TransactionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_SUPPORTS for <no method>
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in with tx Transa
ctionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] Begin invoke, key=raj
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get instance org.jboss.ejb.
plugins.EntityInstancePool@c5a196#1#class com.le.nms.persistence.security.UserBean
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.AbstractInstanceCache] Activated bean UserEJB w
ith id = raj
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] entryPromotion
, entry=key: raj, object: 76a247, entry: 980461
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] entryAdded, en
try=key: raj, object: 76a247, entry: 980461
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] Begin invoke, key=ra
j
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.EntityReentranceInterceptor] NON_ENTRANT invoca
tion
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] invoke called
for ctx org.jboss.ejb.EntityEnterpriseContext@76a247, tx=TransactionImpl:XidImpl [FormatId=257, Glo
balId=le52//117, BranchQual=]
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.UserEJB] RESET PERSIS
TENCE CONTEXT: id=raj
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.UserEJB] load data: ent
ity=UserEJB pk=raj
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.UserEJB] No preload dat
a found: entity=UserEJB pk=raj
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.UserEJB] Defau
lt eager-load for entity: readahead=null
2004-12-07 17:42:21,687 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.UserEJB] Executi
ng SQL: SELECT Password, AccountExpiry, PasswordExpiry, GroupID, FirstName, LastName, Address1, Addr
ess2, City, State, Country, PIN, EmailID, ContactNo, Mobile, Remarks, LoginStatus FROM users WHERE (
UserID=?)
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.UserEJB#us
erID] Set parameter: index=1, jdbcType=VARCHAR, value=raj
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] register, ctx
=org.jboss.ejb.EntityEnterpriseContext@76a247, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=le
52//117, BranchQual=]
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCRelationInterceptor.UserEJB] Remov
e relation: field=permission id=raj relatedId=130
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] register, ctx
=org.jboss.ejb.EntityEnterpriseContext@76a247, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=le
52//117, BranchQual=]
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] End invoke, key=raj,
ctx=org.jboss.ejb.EntityEnterpriseContext@76a247
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] End invoke, key=raj
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.LogInterceptor] End method=<no method>
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMRFieldBridge.PermissionEJ
B.operationDetail] Read ahead cahce load: cmrField=operationDetail pk=130
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PermissionEJB] load dat
a: entity=PermissionEJB pk=130
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PermissionEJB] No prelo
ad data found: entity=PermissionEJB pk=130
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding i
s null in ProxyFactoryFinder
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start method=findByPrimaryKey
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current transaction in MI is
TransactionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_REQUIRED for findByPrimary
Key
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in with tx Transa
ctionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get instance org.jboss.ejb.
plugins.EntityInstancePool@a6a4b6#0#class com.le.nms.persistence.security.OperationDetailBean
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.UserEJB] Store
command NOT executed. Entity is not dirty or scheduled for batch cascade delete: pk=raj
2004-12-07 17:42:21,687 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OperationDet
ailEJB#findByPrimaryKey] Executing SQL: SELECT OperationDetailID FROM operationdetail WHERE Operatio
nDetailID=?
2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OperationDet
ailEJB#findByPrimaryKey] Set parameter: index=1, jdbcType=INTEGER, value=1001
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.EntityInstancePool] 0/100 Free instance:org.jbo
ss.ejb.plugins.EntityInstancePool@a6a4b6#null#null#false#class com.le.nms.persistence.security.Opera
tionDetailBean
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TxInterceptorCMT: In finally
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.LogInterceptor] End method=findByPrimaryKey
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding i
s null in ProxyFactoryFinder
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start method=<no method>
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current transaction in MI is
TransactionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_SUPPORTS for <no method>
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in with tx Transa
ctionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] Begin invoke, key=1001
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get instance org.jboss.ejb.
plugins.EntityInstancePool@a6a4b6#1#class com.le.nms.persistence.security.OperationDetailBean
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.AbstractInstanceCache] Activated bean Operation
DetailEJB with id = 1001
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] entryPromotion
, entry=key: 1001, object: af8fc0, entry: 6afa2
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] entryAdded, en
try=key: 1001, object: af8fc0, entry: 6afa2
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] Begin invoke, key=10
01
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.EntityReentranceInterceptor] NON_ENTRANT invoca
tion
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] invoke called
for ctx org.jboss.ejb.EntityEnterpriseContext@af8fc0, tx=TransactionImpl:XidImpl [FormatId=257, Glo
balId=le52//117, BranchQual=]
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OperationDetailEJB] R
ESET PERSISTENCE CONTEXT: id=1001
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.OperationDetailEJB] loa
d data: entity=OperationDetailEJB pk=1001
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.OperationDetailEJB] No
preload data found: entity=OperationDetailEJB pk=1001
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.OperationDetai
lEJB] Default eager-load for entity: readahead=null
2004-12-07 17:42:21,703 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OperationDetailE
JB] Executing SQL: SELECT OperationName FROM operationdetail WHERE (OperationDetailID=?)
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.OperationD
etailEJB#operationDetailID] Set parameter: index=1, jdbcType=INTEGER, value=1001
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] register, ctx
=org.jboss.ejb.EntityEnterpriseContext@af8fc0, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=le
52//117, BranchQual=]
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCRelationInterceptor.OperationDetai
lEJB] Remove relation: field=PermissionEJB_operationDetail id=1001 relatedId=130
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] register, ctx
=org.jboss.ejb.EntityEnterpriseContext@af8fc0, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=le
52//117, BranchQual=]
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] End invoke, key=1001
, ctx=org.jboss.ejb.EntityEnterpriseContext@af8fc0
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] End invoke, key=1001
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.LogInterceptor] End method=<no method>
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMRFieldBridge.PermissionEJ
B.switchPermission] Read ahead cahce load: cmrField=switchPermission pk=130
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PermissionEJB] load dat
a: entity=PermissionEJB pk=130
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PermissionEJB] No prelo
ad data found: entity=PermissionEJB pk=130
2004-12-07 17:42:21,703 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.PermissionEJB]
Executing SQL: SELECT PermissionID, PermissionID, SwitchName FROM switchpermission WHERE (Permissio
nID=?) OR (PermissionID=?)
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SwitchPerm
issionEJB#permissionID] Set parameter: index=1, jdbcType=INTEGER, value=130
2004-12-07 17:42:21,703 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SwitchPerm
issionEJB#permissionID] Set parameter: index=2, jdbcType=INTEGER, value=131
2004-12-07 17:42:21,718 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.SwitchPermissionEJB] Ad
d preload data: entity=SwitchPermissionEJB pk=Lecsar130 field=permission
2004-12-07 17:42:21,718 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.SwitchPermissionEJB] Ad
d preload data: entity=SwitchPermissionEJB pk=Lecsar131 field=permission
2004-12-07 17:42:21,718 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PermissionEJB] Add prel
oad data: entity=PermissionEJB pk=131 field=switchPermission
2004-12-07 17:42:21,718 TRACE [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding i
s null in ProxyFactoryFinder
2004-12-07 17:42:21,718 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start method=<no method>
2004-12-07 17:42:21,718 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current transaction in MI is
TransactionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,718 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_SUPPORTS for <no method>
2004-12-07 17:42:21,718 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in with tx Transa
ctionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,718 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] Begin invoke, key=Lecsar
130
2004-12-07 17:42:21,718 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get instance org.jboss.ejb.
plugins.EntityInstancePool@177d80b#0#class com.le.nms.persistence.security.SwitchPermissionBean
2004-12-07 17:42:21,718 TRACE [org.jboss.ejb.plugins.AbstractInstanceCache] Activated bean SwitchPer
missionEJB with id = Lecsar130
2004-12-07 17:42:21,734 TRACE [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] entryPromotion
, entry=key: Lecsar130, object: 108cd64, entry: e490fa
2004-12-07 17:42:21,734 TRACE [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] entryAdded, en
try=key: Lecsar130, object: 108cd64, entry: e490fa
2004-12-07 17:42:21,734 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] Begin invoke, key=Le
csar130
2004-12-07 17:42:21,734 TRACE [org.jboss.ejb.plugins.EntityReentranceInterceptor] NON_ENTRANT invoca
tion
2004-12-07 17:42:21,734 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] invoke called
for ctx org.jboss.ejb.EntityEnterpriseContext@108cd64, tx=TransactionImpl:XidImpl [FormatId=257, Gl
obalId=le52//117, BranchQual=]
2004-12-07 17:42:21,734 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.SwitchPermissionEJB]
RESET PERSISTENCE CONTEXT: id=Lecsar130
2004-12-07 17:42:21,734 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.SwitchPermissionEJB] lo
ad data: entity=SwitchPermissionEJB pk=Lecsar130
2004-12-07 17:42:21,734 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.SwitchPermissionEJB] Pr
eloading data: entity=SwitchPermissionEJB pk=Lecsar130 cmrField=permission
2004-12-07 17:42:21,734 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.SwitchPermissi
onEJB] Default eager-load for entity: readahead=null
2004-12-07 17:42:21,734 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.SwitchPermission
EJB] Executing SQL: SELECT StopTime, StartTime FROM switchpermission WHERE (PermissionID=? AND Switc
hName=?)
2004-12-07 17:42:21,734 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SwitchPerm
issionEJB#permissionID] Set parameter: index=1, jdbcType=INTEGER, value=130
2004-12-07 17:42:21,734 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SwitchPerm
issionEJB#switchName] Set parameter: index=2, jdbcType=VARCHAR, value=Lecsar
2004-12-07 17:42:21,750 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] register, ctx
=org.jboss.ejb.EntityEnterpriseContext@108cd64, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=l
e52//117, BranchQual=]
2004-12-07 17:42:21,750 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.SwitchPermissi
onEJB] Scheduled for batch-cascade-delete: Lecsar130
2004-12-07 17:42:21,750 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] register, ctx
=org.jboss.ejb.EntityEnterpriseContext@108cd64, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=l
e52//117, BranchQual=]
2004-12-07 17:42:21,750 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] End invoke, key=Lecs
ar130, ctx=org.jboss.ejb.EntityEnterpriseContext@108cd64
2004-12-07 17:42:21,750 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] End invoke, key=Lecsar13
0
2004-12-07 17:42:21,750 TRACE [org.jboss.ejb.plugins.LogInterceptor] End method=<no method>
2004-12-07 17:42:21,750 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMRFieldBridge.PermissionEJ
B.GroupEJB_permission] Read ahead cahce load: cmrField=GroupEJB_permission pk=130
2004-12-07 17:42:21,750 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PermissionEJB] load dat
a: entity=PermissionEJB pk=130
2004-12-07 17:42:21,750 TRACE [org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PermissionEJB] No prelo
ad data found: entity=PermissionEJB pk=130
2004-12-07 17:42:21,750 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.OperationDetail
EJB] Store command NOT executed. Entity is not dirty or scheduled for batch cascade delete: pk=10
01
2004-12-07 17:42:21,750 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.SwitchPermissio
nEJB] Store command NOT executed. Entity is not dirty or scheduled for batch cascade delete: pk=L
ecsar130
2004-12-07 17:42:21,765 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.CascadeDeleteStrategy$BatchCascadeDele
teStrategy.PermissionEJB] Removing SwitchPermissionEJB:Lecsar130
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding i
s null in ProxyFactoryFinder
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start method=remove
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current transaction in MI is
TransactionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_REQUIRED for remove
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in with tx Transa
ctionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] Begin invoke, key=Lecsar
130
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] entryPromotion
, entry=key: Lecsar130, object: 108cd64, entry: e490fa
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] Begin invoke, key=Le
csar130
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] invoke called
for ctx org.jboss.ejb.EntityEnterpriseContext@108cd64, tx=TransactionImpl:XidImpl [FormatId=257, Gl
obalId=le52//117, BranchQual=]
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] register, ctx
=org.jboss.ejb.EntityEnterpriseContext@108cd64, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=l
e52//117, BranchQual=]
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.SwitchPermissio
nEJB] Store command NOT executed. Entity is not dirty or scheduled for batch cascade delete: pk=L
ecsar130
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding i
s null in ProxyFactoryFinder
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start method=findByPrimaryKey
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current transaction in MI is
TransactionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_REQUIRED for findByPrimary
Key
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in with tx Transa
ctionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get instance org.jboss.ejb.
plugins.EntityInstancePool@9d7837#0#class com.le.nms.persistence.security.PermissionBean
2004-12-07 17:42:21,765 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.PermissionEJ
B#findByPrimaryKey] Executing SQL: SELECT PermissionID FROM permission WHERE PermissionID=?
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.PermissionEJ
B#findByPrimaryKey] Set parameter: index=1, jdbcType=INTEGER, value=130
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntityInstancePool] 0/100 Free instance:org.jbo
ss.ejb.plugins.EntityInstancePool@9d7837#null#null#false#class com.le.nms.persistence.security.Permi
ssionBean
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TxInterceptorCMT: In finally
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.LogInterceptor] End method=findByPrimaryKey
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding i
s null in ProxyFactoryFinder
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start method=<no method>
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current transaction in MI is
TransactionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_SUPPORTS for <no method>
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in with tx Transa
ctionImpl:XidImpl [FormatId=257, GlobalId=le52//117, BranchQual=]
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] Begin invoke, key=130
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] entryPromotion
, entry=key: 130, object: 1cfd020, entry: 6906a1
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] Begin invoke, key=13
0
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntityReentranceInterceptor] NON_ENTRANT invoca
tion
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] invoke called
for ctx org.jboss.ejb.EntityEnterpriseContext@1cfd020, tx=TransactionImpl:XidImpl [FormatId=257, Gl
obalId=le52//117, BranchQual=]
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] register, ctx
=org.jboss.ejb.EntityEnterpriseContext@1cfd020, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=l
e52//117, BranchQual=]
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCRelationInterceptor.PermissionEJB]
Remove relation: field=switchPermission id=130 relatedId=Lecsar130
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntitySynchronizationInterceptor] register, ctx
=org.jboss.ejb.EntityEnterpriseContext@1cfd020, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=l
e52//117, BranchQual=]
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] End invoke, key=130,
ctx=org.jboss.ejb.EntityEnterpriseContext@1cfd020
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] End invoke, key=130
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.LogInterceptor] End method=<no method>
2004-12-07 17:42:21,765 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.PermissionEJB]
Executing SQL: UPDATE permission SET UserID=?, OperationDetailID=? WHERE PermissionID=?
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.Permission
EJB#userID] Set parameter: index=1, jdbcType=VARCHAR, value=NULL
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.Permission
EJB#operationDetailID] Set parameter: index=2, jdbcType=INTEGER, value=NULL
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.Permission
EJB#permissionID] Set parameter: index=3, jdbcType=INTEGER, value=130
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntityInstanceInterceptor] End invoke, key=Lecs
ar130, ctx=org.jboss.ejb.EntityEnterpriseContext@108cd64
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.EntityLockInterceptor] End invoke, key=Lecsar13
0
2004-12-07 17:42:21,765 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TxInterceptorCMT: In finally
2004-12-07 17:42:21,765 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalExcep
tion in method: public abstract void javax.ejb.EJBLocalObject.remove() throws javax.ejb.RemoveExcept
ion,javax.ejb.EJBException, causedBy:
java.sql.SQLException: General error, message from server: "Cannot add or update a child row: a foreign key constraint fails"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651

------------------------------------------------------------------------------

i had tried this on jboss3.2.3.

Thanks
Raj
Logic Eastern