3 Replies Latest reply on Jan 31, 2013 10:06 PM by 988128

    JPA caching


      Could somebody help me to find answer does EclipseLink JPA implementation NativeQuery cache results of stored procedure execuing like
      call get_entities(2,3,2);
      Is here some way to have stored procedures excection result cached with JPA otherwise?

      Greatest thanks in advance,
        • 1. Re: JPA caching
          By default, EclipseLink stores query results in the session cache.

          PLSQLStoredProcedureCall may be used with EclipseLink JPA.
          • 2. Re: JPA caching
            You will get better help with EclipseLink runtime on the EclipseLink forum.


            - Konstantin
            • 3. Re: JPA caching
              Greetings Dvohra,

              Thank you for you reply, but I have notes Eclipselink manual covers NamedQueries and Queries only in the cache paragraph (I have no direct link right now to this material). Also here are no proofs of that kind Eclipselink could catch calling stored procedures of deleting database records and to make changes in cache needed like
              # delete from goods where id > 3 and id < 112;
              call delete_goods(3,112);
              Greetings Konstantin,

              Thank you for you reply - I have posted to Eclipse forum, but I still have no luck to get answers.

              Best regards,