[ http://jira.jboss.com/jira/browse/JBAS-51?page=history ]
Scott M Stark reassigned JBAS-51:
---------------------------------
Assign To: Alex Loubyansky (was: Scott M Stark)
> 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
> Type: Bug
> Components: CMP service
> Versions: JBossAS-4.0.0 Final
> Environment: windows 2000 professinal, java 1.4.2, pentium 4
> Reporter: raj kumar
> Assignee: Alex Loubyansky
> Priority: Critical
>
> Original Estimate: 4 days
> Remaining: 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 [EMAIL PROTECTED], 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
> [EMAIL PROTECTED], 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.
> [EMAIL PROTECTED] 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
> [EMAIL PROTECTED] 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.
> [EMAIL PROTECTED] 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 [EMAIL PROTECTED], 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
> [EMAIL PROTECTED], 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
> [EMAIL PROTECTED], 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,
> [EMAIL PROTECTED]
> 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.
> [EMAIL PROTECTED] 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
> [EMAIL PROTECTED] 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.
> [EMAIL PROTECTED] 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 [EMAIL PROTECTED], 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
> [EMAIL PROTECTED], 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
> [EMAIL PROTECTED], 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
> , [EMAIL PROTECTED]
> 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.
> [EMAIL PROTECTED] 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 [EMAIL PROTECTED], 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
> [EMAIL PROTECTED], 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
> [EMAIL PROTECTED], 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, [EMAIL PROTECTED]
> 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 [EMAIL PROTECTED], 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
> [EMAIL PROTECTED], 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.
> [EMAIL PROTECTED] 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
> [EMAIL PROTECTED] 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 [EMAIL PROTECTED], 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
> [EMAIL PROTECTED], 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
> [EMAIL PROTECTED], 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,
> [EMAIL PROTECTED]
> 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, [EMAIL PROTECTED]
> 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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
