Discussion :

[leara500]

Bonjour,
Je ne sais pas si c'est au bon endroit pour poser ma question, mais je tente ma chance...

Je suis en train de développer une application sous Struts2, avec Hibernate et le temps de chargement des pages est long.

Je pense que cela doit venir du fais que j'ai plusieurs tables, dont 1 qui est composé d'1 clé primaire et de 4 clé étrangères. Comment puis je réduire le temps de chargement des pages ?

Merci pour tout

[NoClassDefFound]

Tu es probablement en train de rencontrer le problème majeur de tous les ORMS: le requêtage n+1.
Il faut tout d'abord que tu saches exactement ce qu'hibernate est en train de charger et pour cela il faut que tu actives les logs d'hibernate.
Pour activer les logs, il faut que tu affectes la propriété hibernate.show_sql à true dans ton fichier persistence.xml ou autre.
Une fois que tu as vu ce qu'hibernate charge, tu peux par exemple jouer sur les stratégies de chargement (LAZY,EAGER) et le fetchmode de tes collections, voir sur la stratégie de chargement unitaire des champs.
Si tu n'as besoin que de quelques champs de ton entité (affichage dans une liste par exemple), tu peux peut être envisager d'utiliser en objet DTO.
Une autre piste peut être de charger les objets via une requête HQL avec du "join fetch", c'est à dire de préciser la stratégie de chargement des objets liés dans la requête elle-même.
Bref, il y a mille et une manières d'optimiser le chargement mais cela dépend vraiement de ton contexte d'utilisation.

[Rei Ichido]

Par ailleurs, quel que soit votre découpage en Tiers, gardez à l'esprit que plus on fait des appels, plus on consomme. Mieux vaut donc faire un gros appel qui ramène toutes les infos d'un coup que 1000 petits appels.

[DevServlet]

Par ailleurs, quel que soit votre découpage en Tiers, gardez à l'esprit que plus on fait des appels, plus on consomme. Mieux vaut donc faire un gros appel qui ramène toutes les infos d'un coup que 1000 petits appels.

, j'en ai fait des frais à mes débuts, rien de plus lourd que des allers/retours multipliés avec la bd.

[leara500]

Tout d'abord, je tiens à vous remercier de m'avoir répondu.

Par contre, que voulez vous dire par "faire un gros appel" ?

J'ai mis hibernate.show_sql à true dans mon fichier xml, et je vois que beaucoup de requêtes sont utilisées, notamment lorsque je veux charger les semaines enregistrés en base par unité et j'obtiens cela dans ma console : (ceci n'était qu'un extrait de ce qui m'est retourné) :

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
 
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idSemaine as idSemaine6_0_, this_.dateDebutSem as dateDebu2_6_0_, this_.dateFinSem as dateFinSem6_0_, this_.dateModif as dateModif6_0_, this_.numeroSemaine as numeroSe5_6_0_, this_.roulementSem as roulemen6_6_0_, this_.type as type6_0_ from gestionhoraire.semaine this_ where this_.idSemaine=?
Hibernate: select this_.idJour as idJour4_0_, this_.idAbsence as idAbsence4_0_, this_.debutHoraire as debutHor2_4_0_, this_.finHoraire as finHoraire4_0_, this_.indexJour as indexJour4_0_, this_.jour as jour4_0_, this_.libelleJour as libelleJ6_4_0_, this_.idSemaine as idSemaine4_0_, this_.typeHoraire as typeHora7_4_0_ from gestionhoraire.jour this_ where this_.idSemaine=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idPersSemaineCompt as idPersSe1_10_0_, this_.idCompteur as idCompteur10_0_, this_.idJour as idJour10_0_, this_.idPersonne as idPersonne10_0_, this_.idSemaine as idSemaine10_0_ from gestionhoraire.perssemainecompt this_ where this_.idSemaine=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idSemaine as idSemaine6_0_, this_.dateDebutSem as dateDebu2_6_0_, this_.dateFinSem as dateFinSem6_0_, this_.dateModif as dateModif6_0_, this_.numeroSemaine as numeroSe5_6_0_, this_.roulementSem as roulemen6_6_0_, this_.type as type6_0_ from gestionhoraire.semaine this_ where this_.idSemaine=?
Hibernate: select this_.idJour as idJour4_0_, this_.idAbsence as idAbsence4_0_, this_.debutHoraire as debutHor2_4_0_, this_.finHoraire as finHoraire4_0_, this_.indexJour as indexJour4_0_, this_.jour as jour4_0_, this_.libelleJour as libelleJ6_4_0_, this_.idSemaine as idSemaine4_0_, this_.typeHoraire as typeHora7_4_0_ from gestionhoraire.jour this_ where this_.idSemaine=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idAbsence as idAbsence0_0_, this_.abrAbsence as abrAbsence0_0_, this_.nomAbsence as nomAbsence0_0_, this_.nombreHeureArecup as nombreHe4_0_0_ from gestionhoraire.absence this_ where this_.idAbsence=?
Hibernate: select this_.idPersSemaineCompt as idPersSe1_10_0_, this_.idCompteur as idCompteur10_0_, this_.idJour as idJour10_0_, this_.idPersonne as idPersonne10_0_, this_.idSemaine as idSemaine10_0_ from gestionhoraire.perssemainecompt this_ where this_.idSemaine=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idFonction as idFonction3_0_, this_.descFonction as descFonc2_3_0_ from gestionhoraire.fonction this_ where this_.idFonction=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idDroit as idDroit2_0_, this_.descDroit as descDroit2_0_, this_.nomDroit as nomDroit2_0_ from gestionhoraire.droit this_ where this_.idDroit=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idService as idService7_0_, this_.nomService as nomService7_0_ from gestionhoraire.service this_ where this_.idService=?
Hibernate: select this_.idPersonne as idPersonne5_0_, this_.idDroit as idDroit5_0_, this_.idFonction as idFonction5_0_, this_.horaireContrat as horaireC2_5_0_, this_.nom as nom5_0_, this_.prenom as prenom5_0_, this_.idService as idService5_0_, this_.idUser as idUser5_0_ from gestionhoraire.personne this_ where this_.idPersonne=?
Hibernate: select this_.idUser as idUser9_0_, this_.login as login9_0_, this_.mdp as mdp9_0_ from gestionhoraire.userlogin this_ where this_.idUser=?
Hibernate: select this_.idCompteur as idCompteur1_0_, this_.horaireAfaire as horaireA2_1_0_, this_.horaireFaite as horaireF3_1_0_, this_.observation as observat4_1_0_ from gestionhoraire.compteur this_ where this_.idCompteur=?
 
 
etc .....

Merci du coup de main

[leara500]

Désolée de vous re-déranger avec çà, mais que voulez vous dire par faire "un gros appel" ?

[Gardyen]

En l'occurrence il s'agit d'effectuer une seule requête te ramenant tous les résultats que tu peux vouloir consulter, ensuite tu n'affiches que ceux qui t'intéressent. Par exemple (il existe de nombreuses possibilités), tu peux récupérer toutes les semaines d'un coup, et ensuite tu affiches en classant par unité.

comme l'a dit NoClassDefFound, tu disposes de plusieurs moyens d'optimisation, à toi de choisir celle qui te convient.

[NoClassDefFound]

Pour faire simple, comme tev l'as dit Gzrdien, au lieu d'exécuter plusieurs requêtes SQL pour initialiser les objets, il est parfois possible d'initialiser ces mêmes objets avec une ou deux requêtes SQL.
Tu peux peut être déjà jouer avec les stratégies de chargement des collections (OneToMany et ManyToOne) en précisant le paramètre fetch=LAZY ou fetch=EAGER et regarder ce que cela donne.
Un autre paramètres des collections connaître est l'annotation @Fetch qui détermine la façon de charger la collection (une requête par élément de la collection, une requête pour tous les éléments de la collection, ...)
Malheureusement comme je te le disais, il n'y a pas de recettes miracle, cela demande du temps et de la patience.

[leara500]

Oki doki ^^

Merci beaucoup de toutes vos réponses

[Rei Ichido]

Je reviens juste sur "un gros appel plutôt que plein de petits".
Si je prend un exemple simple : imaginons une page sur laquelle on peut faire une recherche sur des utilisateurs. La page peut retourner 100 résultats, et pour chaque utilisateur je dois afficher une dizaine d'infos, stockées dans des tables différentes.
Une façon de faire, c'est :
1) Appel à une procédure qui ramène les id des 100 utilisateurs
2) Des formatteurs pour chaque colonne de mon tableau qui prennent un id utilisateur, font une requête base pour aller chercher la valeur correspondante (par exemple, getStatus, getDateEntrée, etc.).
Pour afficher mon résultat, j'aurais consommé 1 appel base initial, puis 1000 appels pour remplir toutes les cases de mon tableau ...

Une autre façon de faire, c'est de faire directement les jointures qui vont bien, de stocker le résultat dans un bean qui contient exactement les valeurs nécessaires à l'affichage du tableau, et donc de n'avoir qu'un seul appel qui retourne tout beau tout propre une liste contenant toutes les infos. Ce qui évite beaucoup d'allers-retours !

[leara500]

Merci beaucoup de vos réponses

[DevServlet]

Merci beaucoup de vos réponses

Bonjour, la solution que tu as adoptée au final peut interesser les autres. Peut on savoir laquelle?

[leara500]

DevServlet > Faire un gros appel dès le départ au lieu de plusieurs petits appels ^^