Hi Mostafa, Thanks for the additional information. Looking at your POJO, I've noticed that a couple of setters use upper-case "S" in "Set". That's not standard JavaBeans convention, and is not supported by jOOQ's DefaultRecordMapper: http://www.jooq.org/javadoc/latest/org/jooq/impl/DefaultRecordMapper.html
E.g. change SetLETTERDATE to setLETTERDATE Hope this helps, Lukas 2014-07-02 8:18 GMT+02:00 Mostafa Shafeian <[email protected]>: > hi > My sp return refcursor. > I used jooq 3.4. > Xml result is : > <result xmlns="http://www.jooq.org/xsd/jooq-export-2.6.0.xsd";><fields><field > name="BRANCHNAME" type="VARCHAR2"/><field name="ACCOUNTNUMBERTITLE" > type="VARCHAR2"/><field name="ACCOUNTNUMBERSTORE" type="NUMBER"/><field > name="ACCOUNTOPENSTOREMIN" type="NUMBER"/><field name="GAINDEPOSIT" > type="VARCHAR2"/><field name="BRANCHCODE" type="NUMBER"/><field > name="LETTERDATE" type="CHAR"/><field name="STORE" > type="NUMBER"/></fields><records><record><value > field="BRANCHNAME">xxx</value><value > field="ACCOUNTNUMBERTITLE">xxxxxxx</value><value > field="ACCOUNTNUMBERSTORE">91950000</value><value > field="ACCOUNTOPENSTOREMIN">50000</value><value field="GAINDEPOSIT"/><value > field="BRANCHCODE">7894</value><value field="LETTERDATE"/><value > field="STORE">0214578</value></record> > > pmodel same as: > > private String GAINDEPOSIT; > private Integer BRANCHCODE; > private String LETTERDATE; > private long STORE; > public void setGAINDEPOSIT(String GAINDEPOSIT) { > this.GAINDEPOSIT = GAINDEPOSIT; > } > /** > * @return the BRANCHCODE > */ > public Integer getBRANCHCODE() { > return BRANCHCODE; > } > > /** > * @param BRANCHCODE the BRANCHCODE to set > */ > public void SetBRANCHCODE(Integer BRANCHCODE) { > this.BRANCHCODE= BRANCHCODE; > } > > /** > * @return the LETTERDATE > */ > public String getLETTERDATE() { > return LETTERDATE; > } > > /** > * @param LETTERDATE the LETTERDATE to set > */ > public void SetLETTERDATE(String LETTERDATE) { > this.LETTERDATE = LETTERDATE; > } > > /** > * @return the STORE > */ > public long getSTORE() { > return STORE; > } > > > On Tuesday, July 1, 2014 7:01:36 PM UTC+4:30, Mostafa Shafeian wrote: >> >> Hi everybody >> I wrote this command: >> res = PkgRptsearch.rptsearch(configuration.CreateConfiguration(), >> null); //execute query >> System.out.println("XML="+res.formatXML()); >> List<pmodel> list= res.into(pmodel.class); >> In output,Some fileds are be null but in xml format everything is ok. >> Why do this problrm happen? >> thanks >> >> >> -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
