Bugs item #849600, was opened at 2003-11-26 11:48 Message generated for change (Settings changed) made by ejort You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=849600&group_id=22866
>Category: JBossServer Group: v3.2 Status: Open >Resolution: Accepted Priority: 5 Submitted By: Torsten Henschel (henschel) >Assigned to: Adrian Brock (ejort) Summary: Problems with commit option C Initial Comment: We have problems with Commit Option C in JBoss 3.2.2. We use for all our entity beans this container configuration: Standard CMP 2.x EntityBean. And we changed commit option (line 227, standardjboss.xml, JBoss 3.2.2) from B to C (only for testing). Now should JBoss get all data in each new transaction from db. and this is our log from MySQL: First call (one transaction) ---------------------------- 031126 11:26:14 5 Query SELECT t0_o.folder_id FROM default_folder t0_o WHERE (t0_o.user_id = 12) 5 Query SELECT user_id FROM default_folder WHERE (folder_id=3) FOR UPDATE 5 Query select folder.folder_id, album_2_folder.album_id, album_2_folder.position from folder left join album_2_folder on folder.folder_id = album_2_folder.folder_id where folder.user_id = 12 order by folder.position asc, album_2_folder.position asc 5 Query SELECT folder_id FROM folder WHERE folder_id=3 5 Query SELECT user_id, name, description, position FROM folder WHERE (folder_id=3) FOR UPDATE 5 Query SELECT album_id FROM album WHERE album_id=1 5 Query SELECT user_id, name, description, class_id, status, creation_date, last_change_date, last_sync_date FROM album WHERE (album_id=1) FOR UPDATE 5 Query SELECT folder_id FROM folder WHERE folder_id=8 5 Query SELECT user_id, name, description, position FROM folder WHERE (folder_id=8) FOR UPDATE 5 Query SELECT album_id FROM album WHERE album_id=2 5 Query SELECT user_id, name, description, class_id, status, creation_date, last_change_date, last_sync_date FROM album WHERE (album_id=2) FOR UPDATE 5 Query SELECT album_id FROM album WHERE album_id=13 5 Query SELECT user_id, name, description, class_id, status, creation_date, last_change_date, last_sync_date FROM album WHERE (album_id=13) FOR UPDATE 5 Query SELECT folder_id FROM folder WHERE folder_id=25 5 Query SELECT user_id, name, description, position FROM folder WHERE (folder_id=25) FOR UPDATE 5 Query SELECT album_id FROM album WHERE album_id=22 5 Query SELECT user_id, name, description, class_id, status, creation_date, last_change_date, last_sync_date FROM album WHERE (album_id=22) FOR UPDATE 5 Query SELECT folder_id FROM folder WHERE folder_id=28 5 Query SELECT user_id, name, description, position FROM folder WHERE (folder_id=28) FOR UPDATE 5 Query SELECT folder_id FROM folder WHERE folder_id=29 5 Query SELECT user_id, name, description, position FROM folder WHERE (folder_id=29) FOR UPDATE 5 Query SELECT folder_id FROM folder WHERE folder_id=30 5 Query SELECT user_id, name, description, position FROM folder WHERE (folder_id=30) FOR UPDATE 5 Query commit Second call (new transaction, rom first call) --------------------------------------------- 031126 11:26:20 5 Query SELECT t0_o.folder_id FROM default_folder t0_o WHERE (t0_o.user_id = 12) 5 Query select folder.folder_id, album_2_folder.album_id, album_2_folder.position from folder left join album_2_folder on folder.folder_id = album_2_folder.folder_id where folder.user_id = 12 order by folder.position asc, album_2_folder.position asc 5 Query SELECT folder_id FROM folder WHERE folder_id=3 5 Query SELECT album_id FROM album WHERE album_id=1 5 Query SELECT folder_id FROM folder WHERE folder_id=8 5 Query SELECT album_id FROM album WHERE album_id=2 5 Query SELECT album_id FROM album WHERE album_id=13 5 Query SELECT folder_id FROM folder WHERE folder_id=25 5 Query SELECT album_id FROM album WHERE album_id=22 5 Query SELECT folder_id FROM folder WHERE folder_id=28 5 Query SELECT folder_id FROM folder WHERE folder_id=29 5 Query SELECT folder_id FROM folder WHERE folder_id=30 5 Query commit Third call (new transaction) ---------------------------- 031126 11:26:55 5 Query SELECT t0_o.folder_id FROM default_folder t0_o WHERE (t0_o.user_id = 12) 5 Query select folder.folder_id, album_2_folder.album_id, album_2_folder.position from folder left join album_2_folder on folder.folder_id = album_2_folder.folder_id where folder.user_id = 12 order by folder.position asc, album_2_folder.position asc 5 Query SELECT folder_id FROM folder WHERE folder_id=3 5 Query SELECT album_id FROM album WHERE album_id=1 5 Query SELECT folder_id FROM folder WHERE folder_id=8 5 Query SELECT album_id FROM album WHERE album_id=2 5 Query SELECT album_id FROM album WHERE album_id=13 5 Query SELECT folder_id FROM folder WHERE folder_id=25 5 Query SELECT album_id FROM album WHERE album_id=22 5 Query SELECT folder_id FROM folder WHERE folder_id=28 5 Query SELECT folder_id FROM folder WHERE folder_id=29 5 Query SELECT folder_id FROM folder WHERE folder_id=30 5 Query commit It looks, that JBoss is caching this data. After changing some columns thru DB, JBoss shows old data. Regards, Rafal ---------------------------------------------------------------------- Comment By: Rafal Kedziorski (rafciom) Date: 2003-11-26 12:21 Message: Logged In: YES user_id=201737 Hi, I forgot to write, that our entity beans has all get*-methods as read-only=true. After changig this to false, it's working. Should JBoss at deployment ignore this, when commit option is set to C? Regards, Rafal ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=849600&group_id=22866 ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development