0 Replies Latest reply on Oct 19, 2007 6:21 AM by Kestas ruks

    Critical Major Problem/Bug

    Kestas ruks Newbie

      Good day,

      Sorry for writing post with such screaming subject, but at least for me it's very important problem.
      I want to rise the same problem again, please read the first orginal thread also:
      http://www.jboss.com/index.html?module=bb&op=viewtopic&t=120234

      I thought that I solved temporrary the problem described in original thread with such trick:
      if select count(*) return for example 2
      but select f returns only 1 object. I execute again select with additional condition " and 1192011323161 = 1192011323161" (These numbers are just current time in milisecs). My goal was to show that select is new and unique and I thought that in such case jboss will execute this query and would not use its own cache. For a while I thought that this is working, but now sometimes when this bug occurs and I execute again query with additional condintion i getting correct count of objects for example 2, but in results List I getting the same object twice, not two different objects how schould be.

      Also I noticed that if in persistence.xml set such values to false, maybe bug occurs not so often but for sure it occurs.

      <property name="hibernate.cache.use_second_level_cache" value="false"/>
      <property name="hibernate.cache.use_query_cache" value="false" />
      <property name="hibernate.statement_cache.size" value="0"/>
      

      I'm using Oracle 10.2.0.1.0 , jboss-4.2.0.GA

      Sorry for writing post for the same issue second time and with such screaming subject, but at least for me it's very important problem. I'm waiting any comments and ideas.

      I'm waiting any comments and ideas.
      Thanks