java - Simple @ManyToOne relation: could not resolve property (org.hibernate.QueryException) -


i have simple relationship - can seen in picture:

enter image description here

as try read read out city country_id:

country austria = (country) session.load(country.class, 1l);  // works expected system.out.println(austria.tostring());          criteria crcities = session.createcriteria(city.class); crcities.add(restrictions.eq("country_id", austria.getid())); // crashes .. list<city> cities = crcities.list();  system.out.println("show cities of austria:"); (city next : cities) {     system.out.println(" - " + next.getname()); }

i'm getting following error:

exception in thread "main" org.hibernate.queryexception: not resolve property: country_id of: com.mahlzeit.datamodel.geographic.city

this pojos:

country.java

package com.mahlzeit.datamodel.geographic;  import javax.persistence.entity; import javax.persistence.generatedvalue; import javax.persistence.id; import javax.persistence.table;  @entity @table public class country {      @id     @generatedvalue     private long id;      private string country_code;      public string getcountrycode() {         return country_code;     }      public void setcountrycode(string countrycode) {          this.country_code = countrycode;     }      public long getid() {         return id;     }      public void setid(long id) {         this.id = id;     }      @override     public string tostring() {         return "country [id=" + id.tostring() + ", country_code=" + country_code.tostring()  +"]";     } }

city.java

package com.mahlzeit.datamodel.geographic;  import javax.persistence.entity; import javax.persistence.generatedvalue; import javax.persistence.id; import javax.persistence.joincolumn; import javax.persistence.manytoone; import javax.persistence.table;  @entity @table public class city {      @id     @generatedvalue     private long id;      @manytoone     @joincolumn(name = "country_id")     private country country;      private string name;      public string getname() {         return name;     }      public void setname(string name) {         this.name = name;     }      public country getcountry() {         return country;     }      public void setcountry(country country) {         this.country = country;     }      public long getid() {         return id;     }      public void setid(long id) {         this.id = id;     }       @override     public string tostring() {         return "city [id=" + id.tostring() + ", country="                 + country.tostring() + ", name=" + name + "]";     } }

what have make work? @joincolumn(name = "country_id") correct in city.java?

you have change critera crcities.add(restrictions.eq("country.id", austria.getid()));.

you can't use join column. have use column in joined object.


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