java - Fetch an EmbeddedId with a jpa query -


i have following entity embedded id :

public class refmoduleprofile {     private string pertinance;     @embeddedid     private refmoduleprofilepk pk = new refmoduleprofilepk(); }  @embeddable public class refmoduleprofilepk implements serializable {     @manytoone     private refmodule module;     @manytoone     private refprofile profile; }

now want load refmoduleprofile refprofile , refmodule fetched :

@query("select rmp refmoduleprofile rmp inner join fetch rmp.pk.module rmp.pk.profile = :profile") list<refmoduleprofile> findbyprofilwithfetchedmodule(@param("profile") refprofile profile);

this request generate following sql :

/* select     rmp      refmoduleprofile rmp  inner join     fetch rmp.pk.module      rmp.pk.profile = :profile */ select         refmodulep0_.id_module id_modul2_36_0_,         refmodulep0_.id_profile id_profi3_36_0_,         refmodule1_.id_module id_modul1_34_1_,         refmodulep0_.module_profile_pertinance module_p1_36_0_,         refmodule1_.module_alias module_a2_34_1_,         refmodule1_.module_label module_l3_34_1_,         refmodule1_.module_status module_s4_34_1_,         refmodule1_.user_admin user_adm5_34_1_              duo_ref_module_profile refmodulep0_      inner join         duo_ref_module refmodule1_              on refmodulep0_.id_module=refmodule1_.id_module              refmodulep0_.id_profile=?

this request seems good, generate following request (one per refmoduleprofile retrieved) :

/* load obs.duo.model.referentiel.refmodule */ select     refmodule0_.id_module id_modul1_34_0_,     refmodule0_.module_alias module_a2_34_0_,     refmodule0_.module_label module_l3_34_0_,     refmodule0_.module_status module_s4_34_0_,     refmodule0_.user_admin user_adm5_34_0_      duo_ref_module refmodule0_      refmodule0_.id_module=?

i don't think spring-data-jpa cause problem, can't find how change request or entity.


Comments

Post a Comment

Popular posts from this blog

iOS: Performance of reloading UIImage(name:...) -

i have tableview , each row has icon. 90% of rows have same icon. in cellforrowatindexpath method load image assets folder this: var cellimage = uiimage(named: "myimage") does pose performance problem? os somehow smart enough it's same image each time? better if loaded image once , saved in class variable , assigned each time? uiimage 's named: api does kind of caching. if @ uiimage's documentation , states: use init(named:in:compatiblewith:) method (or init(named:) method) create image image asset or image file located in app’s main bundle (or other known bundle). because these methods cache image data automatically, recommended images use frequently.
Read more

How to prevent logback from emitting repeated "Empty watch file list. Disabling" messages -

i have logback configured logback.xml located here: http://pastebin.com/kuquekxy . every minute, see log message emitted of form: 18:26:21,486 |-info in reconfigureonchangetask(born:1478715201485) - empty watch file list. disabling why happening , how can rid of these? i can tell why happening, not how rid of them. the reconfigureonchangetask log line when doesn't have files watch. and doesn't have files watch because file in jar, , only watch files on filesystem . makes sense, because files within jar file don't change.
Read more

c# SetCompatibleTextRenderingDefault must be called before the first -

i tried search exception couldn't find solution on case i'am using code below invoke .net application : assembly assem = assembly.load(data); methodinfo method = assem.entrypoint; var o = activator.createinstance(method.declaringtype); method.invoke(o, null); the application invoked has form , in entrypoint of application : [stathread] static void main() { application.enablevisualstyles(); application.setcompatibletextrenderingdefault(false); //exception application.run(new form1()); } setcompatibletextrenderingdefault must called before first iwin32window object created in application. edit : assembly = assembly.load(data); methodinfo method = a.gettype().getmethod("start"); var o = activator.createinstance(method.declaringtype); method.invoke(o, null); you should create new method skips initialization...
Read more