[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [eclipselink-users] Order By with DB2/400 DataBase
|
What does the code that runs your query look like?
On 27/02/2012 8:45 AM, Lexuor76 wrote:
I haven't modify the SQL request. It's the simple paste from my output.
My entity is :
import javax.persistence.*;
import java.io.Serializable;
import java.math.BigDecimal;
@Entity @Table(name = "INCMDE")
public class OrderEntity implements Serializable {
@Id @Column(name = "OFNOFF")
private long id;
@Column(name = "CLCCLI")
private long customerId;
@Column(name = "CLMDIR")
private String customerMainWord;
@Column(name = "OFDCRE")
private BigDecimal creationDate;
@Column(name = "OFCCOM")
private String commercial;
@Column(name = "OFINAT")
private char nature;
@Column(name = "OFLOFF")
private String wording;
@Column(name = "OFTHTV")
private BigDecimal totalSalesHT;
@Column(name = "OFTTCV")
private BigDecimal totalPurchaseTTC;
@Column(name = "OFTHTA")
private BigDecimal totalPurchaseHT;
@Column(name = "OFADL0")
private String deliveryCompanyName;
@Column(name = "OFADL1")
private String deliveryAddress1;
@Column(name = "OFADL2")
private String deliveryAddress2;
@Column(name = "OFADL3")
private String deliveryAddress3;
@Column(name = "OFCPOL")
private long deliveryZIPCode;
@Column(name = "OFADF0")
private String billingCompanyName;
@Column(name = "OFADF1")
private String billingAddress1;
@Column(name = "OFADF2")
private String billingAddress2;
@Column(name = "OFADF3")
private String billingAddress3;
@Column(name = "OFCPOF")
private long billingZIPCode;
@Column(name = "OFDEMI")
private BigDecimal issueDate;
@Column(name = "CMNOFF")
private long initialOffer;
@Column(name = "CMIACP")
private char accepted;
@Column(name = "CMPACO")
private long depositPercentage;
@Column(name = "CMMACO")
private BigDecimal depositAmount;
@Column(name = "CMIACO")
private char depositPaid;
@Column(name = "CMMACV")
private BigDecimal depositPaidAmount;
@Column(name = "CMIFAC")
private char charged;
@Column(name = "CMIFRI")
private boolean fridge;
@Column(name = "CMLFRI")
private String fridgeReason;
}
I deleted getter/setter for understanding.
