3 Replies Latest reply: Jan 31, 2013 4:06 PM by 988128 RSS

    JPA caching

    988128
      Greetings,

      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
          dvohra21
          By default, EclipseLink stores query results in the session cache.
          http://wiki.eclipse.org/Introduction_to_EclipseLink_Queries_(ELUG)#How_to_Cache_Query_Results_in_the_Session_Cache

          PLSQLStoredProcedureCall may be used with EclipseLink JPA.
          http://wiki.eclipse.org/Using_Basic_Query_API_%28ELUG%29#Using_a_StoredProcedureCall
          http://wiki.eclipse.org/EclipseLink/Examples/JPA/nonJDBCArgsToStoredProcedures
          • 2. Re: JPA caching
            kosta
            You will get better help with EclipseLink runtime on the EclipseLink forum.

            http://www.eclipse.org/forums/index.php?t=thread&frm_id=111

            - Konstantin
            • 3. Re: JPA caching
              988128
              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,