champ DTYPE ajouté

**Quartus** · 09/09/2009, 11h43

Bonjour, j'ai un petit souci, dans l'implementation de mon dao, je fais une query toute simple, et je ne sais pour quelle raison, elle ne passe pas car elle rajoute un champ DTYPE qui sort de nulle part???

La query est la suivante : select a from Approval a where a.icsrNumber = :icsrNumber

Et le résulat est le suivant :

EJB5018 : Une exception a été renvoyée lors d'un appel ejb sur [ApprovalDaoImpl].
javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; nested exception is: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b60e-fcs (12/23/2008))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-00904: "T0"."DTYPE": invalid identifier
Error Code: 904
Call: SELECT t0.TRACKING_NO, t0.DTYPE, t0.CT_ICSR_TYPE, t0.CT_ICSR_NR, t0.FILE_ENCODING, t0.ERR_STATUS, t0.ICSR_CURRENT_NO, t0.ERR_TRACKING_NO, t0.APP_TRACKING_NO, t0.GATEWAY_TYPE, t0.FILENAME, t0.RECEIVER_NO, t0.SENDER_NO, t0.STAGE_NO, t0.TRACKING_DATETIME, t0.CT_ICSR_LRD, t0.USER_NO, t1.TRACKING_NO, t1.APPROVAL_NARRATIVE, t1.APPROVED_SWITCH, t1.APPROVAL_DATETIME, t1.USER_NO FROM ICSR.ICSR_TRACKING t0, ICSR.ICSR_APPROVAL t1 WHERE ((t0.ICSR_CURRENT_NO = ?) AND ((t1.TRACKING_NO = t0.TRACKING_NO) AND (t0.DTYPE = ?)))
bind => [7051, Approval]
Query: ReportQuery(com.icsr.domain.Approval)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b60e-fcs (12/23/2008))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-00904: "T0"."DTYPE": invalid identifier
Error Code: 904
Call: SELECT t0.TRACKING_NO, t0.DTYPE, t0.CT_ICSR_TYPE, t0.CT_ICSR_NR, t0.FILE_ENCODING, t0.ERR_STATUS, t0.ICSR_CURRENT_NO, t0.ERR_TRACKING_NO, t0.APP_TRACKING_NO, t0.GATEWAY_TYPE, t0.FILENAME, t0.RECEIVER_NO, t0.SENDER_NO, t0.STAGE_NO, t0.TRACKING_DATETIME, t0.CT_ICSR_LRD, t0.USER_NO, t1.TRACKING_NO, t1.APPROVAL_NARRATIVE, t1.APPROVED_SWITCH, t1.APPROVAL_DATETIME, t1.USER_NO FROM ICSR.ICSR_TRACKING t0, ICSR.ICSR_APPROVAL t1 WHERE ((t0.ICSR_CURRENT_NO = ?) AND ((t1.TRACKING_NO = t0.TRACKING_NO) AND (t0.DTYPE = ?)))
bind => [7051, Approval]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
package com.icsr.dao.impl;
 
import com.icsr.dao.ApprovalDao;
import com.icsr.domain.Approval;
import java.util.ArrayList;
import java.util.List;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.NoResultException;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
 
@Stateless
public class ApprovalDaoImpl implements ApprovalDao
{
    @PersistenceContext(name="icsr")
    private EntityManager entityManager;
 
    public void delete(Approval entity)
    {
        Approval approval = entityManager.find(Approval.class, entity.getTrackingNumber());
        entityManager.remove(approval);
    }
 
    public ArrayList<Approval> list()
    {
        List<Approval> roles = null;
        try
        {
            Query query = entityManager.createQuery("select r from ROLE r");
            roles = query.getResultList();
        }
        catch(NoResultException exception)
        {
            return null;
        }
        return new ArrayList<Approval>(roles);
    }
 
    public Approval lookFor(Object id)
    {
        return entityManager.find(Approval.class, (Integer)id);      
    }
 
    public Approval reload(Approval entity)
    {
        Approval approval = entityManager.find(Approval.class, entity.getTrackingNumber());
        entityManager.refresh(approval);
        return approval;
    }
 
    public Object save(Approval entity)
    {
        entityManager.persist(entity);
        return (Integer)entity.getTrackingNumber();
    }
 
    public Approval update(Approval entity)
    {
        return entityManager.merge(entity);
    }
    public boolean approvalExists(int icsrNumber) throws Exception
    {
        try
        {
            Query query = entityManager.createQuery("select a from Approval a where a.icsrNumber = :icsrNumber");
            query.setParameter("icsrNumber", icsrNumber);
            List<Approval> approvals = query.getResultList();
            return true;
        }
        catch(NoResultException exception)
        {
            return false;
        }
    }
 
    public ArrayList<Approval> getApprovalsByIcsrNumber(int icsrNumber) throws Exception
    {
        try
        {
            Query query = entityManager.createQuery("select a from Approval a where a.icsrNumber = :icsrNumber");
            query.setParameter("icsrNumber", icsrNumber);
            return new ArrayList<Approval>(query.getResultList());
        }
        catch(NoResultException exception)
        {
            return null;
        }        
    }
 
    public ArrayList<Approval> getApprovalsByUserNumber(String userNumber) throws Exception
    {
        try
        {
            Query query = entityManager.createQuery("select a from Approval a where a.userNumber = :userNumber");
            query.setParameter("userNumber", userNumber);
            return new ArrayList<Approval>(query.getResultList());
        }
        catch(NoResultException exception)
        {
            return null;
        }
    }
}

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
package com.icsr.domain;
 
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Table;
 
@Entity
@Table(name="ICSR_APPROVAL", schema="ICSR")
public class Approval extends Tracking implements Serializable
{
    private String approvalDateTime;
    private int approvedSwitch;
    private String approvalNarrative;
    private User approver;
 
    @Column(name="APPROVAL_DATETIME")
    public String getApprovalDateTime() {
        return approvalDateTime;
    }
 
    public void setApprovalDateTime(String approvalDateTime) {
        this.approvalDateTime = approvalDateTime;
    }
 
    @Column(name="APPROVAL_NARRATIVE")
    public String getApprovalNarrative() {
        return approvalNarrative;
    }
 
    public void setApprovalNarrative(String approvalNarrative) {
        this.approvalNarrative = approvalNarrative;
    }
 
    @Column(name="APPROVED_SWITCH")
    public int getApprovedSwitch() {
        return approvedSwitch;
    }
 
    public void setApprovedSwitch(int approvedSwitch) {
        this.approvedSwitch = approvedSwitch;
    }
 
    @ManyToOne
    @JoinColumn(name="USER_NO")
    public User getApprover() {
        return approver;
    }
 
    public void setApprover(User approver) {
        this.approver = approver;
    }
 
 
}

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
package com.icsr.domain;
 
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Inheritance;
import javax.persistence.InheritanceType;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
 
@Entity
@Table(name="ICSR_TRACKING", schema="ICSR")
@Inheritance(strategy=InheritanceType.JOINED)
public class Tracking implements Serializable
{
    private int icsrNumber;
    private int trackingNumber;
    private String trackingDateTime;
    private User user;
    private String empiricaNumber;
    private String empiricaDate;
    private int empiricaICSRType;
    private int stageNumber;
    private int errorStatus;
    private int errorTrackingNumber;
    private int applicationTrackingNumber;
    private String receiverNumber;
    private String fileName;
    private int gatewayType;
    private String senderNumber;
    private String fileEncoding;
 
    @Column(name="APP_TRACKING_NO")
    public int getApplicationTrackingNumber() {
        return applicationTrackingNumber;
    }
 
    public void setApplicationTrackingNumber(int applicationTrackingNumber) {
        this.applicationTrackingNumber = applicationTrackingNumber;
    }
 
    @Column(name="CT_ICSR_LRD")
    public String getEmpiricaDate() {
        return empiricaDate;
    }
 
    public void setEmpiricaDate(String empiricaDate) {
        this.empiricaDate = empiricaDate;
    }
 
    @Column(name="CT_ICSR_TYPE")
    public int getEmpiricaICSRType() {
        return empiricaICSRType;
    }
 
    public void setEmpiricaICSRType(int empiricaICSRType) {
        this.empiricaICSRType = empiricaICSRType;
    }
 
    @Column(name="CT_ICSR_NR")
    public String getEmpiricaNumber() {
        return empiricaNumber;
    }
 
    public void setEmpiricaNumber(String empiricaNumber) {
        this.empiricaNumber = empiricaNumber;
    }
 
    @Column(name="ERR_STATUS")
    public int getErrorStatus() {
        return errorStatus;
    }
 
    public void setErrorStatus(int errorStatus) {
        this.errorStatus = errorStatus;
    }
 
    @Column(name="ERR_TRACKING_NO")
    public int getErrorTrackingNumber() {
        return errorTrackingNumber;
    }
 
    public void setErrorTrackingNumber(int errorTrackingNumber) {
        this.errorTrackingNumber = errorTrackingNumber;
    }
 
    @Column(name="FILE_ENCODING")
    public String getFileEncoding() {
        return fileEncoding;
    }
 
    public void setFileEncoding(String fileEncoding) {
        this.fileEncoding = fileEncoding;
    }
 
    @Column(name="FILENAME")
    public String getFileName() {
        return fileName;
    }
 
    public void setFileName(String fileName) {
        this.fileName = fileName;
    }
 
    @Column(name="GATEWAY_TYPE")
    public int getGatewayType() {
        return gatewayType;
    }
 
    public void setGatewayType(int gatewayType) {
        this.gatewayType = gatewayType;
    }
 
    @Column(name="ICSR_CURRENT_NO")
    public int getIcsrNumber() {
        return icsrNumber;
    }
 
    public void setIcsrNumber(int icsrNumber) {
        this.icsrNumber = icsrNumber;
    }
 
    @Column(name="RECEIVER_NO")
    public String getReceiverNumber() {
        return receiverNumber;
    }
 
    public void setReceiverNumber(String receiverNumber) {
        this.receiverNumber = receiverNumber;
    }
 
    @Column(name="SENDER_NO")
    public String getSenderNumber() {
        return senderNumber;
    }
 
    public void setSenderNumber(String senderNumber) {
        this.senderNumber = senderNumber;
    }
 
    @Column(name="STAGE_NO")
    public int getStageNumber() {
        return stageNumber;
    }
 
    public void setStageNumber(int stageNumber) {
        this.stageNumber = stageNumber;
    }
 
    @Column(name="TRACKING_DATETIME")
    public String getTrackingDateTime() {
        return trackingDateTime;
    }
 
    public void setTrackingDateTime(String trackingDateTime) {
        this.trackingDateTime = trackingDateTime;
    }
 
    @Id
    @Column(name="TRACKING_NO")
    public int getTrackingNumber() {
        return trackingNumber;
    }
 
    public void setTrackingNumber(int trackingNumber) {
        this.trackingNumber = trackingNumber;
    }
 
    @ManyToOne
    @JoinColumn(name="USER_NO")
    public User getUser() {
        return user;
    }
 
    public void setUser(User user) {
        this.user = user;
    }
}

**longbeach** · 11/09/2009, 16h26

Je ne sais pas mais ça semble être specifique à TopLink :

"TopLink JPA creates a discriminator column named DTYPE to differentiate classes in an inheritance hierarchy"

J'espere t'avoir mis sur la bonne piste.

**Quartus** · 12/09/2009, 09h19

Un tout grand merci, c'est exactement cela !

J'avais finalement trouvé la solution par moi même, mais merci beaucoup !

champ DTYPE ajouté [EJB3]

Java EE

Vue hybride

Discussions similaires

Partager

Partager