This discussion is archived
3 Replies Latest reply: Jan 31, 2013 2:06 PM by 988128 RSS

JPA caching

988128 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points