Eclipse Community Forums: EclipseLink

Home » Eclipse Projects » EclipseLink » JPA caching

Wed, 30 January 2013 16:40

Eclipse User

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,

Re: JPA caching [message #1007353 is a reply to message #1006336]

Tue, 05 February 2013 10:38

Eclipse User

If your stored procedure returns entity objects, then they will be cached in the object cache.

If it does not return objects, or you wish to cache the result of the stored procedure call, then you can use a query cache for the query.

See,
http://wiki.eclipse.org/EclipseLink/UserGuide/JPA/Basic_JPA_Development/Caching/Query_Cache

Re: JPA caching [message #1007746 is a reply to message #1007353]

Thu, 07 February 2013 06:58

Eclipse User

Greetings Mr. Sutherland,

Thank you for your response. It is really helpful for me.
I have read EclipseLink wiki articles, but unfortunately it avoids me does JPA keep cache actual on delete or create data from tables stored procedures call.

For example we have table db_entities, object model

/*
Entity declarations 
*/
class CurrentEntity{
/*
Id and serialization declarations 
*/
private Long id;

/*
Column declarations
*/
private String name;
}

And stored procedures for create and delete data:

begin
delete from db_entities where id=param;
end;

begin
insert into db_entities values(name /*, etc.*/);
end;

Could you please help to find answer the question will JPA Cache track database table changes on these stored procedures call?

Greatest thanks in advance,

[Updated on: Thu, 07 February 2013 06:58] by Moderator

Re: JPA caching [message #1007857 is a reply to message #1007746]

Thu, 07 February 2013 13:55

Eclipse User

The query cache is used to avoid executing the query a second time. The hints shown in the link can only be added to and used with read queries and should not be added to a query that modifies data, and data modified through native SQL, procedure or even bulk update+delete do not change the data that has been cached. This is part of why the link suggests using it for data that is relatively static or read only.

Can you explain what it is you are looking to cache and why?

Best Regards,
Chris

[Updated on: Thu, 07 February 2013 14:03] by Moderator

Re: JPA caching [message #1008081 is a reply to message #1006336]

Fri, 08 February 2013 15:02

Eclipse User

Greetings Mr. Delahunt,

Thank you for your attention to my post.
My general idea is to use in my application both features of link cache feature (I assume link cache is being kept actual even on grid database architecture with right application server) and power of native sql queries (like force index, insert on duplicate key etc).

So, I'm trying to have opportunity to reach all of features to prevent making extra times database data extraction (with link cache), to obtain database performance with highly optimized JPA queries (with native sql language I assume) and to map queries result to objects (with basic link functionality).

Thank you,

[Updated on: Fri, 08 February 2013 15:07] by Moderator

Previous Topic:	Alert that DCN Took Place
Next Topic:	Eclipse link multiple SQL web services operations

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 00:40:12 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter