Results 1 to 4 of 4
  1. #1
    mkhan is offline Member
    Join Date
    Oct 2009
    Posts
    2
    Rep Power
    0

    Default Data Cache Crossover

    Hello,

    I am database developer know very little about java, we have an application which connects to Oracle database and uses Oracle IAS as the app server, the application is very data centric, mostly updating/deleting/uploading quite a bit data to the database, the user population is about 600 mostly offsite. The users are only allowed to work with their own set of data and not allowed to view/update data of any other users.
    The application seems to be caching data on the app server may be designed that way to improve performance but what we are experiencing quite often that a user inadvertently stumbles upon data of other users, in other words the application is not pulling the correct data. We for sure know this is not due to a problem with SQL and we very much suspect that the app is not pulling the correct data from the cache and is confused about what cache belong to what user.
    My questions are
    1. What could be the causes for this issue ?
    2. Are there any know fool proof methods available to manage the cache ?

    If this is not the right forum for this type of question please let me know what forum this belong to.
    Any information/help is appreciated

    Thanks

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,970
    Rep Power
    19

    Default

    I very, very much doubt it's the app server.
    How are you connecting to Oracle in your system?
    Is it JDBC?

  3. #3
    mkhan is offline Member
    Join Date
    Oct 2009
    Posts
    2
    Rep Power
    0

    Default

    Yes we are using jdbc for the database connectivity and a connection pool

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,970
    Rep Power
    19

    Default

    JDBC does not cache, so it's not that.
    It is, basically, an access layer.
    Have you some example code around where you are getting odd results returned?

Similar Threads

  1. how can i do crossover in this tree structure?
    By player123 in forum Advanced Java
    Replies: 2
    Last Post: 02-11-2009, 06:49 PM
  2. clear cache
    By Jadellll in forum New To Java
    Replies: 0
    Last Post: 03-20-2008, 09:27 AM
  3. how to restict cache
    By fred in forum JavaServer Pages (JSP) and JSTL
    Replies: 1
    Last Post: 07-24-2007, 01:56 AM
  4. cache problem
    By MichYer in forum Java Applets
    Replies: 3
    Last Post: 07-11-2007, 09:13 AM
  5. Caché Monitor 0.35
    By levent in forum Java Software
    Replies: 0
    Last Post: 06-10-2007, 01:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •