MongoDB + Spring MVC -
i have working project combination of spring mvc , mongodb .
the database structure
{ "id": " 12214 -1", "era": " 12214 -1", "agreementid": null, "agreementnumber": null, "devicetimestamp": null, "tag": null, "curentlocation": null, "gps": "no", "grps": "no", "logs": {}, "isread": "1.0", "rpttime": "15:00", "salut": "mr", "guestname": "ritesh arora", "guestcompshortname": "mmi", "vehnum": "kl22e2448", "chauffname": "baba", "rptdate": "40-83-2.01 15:00", "rladdr": null, "rentaltype": "local run", "addressrl": "okhla", "status": "received carpro" } bean class structre
@document public class agreement { @id private string id; private string era; private agreementid agreementid; // /aggrement no private string agreementnumber; private string rladdr; // // rl private string salut; // // salut private string guestname; // //guestname ; private string guestcompshortname; // / company; private string vehnum; // / vechilenumber private string chauffname; // / driver private string rentaltype; // / rentaltype private string addressrl; // / reportingaddress private string rptdate; // / rptdate + rpttime reportingdatetime private string rpttime; // / rptdate + rpttime reportingdatetime private string devicetimestamp; // /// private string tag; private string curentlocation; @field("status") private string status; // // erastatus private string gps; private string type; private string grps; private map<string, map<string, double>> logs; private string isread; private string name; public string gettype() { return this.getstatus(); } public string getname() { return name; } public void setname(string name) { this.name = name; } public void settype(string type) { this.type = type; } public string getisread() { return isread; } public void setisread(string isread) { this.isread = isread; } public string getera() { this.id = this.id.replace("{ \"agreementno\" :", "") .replace(" \"subno\" : ", "").replace("}", "") .replace(",", "-"); return this.id; } public void setera(string era) { this.era = era; } public agreementid getagreementid() { return agreementid; } public void setagreementid(agreementid agreementid) { this.agreementid = agreementid; } public string getrladdr() { return rladdr; } public void setrladdr(string rladdr) { rladdr = rladdr; } public string getsalut() { return salut; } public void setsalut(string salut) { salut = salut; } public string getguestname() { return guestname; } public void setguestname(string guestname) { guestname = guestname; } public string getguestcompshortname() { return guestcompshortname; } public void setguestcompshortname(string guestcompshortname) { guestcompshortname = guestcompshortname; } public string getvehnum() { return vehnum; } public void setvehnum(string vehnum) { vehnum = vehnum; } public string getchauffname() { return chauffname; } public void setchauffname(string chauffname) { chauffname = chauffname; } public string getrentaltype() { string rtype = null; if (rentaltype == "1" || rentaltype.equalsignorecase("1")) { rtype = "local run"; } else if (rentaltype == "2" || rentaltype.equalsignorecase("2")) { rtype = "out station"; } else if (rentaltype == "3" || rentaltype.equalsignorecase("3")) { rtype = "transfer"; } else if (rentaltype == "4" || rentaltype.equalsignorecase("4")) { rtype = "package"; } else if (rentaltype == "5" || rentaltype.equalsignorecase("5")) { rtype = "self drive"; } else if (rentaltype == "6" || rentaltype.equalsignorecase("6")) { rtype = "ltr"; } return rtype; } public void setrentaltype(string rentaltype) { rentaltype = rentaltype; } public string getaddressrl() { return addressrl; } public void setaddressrl(string addressrl) { addressrl = addressrl; } public string getrptdate() { string d = rptdate.substring(4, 6) + "-" + rptdate.substring(6, 8) + "-" + rptdate.substring(0, 4); return d + " " + rpttime; } public void setrptdate(string rptdate) { rptdate = rptdate; } public string getrpttime() { return rpttime; } public void setrpttime(string rpttime) { rpttime = rpttime; } public string getdevicetimestamp() { return devicetimestamp; } public void setdevicetimestamp(string devicetimestamp) { this.devicetimestamp = devicetimestamp; } public string gettag() { return tag; } public void settag(string tag) { this.tag = tag; } public string getcurentlocation() { return curentlocation; } public void setcurentlocation(string curentlocation) { this.curentlocation = curentlocation; } public string getstatus() { string str = null; if (status == "1" || status.equals("1")) { status = "received carpro"; } else if (status == "2" || status.equals("2")) { status = "complete close"; } else if (status == "3" || status.equals("3")) { status = "recall"; } else if (status == "4" || status.equals("4")) { status = "accepted"; } else if (status == "5" || status.equals("5")) { status = "start journey"; } else if (status == "6" || status.equals("6")) { status = "reached pickup location"; } else if (status == "7" || status.equals("7")) { status = "reached drop off location"; } else if (status == "8" || status.equals("8")) { status = "duty completed"; } else if (status == "9" || status.equals("9")) { status = "expense pending"; } else if (status == "10" || status.equals("10")) { status = "didn't used"; } else if (status == "11" || status.equals("11")) { status = "didn't arrive"; } else if (status == "12" || status.equals("12")) { status = "break down"; } else if (status == "13" || status.equals("13")) { status = "exchange"; } else if (status == "14" || status.equals("14")) { status = "dispatched mobile"; } else if (status == "15" || status.equals("15")) { status = "not mapped or not delivered mobilee"; } else if (status == "16" || status.equals("16")) { status = "not accepted"; } else if (status == "17" || status.equals("17")) { status = "start button not pressed"; } else if (status == "18" || status.equals("18")) { status = "pickup button not pressed"; } else if (status == "19" || status.equals("19")) { status = "closure status not received"; } else if (status == "20" || status.equals("20")) { status = "no gprs"; } else if (status == "21" || status.equals("21")) { status = "no gps"; } else if (status == "22") { status = "didn't communicate fleet"; } return status; } public void setstatus(string status) { status = status; } public string getagreementnumber() { return agreementnumber; } public void setagreementnumber(string agreementnumber) { this.agreementnumber = agreementnumber; } public string getid() { return id; } public void setid(string id) { this.id = id; } public map<string, map<string, double>> getlogs() { return logs; } public void setlogs(map<string, map<string, double>> logs) { this.logs = logs; } public string getgps() { if (this.status == "21" || this.status.equalsignorecase("21")) return "yes"; else return "no"; } public void setgps(string gps) { this.gps = gps; } public string getgrps() { if (this.status == "20" || this.status.equalsignorecase("20")) return "yes"; else return "no"; } public void setgrps(string grps) { this.grps = grps; } @override public string tostring() { // todo auto-generated method stub return rladdr + " >>> " + salut + ">>>>>>> " + id + "vdsvsdvs "; } } but when used
query1.addcriteria(criteria.where("status").is("constant")); mongotemplate.find(query1, agreement.class, "era_live_v1"); i getting following error
severe: servlet.service() servlet [mvc-dispatcher] in context path [/avisweb] threw exception [request processing failed; nested exception o org.springframework.data.mapping.model.mappingexception: no property status found on com.avis.bean.agreement!] root cause org.springframework.data.mapping.model.mappingexception: no property status found on com.avis.bean.agreement! @ org.springframework.data.mapping.context.abstractmappingcontext.getpersistentpropertypath(abstractmappingcontext.java:228) @ org.springframework.data.mapping.context.abstractmappingcontext.getpersistentpropertypath(abstractmappingcontext.java:206) @ org.springframework.data.mapping.context.abstractmappingcontext.getpersistentpropertypath(abstractmappingcontext.java:194) @ org.springframework.data.mongodb.core.convert.querymapper$metadatabackedfield.getpath(querymapper.java:714) @ org.springframework.data.mongodb.core.convert.querymapper$metadatabackedfield.<init>(querymapper.java:605) @ org.springframework.data.mongodb.core.convert.querymapper.createpropertyfield(querymapper.java:152) @ org.springframework.data.mongodb.core.convert.querymapper.getmappedobject(querymapper.java:113) @ org.springframework.data.mongodb.core.mongotemplate.dofind(mongotemplate.java:1515) @ org.springframework.data.mongodb.core.mongotemplate.dofind(mongotemplate.java:1506) @ org.springframework.data.mongodb.core.mongotemplate.find(mongotemplate.java:532)
when make entity bean class have @column name write column name declare in database , in intial value declare name
Comments
Post a Comment