Re: [eclipselink-users] Order By with DB2/400 DataBase

[Lexuor76 <lexuor76@xxxxxxxxx>]

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.

-- 
View this message in context: http://old.nabble.com/Order-By-with-DB2-400-DataBase-tp33385840p33399810.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.