Discussion :

[opamao93]

Salut la famille,

j'essaie de faire l'insertion dans une base de données a travers un API

Voici ce qui m'affiche comme erreur ::

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
 
Grave:   Exception while deploying the app [FonPaymoney]
Grave:   Exception during lifecycle processing
org.glassfish.deployment.common.DeploymentException: Exception [EclipseLink-28019] (Eclipse Persistence Services - 2.6.1.v20150605-31e8258): org.eclipse.persistence.exceptions.EntityManagerSetupException
Exception Description: Deployment of PersistenceUnit [FonPaymoneyPU] failed. Close all factories for this PersistenceUnit.
Internal Exception: Exception [EclipseLink-0] (Eclipse Persistence Services - 2.6.1.v20150605-31e8258): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing [INSERT INTO Operation o VALUE o.operationDatetime = :operationDatetime, o.operationFrais = :operationFrais, o.operationMontant = :operationMontant, o.operationRaison = :operationRaison, o.operationStaus = :operationStaus, o.compteidCompte.idCompte = :idCompte, o.genreOperationIdgenreOperation = :genreOperationIdgenreOperation, o.typeOperIdtypeOper = :typeOperIdtypeOper, o.numeropanier = :numeropanier]. 
[0, 403] The query does not start with a valid identifier, has to be either SELECT, UPDATE or DELETE FROM.
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.createDeployFailedPersistenceException(EntityManagerSetupImpl.java:869)
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:809)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337)
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303)
	at org.glassfish.persistence.jpa.JPADeployer$2.visitPUD(JPADeployer.java:451)
	at org.glassfish.persistence.jpa.JPADeployer$PersistenceUnitDescriptorIterator.iteratePUDs(JPADeployer.java:510)
	at org.glassfish.persistence.jpa.JPADeployer.iterateInitializedPUsAtApplicationPrepare(JPADeployer.java:492)
	at org.glassfish.persistence.jpa.JPADeployer.event(JPADeployer.java:398)
	at org.glassfish.kernel.event.EventsImpl.send(EventsImpl.java:131)
	at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:487)
	at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:219)
	at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:491)
	at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:539)
	at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:535)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:360)
	at com.sun.enterprise.v3.admin.CommandRunnerImpl$2.execute(CommandRunnerImpl.java:534)
	at com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:565)
	at com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:557)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:360)
	at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:556)
	at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1464)
	at com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1300(CommandRunnerImpl.java:109)
	at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1846)
	at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1722)
	at com.sun.enterprise.v3.admin.AdminAdapter.doCommand(AdminAdapter.java:534)
	at com.sun.enterprise.v3.admin.AdminAdapter.onMissingResource(AdminAdapter.java:224)
	at org.glassfish.grizzly.http.server.StaticHttpHandlerBase.service(StaticHttpHandlerBase.java:189)
	at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:459)
	at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:167)
	at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:206)
	at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:180)
	at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:235)
	at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:283)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:200)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:132)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:111)
	at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
	at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:536)
	at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:112)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:117)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:56)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:137)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:591)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:571)
	at java.lang.Thread.run(Thread.java:745)
 
Grave:   Exception while deploying the app [FonPaymoney] : Exception [EclipseLink-28019] (Eclipse Persistence Services - 2.6.1.v20150605-31e8258): org.eclipse.persistence.exceptions.EntityManagerSetupException
Exception Description: Deployment of PersistenceUnit [FonPaymoneyPU] failed. Close all factories for this PersistenceUnit.
Internal Exception: Exception [EclipseLink-0] (Eclipse Persistence Services - 2.6.1.v20150605-31e8258): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing [INSERT INTO Operation o VALUE o.operationDatetime = :operationDatetime, o.operationFrais = :operationFrais, o.operationMontant = :operationMontant, o.operationRaison = :operationRaison, o.operationStaus = :operationStaus, o.compteidCompte.idCompte = :idCompte, o.genreOperationIdgenreOperation = :genreOperationIdgenreOperation, o.typeOperIdtypeOper = :typeOperIdtypeOper, o.numeropanier = :numeropanier]. 
[0, 403] The query does not start with a valid identifier, has to be either SELECT, UPDATE or DELETE FROM.
Avertissement:

Aidez-moi si vous avez une idée ..!!!

[andry.aime]

Bonjour,

Code sql :

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

INSERT INTO Operation o VALUE o.operationDatetime = :operationDatetime, o.operationFrais = :operationFrais, o.operationMontant = :operationMontant, o.operationRaison = :operationRaison, o.operationStaus = :operationStaus, o.compteidCompte.idCompte = :idCompte, o.genreOperationIdgenreOperation = :genreOperationIdgenreOperation, o.typeOperIdtypeOper = :typeOperIdtypeOper, o.numeropanier = :numeropanier

Cette instruction n'est pas bonne. http://sqlpro.developpez.com/cours/sqlaz/dml/

Je pense que tu as tenté d'exécuter une requête sql native comme JPQL. Mais sans ton code

A+.

[OButterlin]

D'autant que même en mode natif la requête est fausse.
Une requête d'insert ressemble à ceci

Code :

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

1
2
3
 
INSERT INTO NomTable [(champ1, champ2, ..., champN)] 
VALUES(val1, val2, ..., valN)

[opamao93]

Merci mais je maitrise pas le requette de cette voici ce que j'ai mis :

Code :

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

INSERT INTO Operation o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison, o.operationStaus, o.compteidCompte.idCompte, o.genreOperationIdgenreOperation, o.typeOperIdtypeOper, o.numeropanier) VALUE (:operationDatetime, :operationFrais, :operationMontant, :operationRaison, :operationStaus, :idCompte, :genreOperationIdgenreOperation, :typeOperIdtypeOper,  :numeropanier)

On me mets :

Code :

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

1
2
3
4
5
6
Grave:   Exception while deploying the app [FonPaymoney] : Exception [EclipseLink-28019] (Eclipse Persistence Services - 2.6.1.v20150605-31e8258): org.eclipse.persistence.exceptions.EntityManagerSetupException
Exception Description: Deployment of PersistenceUnit [FonPaymoneyPU] failed. Close all factories for this PersistenceUnit.
Internal Exception: Exception [EclipseLink-0] (Eclipse Persistence Services - 2.6.1.v20150605-31e8258): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing [INSERT INTO Operation o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison, o.operationStaus, o.compteidCompte.idCompte, o.genreOperationIdgenreOperation, o.typeOperIdtypeOper, o.numeropanier) VALUE (:operationDatetime, :operationFrais,  :operationMontant, :operationRaison, :operationStaus, :idCompte,  :genreOperationIdgenreOperation,  :typeOperIdtypeOper,  :numeropanier)]. 
[0, 401] The query does not start with a valid identifier, has to be either SELECT, UPDATE or DELETE FROM.
Avertissement:

[andry.aime]

VALUES avec un "S".
Ensuite, comme je disais, tu as exécuté une requête SQL natif comme JPQL. Peut-on voir ton code?

A+.

[opamao93]

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
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
 
/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.compagny.fonpaymoney;
 
import java.io.Serializable;
import java.util.Date;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.Lob;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;
import javax.xml.bind.annotation.XmlRootElement;
 
/**
 *
 * @author Théodore YAPI
 */
@Entity
@Table(name = "operation")
@XmlRootElement
@NamedQueries({
    @NamedQuery(name = "Operation.findAll", query = "SELECT o FROM Operation o WHERE o.compteidCompte.idCompte = :idCompte ORDER BY o.idOperation DESC")
    , @NamedQuery(name = "Operation.findByIdOperation", query = "SELECT o FROM Operation o WHERE o.idOperation = :idOperation")
    , @NamedQuery(name = "Operation.findByOperationDatetime", query = "SELECT o FROM Operation o WHERE o.operationDatetime = :operationDatetime")
    , @NamedQuery(name = "Operation.findByOperationFrais", query = "SELECT o FROM Operation o WHERE o.operationFrais = :operationFrais")
    , @NamedQuery(name = "Operation.findByOperationRaison", query = "SELECT o FROM Operation o WHERE o.operationRaison = :operationRaison")
    , @NamedQuery(name = "Operation.findByOperationStaus", query = "SELECT o FROM Operation o WHERE o.operationStaus = :operationStaus")
    , @NamedQuery(name = "Operation.findByPin", query = "SELECT o FROM Operation o WHERE o.pin = :pin")
    , @NamedQuery(name = "Operation.findByTok", query = "SELECT o FROM Operation o WHERE o.tok = :tok")
    , @NamedQuery(name = "Operation.findByNumeropanier", query = "SELECT o FROM Operation o WHERE o.numeropanier = :numeropanier")
    , @NamedQuery(name = "Operation.findByTypeDeJeux", query = "SELECT o FROM Operation o WHERE o.typeDeJeux = :typeDeJeux")
    , @NamedQuery(name = "Operation.findByVendor", query = "SELECT o FROM Operation o WHERE o.vendor = :vendor")
    , @NamedQuery(name = "Operation.findByEcomType", query = "SELECT o FROM Operation o WHERE o.ecomType = :ecomType")
    , @NamedQuery(name = "Operation.findByPos", query = "INSERT INTO Operation o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison, o.operationStaus, o.compteidCompte.idCompte, o.genreOperationIdgenreOperation, o.typeOperIdtypeOper, o.numeropanier) VALUES (:operationDatetime, :operationFrais, :operationMontant, :operationRaison, :operationStaus, :idCompte, :genreOperationIdgenreOperation,  :typeOperIdtypeOper,  :numeropanier)")
    , @NamedQuery(name = "Operation.findByRib", query = "SELECT o FROM Operation o WHERE o.rib = :rib")})
public class Operation implements Serializable {
 
    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Basic(optional = false)
    @Column(name = "idOperation")
    private Integer idOperation;
    @Column(name = "operationDatetime")
    @Temporal(TemporalType.TIMESTAMP)
    private Date operationDatetime;
    @Size(max = 255)
    @Column(name = "operationFrais")
    private String operationFrais;
    @Lob
    @Size(max = 65535)
    @Column(name = "operationMontant")
    private String operationMontant;
    @Size(max = 255)
    @Column(name = "operationRaison")
    private String operationRaison;
    @Basic(optional = false)
    @NotNull
    @Column(name = "operationStaus")
    private int operationStaus;
    @Size(max = 255)
    @Column(name = "pin")
    private String pin;
    @Size(max = 255)
    @Column(name = "tok")
    private String tok;
    @Size(max = 255)
    @Column(name = "numeropanier")
    private String numeropanier;
    @Size(max = 255)
    @Column(name = "type_de_jeux")
    private String typeDeJeux;
    @Size(max = 255)
    @Column(name = "vendor")
    private String vendor;
    @Size(max = 255)
    @Column(name = "ecom_type")
    private String ecomType;
    @Size(max = 255)
    @Column(name = "pos")
    private String pos;
    @Size(max = 255)
    @Column(name = "rib")
    private String rib;
    @JoinColumn(name = "type_oper_idtype_oper", referencedColumnName = "idtype_oper")
    @ManyToOne
    private TypeOper typeOperIdtypeOper;
    @JoinColumn(name = "genre_operation_idgenre_operation", referencedColumnName = "idgenre_operation")
    @ManyToOne
    private GenreOperation genreOperationIdgenreOperation;
    @JoinColumn(name = "Compte_idCompte", referencedColumnName = "idCompte")
    @ManyToOne
    private Compte compteidCompte;
 
    public Operation() {
    }
 
    public Operation(Integer idOperation) {
        this.idOperation = idOperation;
    }
 
    public Operation(Integer idOperation, int operationStaus) {
        this.idOperation = idOperation;
        this.operationStaus = operationStaus;
    }
 
    public Integer getIdOperation() {
        return idOperation;
    }
 
    public void setIdOperation(Integer idOperation) {
        this.idOperation = idOperation;
    }
 
    public Date getOperationDatetime() {
        return operationDatetime;
    }
 
    public void setOperationDatetime(Date operationDatetime) {
        this.operationDatetime = operationDatetime;
    }
 
    public String getOperationFrais() {
        return operationFrais;
    }
 
    public void setOperationFrais(String operationFrais) {
        this.operationFrais = operationFrais;
    }
 
    public String getOperationMontant() {
        return operationMontant;
    }
 
    public void setOperationMontant(String operationMontant) {
        this.operationMontant = operationMontant;
    }
 
    public String getOperationRaison() {
        return operationRaison;
    }
 
    public void setOperationRaison(String operationRaison) {
        this.operationRaison = operationRaison;
    }
 
    public int getOperationStaus() {
        return operationStaus;
    }
 
    public void setOperationStaus(int operationStaus) {
        this.operationStaus = operationStaus;
    }
 
    public String getPin() {
        return pin;
    }
 
    public void setPin(String pin) {
        this.pin = pin;
    }
 
    public String getTok() {
        return tok;
    }
 
    public void setTok(String tok) {
        this.tok = tok;
    }
 
    public String getNumeropanier() {
        return numeropanier;
    }
 
    public void setNumeropanier(String numeropanier) {
        this.numeropanier = numeropanier;
    }
 
    public String getTypeDeJeux() {
        return typeDeJeux;
    }
 
    public void setTypeDeJeux(String typeDeJeux) {
        this.typeDeJeux = typeDeJeux;
    }
 
    public String getVendor() {
        return vendor;
    }
 
    public void setVendor(String vendor) {
        this.vendor = vendor;
    }
 
    public String getEcomType() {
        return ecomType;
    }
 
    public void setEcomType(String ecomType) {
        this.ecomType = ecomType;
    }
 
    public String getPos() {
        return pos;
    }
 
    public void setPos(String pos) {
        this.pos = pos;
    }
 
    public String getRib() {
        return rib;
    }
 
    public void setRib(String rib) {
        this.rib = rib;
    }
 
    public TypeOper getTypeOperIdtypeOper() {
        return typeOperIdtypeOper;
    }
 
    public void setTypeOperIdtypeOper(TypeOper typeOperIdtypeOper) {
        this.typeOperIdtypeOper = typeOperIdtypeOper;
    }
 
    public GenreOperation getGenreOperationIdgenreOperation() {
        return genreOperationIdgenreOperation;
    }
 
    public void setGenreOperationIdgenreOperation(GenreOperation genreOperationIdgenreOperation) {
        this.genreOperationIdgenreOperation = genreOperationIdgenreOperation;
    }
 
    public Compte getCompteidCompte() {
        return compteidCompte;
    }
 
    public void setCompteidCompte(Compte compteidCompte) {
        this.compteidCompte = compteidCompte;
    }
 
    @Override
    public int hashCode() {
        int hash = 0;
        hash += (idOperation != null ? idOperation.hashCode() : 0);
        return hash;
    }
 
    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Operation)) {
            return false;
        }
        Operation other = (Operation) object;
        if ((this.idOperation == null && other.idOperation != null) || (this.idOperation != null && !this.idOperation.equals(other.idOperation))) {
            return false;
        }
        return true;
    }
 
    @Override
    public String toString() {
        return "com.compagny.fonpaymoney.Operation[ idOperation=" + idOperation + " ]";
    }
 
}

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
 
@GET
    @Path("client/{operationDatetime}/{operationFrais}/{operationMontant}/{operationRaison}/"
            + "{operationStaus}/{idCompte}/{genreOperationIdgenreOperation}/{typeOperIdtypeOper}/"
            + "{numeropanier}")
    @Produces({MediaType.APPLICATION_XML, MediaType.APPLICATION_JSON})
    public int findByPos(@PathParam("operationDatetime") Date operationDatetime, 
            @PathParam("operationFrais") String operationFrais, 
            @PathParam("operationMontant") String operationMontant, 
            @PathParam("operationRaison") String operationRaison, 
            @PathParam("operationStaus") Integer operationStaus, 
            @PathParam("idCompte") Integer idCompte,
            @PathParam("genreOperationIdgenreOperation") Integer genreOperationIdgenreOperation, 
            @PathParam("typeOperIdtypeOper") Integer typeOperIdtypeOper,
            @PathParam("numeropanier") String numeropanier) {
        return em.createNamedQuery("Operation.findByPos")
                .setParameter("operationDatetime", operationDatetime)
                .setParameter("operationFrais", operationFrais)
                .setParameter("operationMontant", operationMontant)
                .setParameter("operationRaison", operationRaison)
                .setParameter("operationStaus", operationStaus)
                .setParameter("idCompte", idCompte)
                .setParameter("genreOperationIdgenreOperation", genreOperationIdgenreOperation)
                .setParameter("typeOperIdtypeOper", typeOperIdtypeOper)
                .setParameter("numeropanier", numeropanier)
                .executeUpdate();
    }

[andry.aime]

Tu ne peux pas faire un Insert avec du JPQL. Et n'utilise pas de nom de methode "findBy*" pour faire une insertion, c'est pas logique.

Code :

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

1
2
3
4
Operation operation = new Operation();
operation.setOperationDatetime(operationDatetime);
...
em.persist(operation);

Si tu veux utiliser un sql

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
private static final INSERT_OPERATION_QUERY="INSERT INTO Operation o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison, o.operationStaus, o.compteidCompte.idCompte, o.genreOperationIdgenreOperation, o.typeOperIdtypeOper, o.numeropanier) VALUES (:operationDatetime, :operationFrais, :operationMontant, :operationRaison, :operationStaus, :idCompte, :genreOperationIdgenreOperation,  :typeOperIdtypeOper,  :numeropanier)";
 
 public int saveOperation(@PathParam("operationDatetime") Date operationDatetime, 
            @PathParam("operationFrais") String operationFrais, 
            @PathParam("operationMontant") String operationMontant, 
            @PathParam("operationRaison") String operationRaison, 
            @PathParam("operationStaus") Integer operationStaus, 
            @PathParam("idCompte") Integer idCompte,
            @PathParam("genreOperationIdgenreOperation") Integer genreOperationIdgenreOperation, 
            @PathParam("typeOperIdtypeOper") Integer typeOperIdtypeOper,
            @PathParam("numeropanier") String numeropanier) {
        return em.createNativeQuery(INSERT_OPERATION_QUERY)   // createNativeQuery pour un SQL natif
                .setParameter("operationDatetime", operationDatetime)
                .setParameter("operationFrais", operationFrais)
                .setParameter("operationMontant", operationMontant)
                .setParameter("operationRaison", operationRaison)
                .setParameter("operationStaus", operationStaus)
                .setParameter("idCompte", idCompte)
                .setParameter("genreOperationIdgenreOperation", genreOperationIdgenreOperation)
                .setParameter("typeOperIdtypeOper", typeOperIdtypeOper)
                .setParameter("numeropanier", numeropanier)
                .executeUpdate();
    }

A+.

[opamao93]

Il m'affiche les memes errers je peux pas avoir un example prcis

[andry.aime]

Je ne pense pas que tu auras cette erreur avec l'un des deux codes proposés. Tu nous montres ton code et ton persistence.xml?

A+.

[OButterlin]

Code :

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

INSERT INTO Operation o ... 

Si Operation est le nom physique de ta table et que tu es dans le bon schema, ça devrait fonctionner (encore que j'ai un doute avec le préfixe des colonnes)
Si par contre c'est l'entity et qu'il n'y a pas de rapport entre le nom de la classe et le nom de la table, ça ne fonctionnera pas.

Une requête native d'insert typique ressemble à ceci

Code :

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

1
2
INSERT INTO NomSchema.NomTable(col1, col2, ..., colN) 
VALUES(val1, val2, ..., valN)

[opamao93]

Salut, j'suis pas trop sur qu'il y a rapport entre le nom de la classe et la table

le nom de la table est "operation" et la classe "Operation"

[andry.aime]

As-tu essayé avec:

Code :

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

1
2
3
4
Operation operation = new Operation();
operation.setOperationDatetime(operationDatetime);
...
em.persist(operation);

?

Et peut-on voir le code qui ne fonctionne pas avec les erreurs qui vont avec?

A+.

[opamao93]

Au faite cette methode va me permettre de faire quoi exactement et comment je procede avec cette methode

je viens d'essayer ta methode ::

Code :

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
Operation operation = new Operation();
 
        operation.setOperationDatetime(operationDatetime);
        operation.setOperationFrais(operationFrais);
        operation.setOperationMontant(operationMontant);
        operation.setOperationRaison(operationRaison);
        operation.setOperationStaus(operationStaus);
        operation.setCompteidCompte(idCompte);
        operation.setGenreOperationIdgenreOperation(genreOperationIdgenreOperation);
        operation.setTypeOperIdtypeOper(typeOperIdtypeOper);
        operation.setNumeropanier(numeropanier);
 
        em.persist(operation);

Concernant :

Code :

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

operation.setCompteidCompte(idCompte);

il dit earreur de :

Code :

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

java.lang.RuntimeException: Uncompilable source code - Erroneous sym type: com.compagny.fonpaymoney.Operation.setCompteidCompte

Puis que j'ai associé l'id de ma table Compte a la table Opeartion je fais comment pour recuperer

Merci !!!

[andry.aime]

Ce code permet d'enregistrer l'operation dans la base.

Parce que setCompteidCompte attend un objet de type Compte comme paramètre mais pas un Integer. :

Code :

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

public void setCompteidCompte(Compte compteidCompte)

A+.

[andry.aime]

Sinon, peut on voir aussi le code que tu as utilisé avec la requête SQL qui ne fonctionnait pas?

A+.

[opamao93]

Voici mon code :

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
 
@GET
    @Path("client/{operationDatetime}/{operationFrais}/{operationMontant}/{operationRaison}/"
            + "{operationStaus}/{idCompte}/{genreOperationIdgenreOperation}/{typeOperIdtypeOper}/"
            + "{numeropanier}")
    @Produces({MediaType.APPLICATION_XML, MediaType.APPLICATION_JSON})
    public int operation(@PathParam("operationDatetime") Date operationDatetime,
            @PathParam("operationFrais") String operationFrais,
            @PathParam("operationMontant") String operationMontant,
            @PathParam("operationRaison") String operationRaison,
            @PathParam("operationStaus") Integer operationStaus,
            @PathParam("idCompte") Integer idCompte,
            @PathParam("genreOperationIdgenreOperation") Integer genreOperationIdgenreOperation,
            @PathParam("typeOperIdtypeOper") Integer typeOperIdtypeOper,
            @PathParam("numeropanier") String numeropanier) {
 
        return em.createNamedQuery("INSERT INTO Operation o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison, o.operationStaus, o.compteidCompte.idCompte, o.genreOperationIdgenreOperation, o.typeOperIdtypeOper, o.numeropanier) "
                + "VALUES (:operationDatetime, :operationFrais, :operationMontant, :operationRaison, :operationStaus, :idCompte, :genreOperationIdgenreOperation,  :typeOperIdtypeOper,  :numeropanier)")
                .setParameter("operationDatetime", operationDatetime)
                .setParameter("operationFrais", operationFrais)
                .setParameter("operationMontant", operationMontant)
                .setParameter("operationRaison", operationRaison)
                .setParameter("operationStaus", operationStaus)
                .setParameter("idCompte", idCompte)
                .setParameter("genreOperationIdgenreOperation", genreOperationIdgenreOperation)
                .setParameter("typeOperIdtypeOper", typeOperIdtypeOper)
                .setParameter("numeropanier", numeropanier)
                .executeUpdate();
    }

[andry.aime]

Tu as mal lu le code que je t'ai donné, createNativeQuery mais pas createNamedQuery.

A+.

[opamao93]

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
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
Avertissement:   Local Exception Stack: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.1.v20150605-31e8258): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Erreur de syntaxe près de 'o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison,' à la ligne 1
Error Code: 1064
Call: INSERT INTO Operation o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison, o.operationStaus, o.compteidCompte.idCompte, o.genreOperationIdgenreOperation, o.typeOperIdtypeOper, o.numeropanier) VALUES (:operationDatetime, :operationFrais, :operationMontant, :operationRaison, :operationStaus, :idCompte, :genreOperationIdgenreOperation,  :typeOperIdtypeOper,  :numeropanier)
Query: DataModifyQuery(sql="INSERT INTO Operation o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison, o.operationStaus, o.compteidCompte.idCompte, o.genreOperationIdgenreOperation, o.typeOperIdtypeOper, o.numeropanier) VALUES (:operationDatetime, :operationFrais, :operationMontant, :operationRaison, :operationStaus, :idCompte, :genreOperationIdgenreOperation,  :typeOperIdtypeOper,  :numeropanier)")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:902)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:964)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:633)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055)
	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:306)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:271)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:251)
	at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:85)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:298)
	at com.compagny.fonpaymoney.service.OperationFacadeREST.operation(OperationFacadeREST.java:126)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1081)
	at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1153)
	at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:4786)
	at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:656)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
	at org.jboss.weld.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:52)
	at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doCall(SystemInterceptorProxy.java:163)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:140)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:369)
	at com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:4758)
	at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4746)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:212)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)
	at com.sun.proxy.$Proxy608.operation(Unknown Source)
	at com.compagny.fonpaymoney.service.__EJB31_Generated__OperationFacadeREST__Intf____Bean__.operation(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
	at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
	at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:309)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:292)
	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1139)
	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:460)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:386)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:334)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:221)
	at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1682)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:318)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:734)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:673)
	at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:174)
	at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:416)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:283)
	at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:459)
	at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:167)
	at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:206)
	at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:180)
	at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:235)
	at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:283)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:200)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:132)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:111)
	at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
	at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:536)
	at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:112)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:117)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:56)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:137)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:591)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:571)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Erreur de syntaxe près de 'o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison,' à la ligne 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:892)
	... 104 more
 
Avertissement:   A system exception occurred during an invocation on EJB OperationFacadeREST, method: public int com.compagny.fonpaymoney.service.OperationFacadeREST.operation(java.sql.Date,java.lang.String,java.lang.String,java.lang.String,java.lang.Integer,java.lang.Integer,java.lang.Integer,java.lang.Integer,java.lang.String)
Avertissement:   javax.ejb.EJBException
	at com.sun.ejb.containers.EJBContainerTransactionManager.processSystemException(EJBContainerTransactionManager.java:752)
	at com.sun.ejb.containers.EJBContainerTransactionManager.completeNewTx(EJBContainerTransactionManager.java:702)
	at com.sun.ejb.containers.EJBContainerTransactionManager.postInvokeTx(EJBContainerTransactionManager.java:507)
	at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:4566)
	at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:2074)
	at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:2044)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:220)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)
	at com.sun.proxy.$Proxy608.operation(Unknown Source)
	at com.compagny.fonpaymoney.service.__EJB31_Generated__OperationFacadeREST__Intf____Bean__.operation(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
	at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
	at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:309)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:292)
	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1139)
	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:460)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:386)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:334)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:221)
	at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1682)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:318)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:734)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:673)
	at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:174)
	at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:416)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:283)
	at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:459)
	at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:167)
	at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:206)
	at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:180)
	at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:235)
	at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:283)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:200)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:132)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:111)
	at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
	at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:536)
	at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:112)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:117)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:56)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:137)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:591)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:571)
	at java.lang.Thread.run(Thread.java:745)
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.1.v20150605-31e8258): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Erreur de syntaxe près de 'o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison,' à la ligne 1
Error Code: 1064
Call: INSERT INTO Operation o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison, o.operationStaus, o.compteidCompte.idCompte, o.genreOperationIdgenreOperation, o.typeOperIdtypeOper, o.numeropanier) VALUES (:operationDatetime, :operationFrais, :operationMontant, :operationRaison, :operationStaus, :idCompte, :genreOperationIdgenreOperation,  :typeOperIdtypeOper,  :numeropanier)
Query: DataModifyQuery(sql="INSERT INTO Operation o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison, o.operationStaus, o.compteidCompte.idCompte, o.genreOperationIdgenreOperation, o.typeOperIdtypeOper, o.numeropanier) VALUES (:operationDatetime, :operationFrais, :operationMontant, :operationRaison, :operationStaus, :idCompte, :genreOperationIdgenreOperation,  :typeOperIdtypeOper,  :numeropanier)")
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:308)
	at com.compagny.fonpaymoney.service.OperationFacadeREST.operation(OperationFacadeREST.java:126)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1081)
	at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1153)
	at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:4786)
	at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:656)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
	at org.jboss.weld.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:52)
	at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doCall(SystemInterceptorProxy.java:163)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:140)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:369)
	at com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:4758)
	at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4746)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:212)
	... 56 more
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.1.v20150605-31e8258): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Erreur de syntaxe près de 'o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison,' à la ligne 1
Error Code: 1064
Call: INSERT INTO Operation o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison, o.operationStaus, o.compteidCompte.idCompte, o.genreOperationIdgenreOperation, o.typeOperIdtypeOper, o.numeropanier) VALUES (:operationDatetime, :operationFrais, :operationMontant, :operationRaison, :operationStaus, :idCompte, :genreOperationIdgenreOperation,  :typeOperIdtypeOper,  :numeropanier)
Query: DataModifyQuery(sql="INSERT INTO Operation o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison, o.operationStaus, o.compteidCompte.idCompte, o.genreOperationIdgenreOperation, o.typeOperIdtypeOper, o.numeropanier) VALUES (:operationDatetime, :operationFrais, :operationMontant, :operationRaison, :operationStaus, :idCompte, :genreOperationIdgenreOperation,  :typeOperIdtypeOper,  :numeropanier)")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:902)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:964)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:633)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055)
	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:306)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:271)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:251)
	at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:85)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:298)
	... 87 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Erreur de syntaxe près de 'o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison,' à la ligne 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:892)
	... 104 more
 
Avertissement:   StandardWrapperValve[com.compagny.fonpaymoney.service.ApplicationConfig]: Servlet.service() for servlet com.compagny.fonpaymoney.service.ApplicationConfig threw exception
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Erreur de syntaxe près de 'o (o.operationDatetime, o.operationFrais, o.operationMontant, o.operationRaison,' à la ligne 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:892)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:964)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:633)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055)
	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:306)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:271)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:251)
	at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:85)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:298)
	at com.compagny.fonpaymoney.service.OperationFacadeREST.operation(OperationFacadeREST.java:126)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1081)
	at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1153)
	at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:4786)
	at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:656)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
	at org.jboss.weld.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:52)
	at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doCall(SystemInterceptorProxy.java:163)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:140)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:369)
	at com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:4758)
	at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4746)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:212)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)
	at com.sun.proxy.$Proxy608.operation(Unknown Source)
	at com.compagny.fonpaymoney.service.__EJB31_Generated__OperationFacadeREST__Intf____Bean__.operation(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
	at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
	at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:309)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:292)
	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1139)
	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:460)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:386)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:334)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:221)
	at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1682)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:318)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:734)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:673)
	at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:174)
	at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:416)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:283)
	at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:459)
	at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:167)
	at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:206)
	at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:180)
	at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:235)
	at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:283)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:200)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:132)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:111)
	at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
	at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:536)
	at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:112)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:117)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:56)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:137)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:591)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:571)
	at java.lang.Thread.run(Thread.java:745)

[andry.aime]

Vire les o. et o.compteidCompte.

Code sql :

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

1
2
INSERT INTO Operation  (operationDatetime, operationFrais, operationMontant, operationRaison, operationStaus, idCompte, genreOperationIdgenreOperation, typeOperIdtypeOper, numeropanier) "
                + "VALUES (:operationDatetime, :operationFrais, :operationMontant, :operationRaison, :operationStaus, :idCompte, :genreOperationIdgenreOperation,  :typeOperIdtypeOper,  :numeropanier)")

A+.

[andry.aime]

Pour l'autre méthode:

Code :

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

1
2
Compte compte = em.find(Compte.class, idCompte);
operation.setCompteidCompte(compte);

A+.