salut ,
J`ai un problème au niveau de référencement de path dans un formulaire jsp pour une jointure de colonne. j`ai une Table employées qui contient diffèrent champs(username,..) parmi ces champs celle de " manager_id" ce champ référence sur le clé primaire de la table Employées : c a d chaque employée possède un manager , et un manager possède a ou plusieurs employées .
Donc au niveau de persistance de données de cette table j`ai :
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
 
package com.proxymit.grh.domain;
 
import java.util.HashSet;
 
 
@Entity
@Table(name = "employees", catalog = "px_db_zied", uniqueConstraints = @UniqueConstraint(columnNames = "username"))
public class Employees implements java.io.Serializable {
 
	/**
	 * 
	 */
	public static final long serialVersionUID = 1L;
	public Integer idemployees;
	public Employees employees;
	public String firstame;
	public String lastname;
	public String mail;
	public String function;
	public String sheet;
	public Integer rib;
	public String maritalStatus;
	public Integer numberOfChildren;
	public String password;
	public Byte enabled;
	public String username;
	String manager_test ;
	public Set<Adressemployees> adressemployeeses = new HashSet<Adressemployees>(
			0);
	public Set<Vacation> vacations = new HashSet<Vacation>(0);
	public Set<Trainee> trainees = new HashSet<Trainee>(0);
	public Set<Phoneemployees> phoneemployeeses = new HashSet<Phoneemployees>(
			0);
	public Set<Rules> ruleses = new HashSet<Rules>(0);
	public Set<Salary> salaries = new HashSet<Salary>(0);
	public Set<Cv> cvs = new HashSet<Cv>(0);
	public Set<Employees> employeeses = new HashSet<Employees>(0);
 
	public Employees() {
	}
 
	public Employees(String firstame, String lastname, String mail,
			String function ,Set<Employees> employeeses) {
		this.firstame = firstame;
		this.lastname = lastname;
		this.mail = mail;
		this.function = function;
		this.employeeses = employeeses;
	}
 
 
	public Employees(Employees employees, String firstame, String lastname,
			String mail, String function, String sheet, Integer rib,
			String maritalStatus, Integer numberOfChildren, String password,
			Byte enabled, String username,
			Set<Adressemployees> adressemployeeses, Set<Vacation> vacations,
			Set<Trainee> trainees, Set<Phoneemployees> phoneemployeeses,
			Set<Rules> ruleses, Set<Salary> salaries, Set<Cv> cvs,
			Set<Employees> employeeses) {
		this.employees = employees;
		this.firstame = firstame;
		this.lastname = lastname;
		this.mail = mail;
		this.function = function;
		this.sheet = sheet;
		this.rib = rib;
		this.maritalStatus = maritalStatus;
		this.numberOfChildren = numberOfChildren;
		this.password = password;
		this.enabled = enabled;
		this.username = username;
		this.adressemployeeses = adressemployeeses;
		this.vacations = vacations;
		this.trainees = trainees;
		this.phoneemployeeses = phoneemployeeses;
		this.ruleses = ruleses;
		this.salaries = salaries;
		this.cvs = cvs;
		this.employeeses = employeeses;
	}
 
	@Id
	@GeneratedValue(strategy = IDENTITY)
	@Column(name = "idemployees", unique = true, nullable = false)
	public Integer getIdemployees() {
		return this.idemployees;
	}
 
	public void setIdemployees(Integer idemployees) {
		this.idemployees = idemployees;
	}
 
	@ManyToOne(cascade = CascadeType.ALL)
	@JoinColumn(name = "manager_id")
	public Employees getEmployees() {
		return this.employees;
	}
 
	public void setEmployees(Employees employees) {
		this.employees = employees;
	}
 
	@Column(name = "firstame", nullable = false, length = 45)
	public String getFirstame() {
		return this.firstame;
	}
 
	public void setFirstame(String firstame) {
		this.firstame = firstame;
	}
 
	@Column(name = "lastname", nullable = false, length = 45)
	public String getLastname() {
		return this.lastname;
	}
 
	public void setLastname(String lastname) {
		this.lastname = lastname;
	}
 
	@Column(name = "mail", nullable = false, length = 45)
	public String getMail() {
		return this.mail;
	}
 
	public void setMail(String mail) {
		this.mail = mail;
	}
 
	@Column(name = "function", nullable = false, length = 45)
	public String getFunction() {
		return this.function;
	}
 
	public void setFuncRtion(String function) {
		this.function = function;
	}
 
	@Column(name = "sheet")
	public String getSheet() {
		return this.sheet;
	}
 
	public void setSheet(String sheet) {
		this.sheet = sheet;
	}
 
	@Column(name = "rib")
	public Integer getRib() {
		return this.rib;
	}
 
	public void setRib(Integer rib) {
		this.rib = rib;
	}
 
	@Column(name = "MaritalStatus", length = 45)
	public String getMaritalStatus() {
		return this.maritalStatus;
	}
 
	public void setMaritalStatus(String maritalStatus) {
		this.maritalStatus = maritalStatus;
	}
 
	@Column(name = "number_of_children")
	public Integer getNumberOfChildren() {
		return this.numberOfChildren;
	}
 
	public void setNumberOfChildren(Integer numberOfChildren) {
		this.numberOfChildren = numberOfChildren;
	}
 
	@Column(name = "password", length = 60)
	public String getPassword() {
		return this.password;
	}
 
	public void setPassword(String password) {
		this.password = password;
	}
 
	@Column(name = "enabled")
	public Byte getEnabled() {
		return this.enabled;
	}
 
	public void setEnabled(Byte enabled) {
		this.enabled = enabled;
	}
 
	@Column(name = "username", unique = true, length = 25)
	public String getUsername() {
		return this.username;
	}
 
	public void setUsername(String username) {
		this.username = username;
	}
 
	@OneToMany(cascade = CascadeType.ALL, mappedBy = "employees")
	public Set<Adressemployees> getAdressemployeeses() {
		return this.adressemployeeses;
	}
 
	public void setAdressemployeeses(Set<Adressemployees> adressemployeeses) {
		this.adressemployeeses = adressemployeeses;
	}
 
	@OneToMany(cascade = CascadeType.ALL, mappedBy = "employees")
	public Set<Vacation> getVacations() {
		return this.vacations;
	}
 
	public void setVacations(Set<Vacation> vacations) {
		this.vacations = vacations;
	}
 
	@OneToMany(cascade = CascadeType.ALL, mappedBy = "employees")
	public Set<Trainee> getTrainees() {
		return this.trainees;
	}
 
	public void setTrainees(Set<Trainee> trainees) {
		this.trainees = trainees;
	}
 
	@OneToMany(cascade = CascadeType.ALL, mappedBy = "employees")
	public Set<Phoneemployees> getPhoneemployeeses() {
		return this.phoneemployeeses;
	}
 
	public void setPhoneemployeeses(Set<Phoneemployees> phoneemployeeses) {
		this.phoneemployeeses = phoneemployeeses;
	}
 
	@ManyToMany(cascade = CascadeType.ALL)
	@JoinTable(name = "employees_rules", catalog = "px_db_zied", joinColumns = { @JoinColumn(name = "employees_idemployees", nullable = false, updatable = false) }, inverseJoinColumns = { @JoinColumn(name = "rules_idrules", nullable = false, updatable = false) })
	public Set<Rules> getRuleses() {
		return this.ruleses;
	}
 
	public void setRuleses(Set<Rules> ruleses) {
		this.ruleses = ruleses;
	}
 
	@OneToMany(cascade = CascadeType.ALL, mappedBy = "employees")
	public Set<Salary> getSalaries() {
		return this.salaries;
	}
 
	public void setSalaries(Set<Salary> salaries) {
		this.salaries = salaries;
	}
 
	@OneToMany(cascade = CascadeType.ALL, mappedBy = "employees")
	public Set<Cv> getCvs() {
		return this.cvs;
	}
 
	public void setCvs(Set<Cv> cvs) {
		this.cvs = cvs;
	}
 
	@OneToMany(cascade = CascadeType.ALL, mappedBy = "employees")
	public Set<Employees> getEmployeeses() {
		return this.employeeses;
	}
 
	public void setEmployeeses(Set<Employees> employeeses) {
		this.employeeses = employeeses;
	}
 
}
Donc mon probleme c que j`arrive pas a faire un enregistrement dans cette table puisque j`arrive pas a donner le path de manager id

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
 
 <center> <h1>Ajouter un Employe</h1> </center> 
 <p><img src=" C:/Users/Zied/Documents/workspace-sts-2.3.0.RELEASE/GRH_Light_Proxym/image/Proxym.png"/ ALIGN ="right"> </p>
<form:form action="addtest.htm" commandName="employes">
	<table>
		<tr>
			<td>Nom :</td>
			<td><form:input path="firstame" /></td>
		</tr>
		<tr>
			<td>Prenom :</td>
			<td><form:input path="lastname" /></td>
		</tr>
 
		<tr>
			<td>function:</td>
			<td><form:input path="function" /></td>
		</tr>
		<tr>
			<td>mail:</td>
			<td><form:input path="mail" /></td>
		</tr>
		<tr>
			<td>sheet:</td>
			<td><form:input path="sheet" /></td>
		</tr>
 
 
			<tr>
			<td>maritalStatus:</td>
			<td><form:input path="maritalStatus" /></td>
		</tr>
 
			<tr>
			<td>password:</td>
			<td><form:input path="password" /></td>
		</tr>
 
 
 
		<tr>
			<td>username:</td>
			<td><form:input path="username" /></td>
		</tr>
 
 
	// mon probleme c`est ici 	
 
		<tr>
			<td>manager:</td>
			<td><form:select path="employeeses"  >
		   <form:options items="${employesList}" itemLabel="firstame" itemValue="idemployees" />
		</form:select></td>
		</tr>
 
		<tr>
			<td colspan="2"><input type="submit" value="Register"></td>
		</tr>
	</table>
</form:form>
 <a href="<c:url value="/acceuil.htm"/>">Home</a>
</body>
</html>

qlq1 peut m`aider