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

Dimitris Andreadis (JIRA) jira-events at jboss.com
Wed Jan 10 03:16:27 EST 2007 

     [ http://jira.jboss.com/jira/browse/JBAS-51?page=all ]

Dimitris Andreadis closed JBAS-51.
----------------------------------


> 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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

-- 
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

More information about the jboss-jira mailing list