bad SQL grammar + Hibernate
SALUT,
j'ai l'exception suivante :
Code:
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
|
exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select intervenan0_.INTERVENANT_ID as INTERVEN1_0_, intervenan0_.INTERVENANT_NOM as INTERVEN2_0_, intervenan0_.INTERVENANT_PRENOM as INTERVEN3_0_, intervenan0_.INTERVENANT_LOGIN as INTERVEN4_0_, intervenan0_.INTERVENANT_MDP as INTERVEN5_0_, intervenan0_.INTERVENANT_EMAIL as INTERVEN6_0_, intervenan0_.INTERVENANT_TEL as INTERVEN7_0_, intervenan0_.INTERVENANT_FONCTION as INTERVEN8_0_, intervenan0_.INTERVENANT_DATEDEBUTCONTRAT as INTERVEN9_0_, intervenan0_.INTERVENANT_DATEFINCONTRAT as INTERVE10_0_, intervenan0_.COUTJOURNALIEREXPERIAN_ID as COUTJOU11_0_, intervenan0_.DROIT_ID as DROIT12_0_ from intervenant intervenan0_]; nested exception is java.sql.SQLException: Champ 'intervenan0_.INTERVENANT_ID' inconnu dans field list
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:406)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
cause mère
org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select intervenan0_.INTERVENANT_ID as INTERVEN1_0_, intervenan0_.INTERVENANT_NOM as INTERVEN2_0_, intervenan0_.INTERVENANT_PRENOM as INTERVEN3_0_, intervenan0_.INTERVENANT_LOGIN as INTERVEN4_0_, intervenan0_.INTERVENANT_MDP as INTERVEN5_0_, intervenan0_.INTERVENANT_EMAIL as INTERVEN6_0_, intervenan0_.INTERVENANT_TEL as INTERVEN7_0_, intervenan0_.INTERVENANT_FONCTION as INTERVEN8_0_, intervenan0_.INTERVENANT_DATEDEBUTCONTRAT as INTERVEN9_0_, intervenan0_.INTERVENANT_DATEFINCONTRAT as INTERVE10_0_, intervenan0_.COUTJOURNALIEREXPERIAN_ID as COUTJOU11_0_, intervenan0_.DROIT_ID as DROIT12_0_ from intervenant intervenan0_]; nested exception is java.sql.SQLException: Champ 'intervenan0_.INTERVENANT_ID' inconnu dans field list
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:223)
org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:371)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:836)
com.pia.agp.dao.DaoIntervenantImpl.getAll(DaoIntervenantImpl.java:25)
com.pia.agp.service.ServiceIntervenantImpl.getAll(ServiceIntervenantImpl.java:27)
com.pia.agp.web.AcceuilIntervenant.handleRequest(AcceuilIntervenant.java:31)
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
cause mère
java.sql.SQLException: Champ 'intervenan0_.INTERVENANT_ID' inconnu dans field list
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2917)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1566)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1661)
com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:928)
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1022)
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
org.hibernate.loader.Loader.doQuery(Loader.java:674)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
org.hibernate.loader.Loader.doList(Loader.java:2220)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
org.hibernate.loader.Loader.list(Loader.java:2099)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
org.springframework.orm.hibernate3.HibernateTemplate$31.doInHibernate(HibernateTemplate.java:853)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:836)
com.pia.agp.dao.DaoIntervenantImpl.getAll(DaoIntervenantImpl.java:25)
com.pia.agp.service.ServiceIntervenantImpl.getAll(ServiceIntervenantImpl.java:27)
com.pia.agp.web.AcceuilIntervenant.handleRequest(AcceuilIntervenant.java:31)
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803) |
ds ma table j'ai les champs suivants :
INTERVENANT_ID
INTERVENANT_NOM
...
j'ai utilisé middlegen pour me générer les fichiers de mapping, voila ce qui me donne pour ma table intervenant (c'est la ou il y a probleme).
le fichier Intervenant.java
Code:
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
| package com.pia.agp.mapping;
import java.io.Serializable;
import java.util.Date;
import org.apache.commons.lang.builder.ToStringBuilder;
/** @author Hibernate CodeGenerator */
public class Intervenant implements Serializable {
/** identifier field */
private Integer intervenantId;
/** nullable persistent field */
private String intervenantNom;
/** nullable persistent field */
private String intervenantPrenom;
/** nullable persistent field */
private String intervenantLogin;
/** nullable persistent field */
private String intervenantMdp;
/** nullable persistent field */
private String intervenantEmail;
/** nullable persistent field */
private String intervenantTel;
/** nullable persistent field */
private String intervenantFonction;
/** persistent field */
private Date intervenantDatedebutcontrat;
/** persistent field */
private Date intervenantDatefincontrat;
/** persistent field */
private String coutjournalierexperianId;
/** persistent field */
private long droitId;
/** full constructor */
public Intervenant(Integer intervenantId, String intervenantNom, String intervenantPrenom, String intervenantLogin, String intervenantMdp, String intervenantEmail, String intervenantTel, String intervenantFonction, Date intervenantDatedebutcontrat, Date intervenantDatefincontrat, String coutjournalierexperianId, long droitId) {
this.intervenantId = intervenantId;
this.intervenantNom = intervenantNom;
this.intervenantPrenom = intervenantPrenom;
this.intervenantLogin = intervenantLogin;
this.intervenantMdp = intervenantMdp;
this.intervenantEmail = intervenantEmail;
this.intervenantTel = intervenantTel;
this.intervenantFonction = intervenantFonction;
this.intervenantDatedebutcontrat = intervenantDatedebutcontrat;
this.intervenantDatefincontrat = intervenantDatefincontrat;
this.coutjournalierexperianId = coutjournalierexperianId;
this.droitId = droitId;
}
/** default constructor */
public Intervenant() {
}
/** minimal constructor */
public Intervenant(Integer intervenantId, Date intervenantDatedebutcontrat, Date intervenantDatefincontrat, String coutjournalierexperianId, long droitId) {
this.intervenantId = intervenantId;
this.intervenantDatedebutcontrat = intervenantDatedebutcontrat;
this.intervenantDatefincontrat = intervenantDatefincontrat;
this.coutjournalierexperianId = coutjournalierexperianId;
this.droitId = droitId;
}
public Integer getIntervenantId() {
return this.intervenantId;
}
public void setIntervenantId(Integer intervenantId) {
this.intervenantId = intervenantId;
}
public String getIntervenantNom() {
return this.intervenantNom;
}
public void setIntervenantNom(String intervenantNom) {
this.intervenantNom = intervenantNom;
}
public String getIntervenantPrenom() {
return this.intervenantPrenom;
}
public void setIntervenantPrenom(String intervenantPrenom) {
this.intervenantPrenom = intervenantPrenom;
}
public String getIntervenantLogin() {
return this.intervenantLogin;
}
public void setIntervenantLogin(String intervenantLogin) {
this.intervenantLogin = intervenantLogin;
}
public String getIntervenantMdp() {
return this.intervenantMdp;
}
public void setIntervenantMdp(String intervenantMdp) {
this.intervenantMdp = intervenantMdp;
}
public String getIntervenantEmail() {
return this.intervenantEmail;
}
public void setIntervenantEmail(String intervenantEmail) {
this.intervenantEmail = intervenantEmail;
}
public String getIntervenantTel() {
return this.intervenantTel;
}
public void setIntervenantTel(String intervenantTel) {
this.intervenantTel = intervenantTel;
}
public String getIntervenantFonction() {
return this.intervenantFonction;
}
public void setIntervenantFonction(String intervenantFonction) {
this.intervenantFonction = intervenantFonction;
}
public Date getIntervenantDatedebutcontrat() {
return this.intervenantDatedebutcontrat;
}
public void setIntervenantDatedebutcontrat(Date intervenantDatedebutcontrat) {
this.intervenantDatedebutcontrat = intervenantDatedebutcontrat;
}
public Date getIntervenantDatefincontrat() {
return this.intervenantDatefincontrat;
}
public void setIntervenantDatefincontrat(Date intervenantDatefincontrat) {
this.intervenantDatefincontrat = intervenantDatefincontrat;
}
public String getCoutjournalierexperianId() {
return this.coutjournalierexperianId;
}
public void setCoutjournalierexperianId(String coutjournalierexperianId) {
this.coutjournalierexperianId = coutjournalierexperianId;
}
public long getDroitId() {
return this.droitId;
}
public void setDroitId(long droitId) {
this.droitId = droitId;
}
public String toString() {
return new ToStringBuilder(this)
.append("intervenantId", getIntervenantId())
.toString();
}
} |
et pour le fichier hmb.xml
Code:
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
| <?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
<!--
Created by the Middlegen Hibernate plugin 2.2
http://boss.bekk.no/boss/middlegen/
http://www.hibernate.org/
-->
<class
name="com.pia.agp.mapping.Intervenant"
table="intervenant"
lazy="false"
>
<id
name="intervenantId"
type="java.lang.Integer"
column="INTERVENANT_ID"
>
<generator class="assigned" />
</id>
<property
name="intervenantNom"
type="java.lang.String"
column="INTERVENANT_NOM"
length="30"
/>
<property
name="intervenantPrenom"
type="java.lang.String"
column="INTERVENANT_PRENOM"
length="30"
/>
<property
name="intervenantLogin"
type="java.lang.String"
column="INTERVENANT_LOGIN"
length="30"
/>
<property
name="intervenantMdp"
type="java.lang.String"
column="INTERVENANT_MDP"
length="30"
/>
<property
name="intervenantEmail"
type="java.lang.String"
column="INTERVENANT_EMAIL"
length="30"
/>
<property
name="intervenantTel"
type="java.lang.String"
column="INTERVENANT_TEL"
length="15"
/>
<property
name="intervenantFonction"
type="java.lang.String"
column="INTERVENANT_FONCTION"
length="20"
/>
<property
name="intervenantDatedebutcontrat"
type="java.sql.Date"
column="INTERVENANT_DATEDEBUTCONTRAT"
not-null="true"
length="10"
/>
<property
name="intervenantDatefincontrat"
type="java.sql.Date"
column="INTERVENANT_DATEFINCONTRAT"
not-null="true"
length="10"
/>
<property
name="coutjournalierexperianId"
type="java.lang.String"
column="COUTJOURNALIEREXPERIAN_ID"
not-null="true"
length="32"
/>
<property
name="droitId"
type="long"
column="DROIT_ID"
not-null="true"
length="10"
/>
<!-- Associations -->
</class>
</hibernate-mapping> |
l'exception est declenche quand j'essaye de recuperer tous les champs de ma table intervenant
Code:
1
2
3
4
| public List getAll() {
return getHibernateTemplate().find(
"from Intervenant ");
} |
quelqu'un à une petite idée ? moi je crois que c'est a cause d'hibernate, il arrive pas peut etre à bien faire la liaison entre la classe java Intervenant et ma table. Mais je vois pas comment resoudre se probleme
Merci pour votre aide
