Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

apparent caching of result set

 
Tom Griffith
Ranch Hand
Posts: 275
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi. I have a controller jsp that calls a bean that performs a jdbc query against an oracle table, does some mathematical operations like caclulate averages, etc, and returns a reference to an ArrayList of results to the jsp. The results are displayed in a table. My problem is that whenever I change data in the table, whether deleting rows or adding them, I keep getting the very same result that I did the first time I ever loaded this page. Does anybody know what is happening...I have rebooted my client, deleted Temporary Internet files, etc. Even the next day, I get the same old result. Thank you.

Does this have something to do with maybe the ArrayList being held in memory by the server?..but over days?...
 
Tom Griffith
Ranch Hand
Posts: 275
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Any browser is receiving the same result...so something is cached on the server...any help is appreciated.

Oh, I just tried clearing the arraylist in the bean before using and it doesn't help.
 
Tom Griffith
Ranch Hand
Posts: 275
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hmm, it's turning out to be a database problem. Afte rputting some print statements in the bean, the numbers were coming in the same. So I went to the SQL client and found records that I thought were deleted via the SQL client (was attempting to clean out test records) were still there. This even after it told me "n rows deleted" when I fed it the DELETE command.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tom,
It sounds like you deleted the rows from the database command line. Did you commit your changes when done?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic