I am using WebLogic 8.1 sp1 on win 2000. I used CMP to update the records. I found that the corresponding update sql statements fired by CMP were reordered and put immediately in front of transaction commit. It lead to bugs difficult to troubleshoot. Because after calling setter methods of CMP updated the records, my program would call (1) stored procedure to retrieve data or (2) finder methods to retrieve data. But this methods could not return records updated by CMP because of automatic reorder of sql statements done by WL.

Is there any way to get around this problem ? Can i configure the server not to reorder the sql statements fired by CMP ? what is the side-effect to app performance.

It would be thankful somebody can help to answer my above questions