OK, some progress here. It seems that I'm experiencing some kind of bean lock. Here is the description of the cycle:
I start a transaction calling a session bean which retireves a collection of taskbeans for a user. It uses a finder on taskhome looking for tasks where user.id = the userid passed. Each TaskBean has a many to one relationship with userbean (userbean is blind to it). The first TaskBean is returned with all of it's relationship information (it has the userbean and everything...)When the iteration does the getUser on the second TaskLocal, I see the slect on all fields of the TaskBean according to the ID, I see theresultset being returned. Now I eas supposed to see the select for the user, but I don't... see the following selects generated by JBoss: Starting from the first select.... stopping on the second:1087044981481|150|1|statement|SELECT PRIORITY, TASK_NAME, RE_ASSIGNABLE, RE_ASSIGNABLE_TO_VL_ID, CREATE_DATE, UPDATE_DATE, END_DATE, TIME_STAMP, STATUS_ID, EMI_USER_ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID=?)|SELECT PRIORITY, TASK_NAME, RE_ASSIGNABLE, RE_ASSIGNABLE_TO_VL_ID, CREATE_DATE, UPDATE_DATE, END_DATE, TIME_STAMP, STATUS_ID, EMI_USER_ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID='4') | 1087044981602|-1||resultset|SELECT PRIORITY, TASK_NAME, RE_ASSIGNABLE, RE_ASSIGNABLE_TO_VL_ID, CREATE_DATE, UPDATE_DATE, END_DATE, TIME_STAMP, STATUS_ID, EMI_USER_ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID='4')|PRIORITY = 3, RE_ASSIGNABLE_TO_VL_ID = 1, TASK_NAME = t4 | 1087044981742|130|0|statement|SELECT ID, EMI_USER_ID FROM TASK WHERE (ID=?) OR (ID=?) OR (ID=?) OR (ID=?) OR (ID=?)|SELECT ID, EMI_USER_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5') | 1087044981742|-1||resultset|SELECT ID, EMI_USER_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044981742|-1||resultset|SELECT ID, EMI_USER_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044981742|-1||resultset|SELECT ID, EMI_USER_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044981742|-1||resultset|SELECT ID, EMI_USER_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044981742|-1||resultset|SELECT ID, EMI_USER_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044981982|130|0|statement|SELECT ID, STATUS_ID FROM TASK WHERE (ID=?) OR (ID=?) OR (ID=?) OR (ID=?) OR (ID=?)|SELECT ID, STATUS_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5') | 1087044981982|-1||resultset|SELECT ID, STATUS_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044981982|-1||resultset|SELECT ID, STATUS_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044981982|-1||resultset|SELECT ID, STATUS_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044981982|-1||resultset|SELECT ID, STATUS_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044981982|-1||resultset|SELECT ID, STATUS_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044982192|140|1|statement|SELECT OBJECT_TYPE_VL_ID, DESCRIPTION, INFORMATION_SOURCE_VL_ID, STATUS_TYPE_VL_ID, START_DATE, END_DATE, CREATE_DATE, UPDATE_DATE, TIME_STAMP, CREATOR_USER_ID, UPDATOR_USER_ID, VERSION, IS_OBSOLETE FROM STATUS WHERE (ID=?)|SELECT OBJECT_TYPE_VL_ID, DESCRIPTION, INFORMATION_SOURCE_VL_ID, STATUS_TYPE_VL_ID, START_DATE, END_DATE, CREATE_DATE, UPDATE_DATE, TIME_STAMP, CREATOR_USER_ID, UPDATOR_USER_ID, VERSION, IS_OBSOLETE FROM STATUS WHERE (ID='1') | 1087044982192|-1||resultset|SELECT OBJECT_TYPE_VL_ID, DESCRIPTION, INFORMATION_SOURCE_VL_ID, STATUS_TYPE_VL_ID, START_DATE, END_DATE, CREATE_DATE, UPDATE_DATE, TIME_STAMP, CREATOR_USER_ID, UPDATOR_USER_ID, VERSION, IS_OBSOLETE FROM STATUS WHERE (ID='1')|DESCRIPTION = NEW, INFORMATION_SOURCE_VL_ID = null, OBJECT_TYPE_VL_ID = null, STATUS_TYPE_VL_ID = NEW, VERSION = 0 | 1087044982363|151|0|statement|SELECT ID FROM REASON WHERE (STATUS_ID=?)|SELECT ID FROM REASON WHERE (STATUS_ID='1') | 1087044982493|130|0|statement|SELECT ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID=?) OR (ID=?) OR (ID=?) OR (ID=?) OR (ID=?)|SELECT ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5') | 1087044982493|-1||resultset|SELECT ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044982493|-1||resultset|SELECT ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044982493|-1||resultset|SELECT ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044982493|-1||resultset|SELECT ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044982493|-1||resultset|SELECT ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID='4') OR (ID='1') OR (ID='2') OR (ID='3') OR (ID='5')| | 1087044982673|130|1|statement|SELECT FLOW_NAME, CURRENT_STATE, CREATE_DATE, UPDATE_DATE, END_DATE, TIME_STAMP FROM FLOW_CONTEXT WHERE (ID=?)|SELECT FLOW_NAME, CURRENT_STATE, CREATE_DATE, UPDATE_DATE, END_DATE, TIME_STAMP FROM FLOW_CONTEXT WHERE (ID='1') | 1087044982673|-1||resultset|SELECT FLOW_NAME, CURRENT_STATE, CREATE_DATE, UPDATE_DATE, END_DATE, TIME_STAMP FROM FLOW_CONTEXT WHERE (ID='1')|CURRENT_STATE = state, FLOW_NAME = flow 1 | 1087044982793|120|0|statement|SELECT FLOW_CONTEXT_ID FROM LOCAL_ATTRIB_FOR_FLOW_CONTEXT WHERE (ATTRIBUTE_ID=?)|SELECT FLOW_CONTEXT_ID FROM LOCAL_ATTRIB_FOR_FLOW_CONTEXT WHERE (ATTRIBUTE_ID='1') | 1087044982923|130|0|statement|SELECT FLOW_CONTEXT_ID FROM FLOW_ATTRIB_FOR_FLOW_CONTEXT WHERE (ATTRIBUTE_ID=?)|SELECT FLOW_CONTEXT_ID FROM FLOW_ATTRIB_FOR_FLOW_CONTEXT WHERE (ATTRIBUTE_ID='1') | 1087044983054|131|0|statement|SELECT FLOW_CONTEXT_ID FROM HANDLED_OBJ_FOR_FLOW_CONTEXT WHERE (HANDLED_OBJECT_ID=?)|SELECT FLOW_CONTEXT_ID FROM HANDLED_OBJ_FOR_FLOW_CONTEXT WHERE (HANDLED_OBJECT_ID='1') | 1087044983184|130|0|statement|SELECT ROLE_VL_ID, TASK_ID FROM ROLE_FOR_TASK WHERE (ROLE_VL_ID=?) OR (ROLE_VL_ID=?) OR (ROLE_VL_ID=?) OR (ROLE_VL_ID=?) OR (ROLE_VL_ID=?)|SELECT ROLE_VL_ID, TASK_ID FROM ROLE_FOR_TASK WHERE (ROLE_VL_ID='4') OR (ROLE_VL_ID='1') OR (ROLE_VL_ID='2') OR (ROLE_VL_ID='3') OR (ROLE_VL_ID='5') | 1087044983324|140|1|statement|SELECT PRIORITY, TASK_NAME, RE_ASSIGNABLE, RE_ASSIGNABLE_TO_VL_ID, CREATE_DATE, UPDATE_DATE, END_DATE, TIME_STAMP, STATUS_ID, EMI_USER_ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID=?)|SELECT PRIORITY, TASK_NAME, RE_ASSIGNABLE, RE_ASSIGNABLE_TO_VL_ID, CREATE_DATE, UPDATE_DATE, END_DATE, TIME_STAMP, STATUS_ID, EMI_USER_ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID='1') | 1087044983324|-1||resultset|SELECT PRIORITY, TASK_NAME, RE_ASSIGNABLE, RE_ASSIGNABLE_TO_VL_ID, CREATE_DATE, UPDATE_DATE, END_DATE, TIME_STAMP, STATUS_ID, EMI_USER_ID, FLOW_CONTEXT_ID FROM TASK WHERE (ID='1')|PRIORITY = 1, RE_ASSIGNABLE_TO_VL_ID = 1, TASK_NAME = t2 | After this it hangs. Since the user is the same user, it may be trying to get the reference to the same userBean in cache, and maybe this is where I have a lock? What do you think? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3838565#3838565 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3838565 ------------------------------------------------------- This SF.Net email is sponsored by the new InstallShield X. >From Windows to Linux, servers to mobile, InstallShield X is the one installation-authoring solution that does it all. Learn more and evaluate today! http://www.installshield.com/Dev2Dev/0504 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
