Bugs item #849600, was opened at 2003-11-26 12:48
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=849600&group_id=22866
Category: JBossCMP
Group: v3.2
Status: Open
Resolution: None
Priority: 5
Submitted By: Torsten Henschel (henschel)
Assigned to: Nobody/Anonymous (nobody)
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
----------------------------------------------------------------------
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
