java - org.hibernate.QueryException: could not resolve property: company of: Party [from Party party where party.company.name = :companyName] -


i have following class: 

@xmlaccessortype(xmlaccesstype.field) @xmltype(name = "party", proporder = {     "company" }) @entity(name = "party") @table(name = "party") @inheritance(strategy = inheritancetype.joined) public class party implements equals, hashcode, tostring {      @xmlelement(name = "company")     protected companytype company;       /**      * gets value of company property.      *       * @return      *     possible object      *     {@link companytype }      *           */      @manytoone(targetentity = companytype.class, cascade = {cascadetype.all})     @joincolumn(name = "company_0")     public companytype getcompany() {         return company;     }      /**      * sets value of company property.      *       * @param value      *     allowed object      *     {@link companytype }      *           */     public void setcompany(companytype value) {         this.company = value;     }    }

this companytype class: 

@xmlaccessortype(xmlaccesstype.field) @xmltype(name = "companytype", proporder = {"name"})  @entity(name = "companytype") @table(name = "companytype") @inheritance(strategy = inheritancetype.joined) public class companytype implements equals, hashcode, tostring {  @xmljavatypeadapter(stringtrimadapter.class) protected string name;   /**  * gets value of name property.  *   * @return  *     possible object  *     {@link string }  *       */ @basic @column(name = "name", columndefinition = "text") public string getname() {     return name; }  /**  * sets value of name property.  *   * @param value  *     allowed object  *     {@link string }  *       */ public void setname(string value) {     this.name = value; } }

i used following query fetch data: 

query q = null;  q = session.createquery( "from party party party.company.name = :companyname")             .setparameter("companyname", companyname);      return classutils.cast(q.setresulttransformer(distinctrootentityresulttransformer.instance).list());

but, got following error:

org.hibernate.queryexception: not resolve property: company of: party [from party party party.company.name = :companyname]       @ org.hibernate.queryexception.generatequeryexception(queryexception.java:137)     @ org.hibernate.queryexception.wrapwithquerystring(queryexception.java:120)     @ org.hibernate.hql.internal.ast.querytranslatorimpl.docompile(querytranslatorimpl.java:234)     @ org.hibernate.hql.internal.ast.querytranslatorimpl.compile(querytranslatorimpl.java:158)     @ org.hibernate.engine.query.spi.hqlqueryplan.<init>(hqlqueryplan.java:126)     @ org.hibernate.engine.query.spi.hqlqueryplan.<init>(hqlqueryplan.java:88)     @ org.hibernate.engine.query.spi.queryplancache.gethqlqueryplan(queryplancache.java:190)     @ org.hibernate.internal.abstractsessionimpl.gethqlqueryplan(abstractsessionimpl.java:301)     @ org.hibernate.internal.abstractsessionimpl.createquery(abstractsessionimpl.java:236)     @ org.hibernate.internal.sessionimpl.createquery(sessionimpl.java:1800)     @ sun.reflect.nativemethodaccessorimpl.invoke0(native method)     @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:57)     @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43)     @ java.lang.reflect.method.invoke(method.java:606)     @ org.hibernate.context.internal.threadlocalsessioncontext$transactionprotectionwrapper.invoke(threadlocalsessioncontext.java:356)     @ com.sun.proxy.$proxy104.createquery(unknown source)

any appreciated. thank you.

i believe missing join in hql query;

q = session.createquery( "from party party inner join party.company company company.name = :companyname")             .setparameter("companyname", companyname);

Comments

Post a Comment

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

this code i'm using find latitude , longitude of place: function coords($address){ echo $url="http://maps.googleapis.com/maps/api/geocode/json?address=".$address; $json = file_get_contents(urlencode($url)); $data = json_decode($json, true); print_r($data['results'][0]['geometry']['location']['lat']); print_r($data['results'][0]['geometry']['location']['lng']); } however returns warning: failed open stream: http request failed! http/1.0 400 bad request if use above code in simple procedure works fine not in function. note: have tried curl_init()... method produced same result? instead of encoding whole url encode address part. following code work fine $add='jamshoro phase 2'; $url="http://maps.googleapis.com/maps/api/geocode/json?address=".urlencode($add); $json = file_get_contents($url); $data = json_decode($json, true); print_r($data['r
Read more

java - How to filter a backspace keyboard input -

i have code gives message when key number pressed: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochararray().length - 1]; if (!(ch >= '0' && ch <= '9')) { system.out.println("the char entered not number"); t.consume(); } } }); now if press on wrong button , press backspace remove it, error message. how can add backspace input if statement? i have found answer: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochar
Read more

java - Show Soft Keyboard when EditText Appears -

i have code in android app, alert dialog , keyboard, , when dialog shown want keyboard appear. not , not sure why? here code: final alertdialog.builder alert = new alertdialog.builder(this); alert.settitle("title"); alert.setmessage("message"); final edittext input = new edittext(this); input.setinputtype(inputtype.type_class_number); alert.setview(input); input.setonfocuschangelistener(new view.onfocuschangelistener() { @override public void onfocuschange(view v, boolean hasfocus) { if (hasfocus) { log.i(tag, "in focus"); inputmethodmanager inputmethodmanager = (inputmethodmanager) getsystemservice(context.input_method_service); inputmethodmanager.showsoftinput(input, inputmethodmanager.show_implicit); } } }); but keyboard not appear though edit text in focus, , tell appear why, doesn't come up? thanks in advance.
Read more