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.
