I have a ques.. can you tell me whats going on here: I request an update and then try to read the updated data.. but I do not see the changes in my jsp (I do see the changes in database).. then I do a refresh on my jsp again which calls getDetails() method and this time I do see the changes on jsp also. So does this mean that the jdbc commit is taking its time in the background while it returns the control back to the update method ? Here's a quick simple idea of what I do:
Do you Clear the cache in your Jsp. This could be because of that. If this code is not in your jsp, add it and check it out.
Hope this helps.
Thanks and Regards, Arul.
Joined: Oct 19, 2005
Tks for the suggestion but its not a jsp cache issue because I have multiple tiles (using struts) in my jsp and all come back with the latest updated values except one particular tile which comes from a table which has to do some extra work via its triggers when I update that table. I've put debugging statements before and after the service calls and it clearly shows old data for that table coming back.. but when I call that service to get results from that table again.. everything is fine. I have no ideas what can I do to tell my update method to wait until the commit is totally complete. Not even sure if its that issue.. tks
subject: does commit return before transaction complete