[JBoss-user] [Persistence & CMP/JBoss] - Re: problem with cascade delete and relationships

2004-12-11 Thread rajkumar10 
hi alex,
  thanks for ur reply i had made a post in jira.jboss.org

Thanks 
Raj...

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3858260#3858260

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3858260


---
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-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

[JBoss-user] [Persistence & CMP/JBoss] - Re: problem with cascade delete and relationships

2004-12-09 Thread rajkumar10 
hi...
Thanks alex...for ur reply.
  
 Alex i had tried all kinds of combinations even i had removed
cascade-delete from the database also but the same error i'm getting 
every time i'm not able to spot thatand Permission dont have any child 
table except SwitchPermission. SwitchPermission dosent have any child.
can u tell me where the things are going wrong  according to Trace 
i can find that when i removes Permission then it starts cascade-delete on
SwithPermission even the ejbRemove method also gets executed ..but 
then i dont know why it throws Remove Exception...i'm not able to 
sort it out...pls help...

Thanks 
Raj...
Logic Eastern


View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3858038#3858038

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3858038


---
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-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

[JBoss-user] [Persistence & CMP/JBoss] - problem with cascade delete and relationships

2004-12-07 Thread rajkumar10 
hi all. 
i'm using jboss 3.2.3... i'm having problem relating to cascase delete.
i have two tables in which pk of one table is fk on other as well as the 
element of composite key... and i'm using mysql as a database in which
cascade delete is set... but when i delete row from parent ejb it 
does not delete from the child ejb... but it is working fine when i checks 
 from the mysql control center... i had seen everything in the deployment
descriptor ...everything seems to be fine but then also it is giving error ..

ejb-jar entries are:-

  | 
  | Permission and SwitchPermission
  | 
  | Each Permission has many 
SwitchPermission
  | One
  | 
  | PermissionEJB
  | 
  | 
  | switchPermission
  | java.util.Collection
  | 
  | 
  | 
  | SwitchPermission to 
Permission
  | Many
  | 
  | 
  | SwitchPermissionEJB
  | 
  | 
  | permission
  | 
  | 
  | 
  | 

and jbosscmp-jdbc entries are:-

  | 
  | Permission and SwitchPermission
  | 
  | 
  | Each Permission has many 
SwitchPermission
  | 
  | 
  | 
  | permissionID
  | PermissionID
  | 
  | 
  | 
  | 
  | SwitchPermission to Permission
  | 
  | 
  | 
  | 
  | 
  | 

and the trace of the error which i'm getting is:-


  |  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 TransactionImpl: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=130
  | 2004-12-07 17:42:21,656 TRACE 
[org.jboss.ejb.plugins.EntitySynchronizationInterceptor] invoke called for ctx 
[EMAIL PROTECTED], tx=TransactionImpl:XidImpl [FormatId=257, 
GlobalId=le52//117, BranchQual=]
  | 2004-12-07 17:42:21,656 TRACE 
[org.jboss.ejb.plugins.EntitySynchronizationInterceptor] register, [EMAIL 
PROTECTED], tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=le52//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.PermissionEJB.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 data: 
entity=PermissionEJB pk=130
  | 2004-12-07 17:42:21,656 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.ReadAheadCache.PermissionEJB] No preload data 
found: entity=PermissionEJB pk=130
  | 2004-12-07 17:42:21,656 TRACE 
[org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding is 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 findByPrimaryKey
  | 2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] 
Thread came in with tx TransactionImpl:XidImpl [FormatId=257, 
GlobalId=le52//117, BranchQual=]
  | 2004-12-07 17:42:21,656 TRACE [org.jboss.ejb.plugins.EntityInstancePool] 
Get instance [EMAIL PROTECTED] com.le.nms.persistence.security.UserBean
  | 2004-12-07 17:42:21,656 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.UserEJB#findByPrimaryKey]
 Executing SQL: SELECT UserID FROM users WHERE UserID=?
  | 2004-12-07 17:42:21,656 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.UserEJB#findByPrimaryKey]
 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:[EMAIL PROTECTED] com.le.nms.persistence.security.UserBean
  | 2004-12-07 17:42:21,687 TRACE [org.jboss.ejb.plugins.TxInterc