caching - EclipseLink Cache not getting cached -

- 

@namedquery(             name=dbconstants.service_by_id, query="select s service s s.id= :id",             hints={                     @queryhint(name = queryhints.query_results_cache, value = hintvalues.true),                     @queryhint(name = queryhints.query_results_cache_size, value = "500")             })

i using different entity manager on every query request.

query query = em.createnamedquery(dbconstants.service_by_id); query.setparameter("id", id); result = (service) query.getsingleresult();

this returning data database not cache.

how tested -> changed column value in database , when performed query, modified value coming. ideally should return stale data since cache not refreshed or invalidated.

revision 2:

if trying cache named queries, using multitenant aware persistence classes cause problem. how? here way think works:

@cache(         type=cachetype.soft,         size=6000,         expiry=600000 ) @multitenant @tenantdiscriminatorcolumn(...) @namedqueries({     @namedquery(             name=dbconstants.all_services, query="select s service s",             hints={                     @queryhint(name = queryhints.query_results_cache, value = hintvalues.true),                     @queryhint(name = queryhints.query_results_cache_size, value = "10")             })     }) })  @idclass(servicepk.class) public class service implements serializable { ... }

creation of emf:

string tenantid = gettenantid(); properties.put(dbconstants.tenant_id_context_property, tenantid); properties.put(dbconstants.link_session_name, "session-" + tenantid);  if(emf == null)     emf = persistence.createentitymanagerfactory("<persistence_unit_name>", properties);

creation of em:

em = emf.createentitymanager();

in case, our named query "all_services" search services , want named query cache cache based on query. when execute query, em appends tenantid query i.e.

select s service s s.tenantid = <value>

this cached in isolated cache of l1 cache , available till use same em instance. when create new em instance, checks if entry present in l2 cache before trying invoke query on db. l2 caches based on query mentioned not tenantid appended. causes cache hit miss , call goes backend.

now... how solve problem? can remove multitenant annotations , add tenantid myself in query. tested , works absolutely fine.

but removing multitenant annotation causes lot of condition checks done manually when have dependencies on other persistence classes.

i need better solution. can help???


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more