[jboss-jira] [JBoss JIRA] Closed: (JBAS-51) bug in cascade-delete with relationships in Jboss CMP

bug in cascade-delete with relationships in Jboss CMP ----------------------------------------------------- Key: JBAS-51 URL: http://jira.jboss.com/jira/browse/JBAS-51 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: CMP service Affects Versions: JBossAS-3.2.6 Final Environment: windows 2000 professinal, java 1.4.2, pentium 4 Reporter: raj kumar Assigned To: Alexey Loubyansky Fix For: JBossAS-5.0.0.Beta1, JBossAS-3.2.8RC1, JBossAS-4.0.3RC2 Original Estimate: 4 days Remaining Estimate: 4 days 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