Fuite de connexions

**bulldozer27350** · 25/09/2013, 16h25

Bonjour à tous,

Voila, il semble que j'ai une fuite de connexion quelque part. Pour reproduire le problème, j'ai fais un petit TU.

Au niveau architecture, on a une base de données MySQL, et du JPA.
(Autre petit point : j'arrive en intercontrat et je tombe sur ce projet développé par des stagiaires, et d'autres interco ... bref, on passera volontiers à côté des réflexions sur l'architecture et autres questions qui sont importantes mais dont ce topic n'est pas le sujet).

Alors, voici le contenu de mon test :

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
 
@Test
public void testFuiteConnexion() { // Point d'entrée
	@SuppressWarnings("static-access")
 
	// récupérer l'instance EntityManager afin d'effectué un rollback en cas d'echec
	EntityManager em = GroupesNotesDao.entityManager();
 
	// récupérer l'ID du groupe que vous venez de crée depuis l'IHM
	// groupe 19 exist dans le scchema
	String groupId = "19";			
 
	List<Integer> listCompetenciesAdd = new ArrayList<Integer>();
	int nbCompetences = 30;
 
	// choix arbitraire des ID de COMPETENCES entre 1 et 100
	Random rd = new Random();
	for (int i = 0; i < nbCompetences; i++) {
		listCompetenciesAdd.add((rd.nextInt(100) + 1));
	}
 
	// Ajout compétence depuis la list : listCompetenciesAdd
 
	for (int i = 0; i< listCompetenciesAdd.size(); i++) {
		System.out.println("[testFuiteConnexion] Ajout N° " + (i+1));
	GroupesNotesManager.addCompetence(em, groupId,
			("" + listCompetenciesAdd.get(i)));
	}
	// à titre indicatif : le resultat est toujours vrai
	assertEquals(listCompetenciesAdd.size(),nbCompetences);
 
	em.close();
 
}

Voici le code permettant d'accéder à l'entityManager :

Code :

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

1
2
3
4
5
 
public static final EntityManager entityManager() {
	//EMF est un EntityManagerFactory en mode Singleton
	return EMF.get().createEntityManager();
}

Le code de GroupeNoteManager.addCompetence :

Code :

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

1
2
3
4
5
6
7
8
9
10
11
12
13
 
public static boolean addCompetence(EntityManager em, final String groupId,
		final String newCompId) {
 
	boolean result = false;
	List<CollaborateurGroupe> listCollaborateurGroupe = new ArrayList<CollaborateurGroupe>();
	List<GroupesNotes> listGroupesNotes = new ArrayList<GroupesNotes>();
 
	[...]
	GroupesNotesDao.updateListGroupeNotes(em, listGroupesNotes);
	result = true;
	return result;
}

Et enfin GroupeNoteDao.updateListGroupeNotes

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
 
public final static boolean updateListGroupeNotes(EntityManager em, 
			final List<GroupesNotes> listGN) {
			boolean addValidate = false;
 
		try {
			GroupesNotesManager.showGN(listGN);
			EntityTransaction tx = em.getTransaction();
			tx.begin();
			for (int i = 0; i < listGN.size(); i++) {
				em.persist(listGN.get(i));
			}
			tx.commit();
 
			addValidate = true;	
			//em.getTransaction().commit();
			GroupesNotesManager.showGN(listGN);
 
		} catch (Exception e) {
			LOGGER.error(
					"[GroupesNotesDao],[updateListGroupeNotes],[" + e.getMessage()
							+ "]", e);
			addValidate = false;
			em.getTransaction().rollback();
		}
		return addValidate;
	}

Et enfin le log que ça me crache (attention, c'est hyper verbeux)

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
 
[testFuiteConnexion] Ajout N° 10
2013-09-25 16:22:34,142 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,142 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,143 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,143 DEBUG [org.hibernate.SQL:111] select groupescol0_.ID as ID4_, groupescol0_.DATECREATION as DATECREA2_4_, groupescol0_.DATEFIN as DATEFIN4_, groupescol0_.NOM as NOM4_, groupescol0_.VERSION as VERSION4_ from GroupesCollaborateurs groupescol0_ where groupescol0_.ID=? limit ?
2013-09-25 16:22:34,143 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:179] com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache ----> CACHE HIT
2013-09-25 16:22:34,143 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:196] checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 1; num connections: 7; num keys: 50
2013-09-25 16:22:34,144 DEBUG [org.hibernate.jdbc.AbstractBatcher:426] about to open ResultSet (open ResultSets: 0, globally: 0)
2013-09-25 16:22:34,145 DEBUG [org.hibernate.loader.Loader:1322] result row: EntityKey[sii.hippoComp.server.domain.GroupesCollaborateurs#19]
2013-09-25 16:22:34,145 DEBUG [org.hibernate.jdbc.AbstractBatcher:433] about to close ResultSet (open ResultSets: 1, globally: 1)
2013-09-25 16:22:34,145 DEBUG [org.hibernate.jdbc.AbstractBatcher:418] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2013-09-25 16:22:34,145 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:271] checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,145 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,145 DEBUG [org.hibernate.jdbc.ConnectionManager:464] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2013-09-25 16:22:34,145 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,146 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,146 DEBUG [org.hibernate.engine.StatefulPersistenceContext:893] initializing non-lazy collections
2013-09-25 16:22:34,146 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,146 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,146 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,146 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,146 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,146 DEBUG [org.hibernate.SQL:111] select collaborat0_.ID as ID1_, collaborat0_.COLLABORATEURS_ID as COLLABOR5_1_, collaborat0_.DATEENTREE as DATEENTREE1_, collaborat0_.DATESORTIE as DATESORTIE1_, collaborat0_.GROUPESCOLLABORATEURS_ID as GROUPESC6_1_, collaborat0_.VERSION as VERSION1_ from CollaborateurGroupe collaborat0_ where collaborat0_.GROUPESCOLLABORATEURS_ID=?
2013-09-25 16:22:34,147 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:179] com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache ----> CACHE HIT
2013-09-25 16:22:34,147 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:196] checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 1; num connections: 7; num keys: 50
2013-09-25 16:22:34,148 DEBUG [org.hibernate.jdbc.AbstractBatcher:426] about to open ResultSet (open ResultSets: 0, globally: 0)
2013-09-25 16:22:34,149 DEBUG [org.hibernate.loader.Loader:1322] result row: EntityKey[sii.hippoComp.server.domain.CollaborateurGroupe#253]
2013-09-25 16:22:34,149 DEBUG [org.hibernate.loader.Loader:1322] result row: EntityKey[sii.hippoComp.server.domain.CollaborateurGroupe#254]
2013-09-25 16:22:34,149 DEBUG [org.hibernate.jdbc.AbstractBatcher:433] about to close ResultSet (open ResultSets: 1, globally: 1)
2013-09-25 16:22:34,149 DEBUG [org.hibernate.jdbc.AbstractBatcher:418] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2013-09-25 16:22:34,150 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:271] checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,150 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,151 DEBUG [org.hibernate.jdbc.ConnectionManager:464] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2013-09-25 16:22:34,151 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,151 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,151 DEBUG [org.hibernate.engine.StatefulPersistenceContext:893] initializing non-lazy collections
2013-09-25 16:22:34,151 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,151 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,151 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:318] *** - collaborateurDansGroupePourUneCompetence - ***
2013-09-25 16:22:34,151 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:318] *** - collaborateurDansGroupePourUneCompetence - ***
2013-09-25 16:22:34,152 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,152 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,152 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,152 DEBUG [org.hibernate.SQL:111] select histnotes0_.ID as ID6_, histnotes0_.ACTION as ACTION6_, histnotes0_.COLLABORATEURS_ID as COLLABOR7_6_, histnotes0_.COMPETENCES_ID as COMPETEN8_6_, histnotes0_.DATEDEBUT as DATEDEBUT6_, histnotes0_.DATEFIN as DATEFIN6_, histnotes0_.NOTE as NOTE6_, histnotes0_.VERSION as VERSION6_ from HistNotes histnotes0_ where histnotes0_.COMPETENCES_ID=? and histnotes0_.COLLABORATEURS_ID=? order by DATEFIN ASC
2013-09-25 16:22:34,152 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:179] com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache ----> CACHE HIT
2013-09-25 16:22:34,152 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:196] checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 1; num connections: 7; num keys: 50
2013-09-25 16:22:34,154 DEBUG [org.hibernate.jdbc.AbstractBatcher:426] about to open ResultSet (open ResultSets: 0, globally: 0)
2013-09-25 16:22:34,154 DEBUG [org.hibernate.jdbc.AbstractBatcher:433] about to close ResultSet (open ResultSets: 1, globally: 1)
2013-09-25 16:22:34,154 DEBUG [org.hibernate.jdbc.AbstractBatcher:418] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2013-09-25 16:22:34,154 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:271] checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,155 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,155 DEBUG [org.hibernate.jdbc.ConnectionManager:464] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2013-09-25 16:22:34,155 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,155 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,155 DEBUG [org.hibernate.engine.StatefulPersistenceContext:893] initializing non-lazy collections
2013-09-25 16:22:34,155 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,155 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,156 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,156 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,156 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,156 DEBUG [org.hibernate.SQL:111] select notes0_.ID as ID7_, notes0_.COLLABORATEURS_ID as COLLABOR6_7_, notes0_.COMPETENCES_ID as COMPETEN7_7_, notes0_.DATECREATION as DATECREA2_7_, notes0_.DATEMODIFICATION as DATEMODI3_7_, notes0_.NOTE as NOTE7_, notes0_.VERSION as VERSION7_ from Notes notes0_ where notes0_.COMPETENCES_ID=? and notes0_.COLLABORATEURS_ID=? order by DATEMODIFICATION ASC limit ?
2013-09-25 16:22:34,156 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:179] com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache ----> CACHE HIT
2013-09-25 16:22:34,156 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:196] checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 1; num connections: 7; num keys: 50
2013-09-25 16:22:34,158 DEBUG [org.hibernate.jdbc.AbstractBatcher:426] about to open ResultSet (open ResultSets: 0, globally: 0)
2013-09-25 16:22:34,158 DEBUG [org.hibernate.jdbc.AbstractBatcher:433] about to close ResultSet (open ResultSets: 1, globally: 1)
2013-09-25 16:22:34,158 DEBUG [org.hibernate.jdbc.AbstractBatcher:418] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2013-09-25 16:22:34,158 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:271] checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,158 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,158 DEBUG [org.hibernate.jdbc.ConnectionManager:464] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2013-09-25 16:22:34,159 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,159 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,159 DEBUG [org.hibernate.engine.StatefulPersistenceContext:893] initializing non-lazy collections
2013-09-25 16:22:34,159 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,159 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,159 DEBUG [org.hibernate.impl.SessionImpl:265] opened session at timestamp: 13801189541
2013-09-25 16:22:34,160 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,160 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,160 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,160 DEBUG [org.hibernate.SQL:111] select competence0_.ID as ID3_, competence0_.DATECREATION as DATECREA2_3_, competence0_.DATEMODIFICATION as DATEMODI3_3_, competence0_.NOM as NOM3_, competence0_.THEME_ID as THEME6_3_, competence0_.VERSION as VERSION3_ from Competences competence0_ where competence0_.ID=? limit ?
2013-09-25 16:22:34,160 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:179] com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache ----> CACHE HIT
2013-09-25 16:22:34,160 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:196] checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 1; num connections: 7; num keys: 50
2013-09-25 16:22:34,162 DEBUG [org.hibernate.jdbc.AbstractBatcher:426] about to open ResultSet (open ResultSets: 0, globally: 0)
2013-09-25 16:22:34,162 DEBUG [org.hibernate.loader.Loader:1322] result row: EntityKey[sii.hippoComp.server.domain.Competences#67]
2013-09-25 16:22:34,162 DEBUG [org.hibernate.jdbc.AbstractBatcher:433] about to close ResultSet (open ResultSets: 1, globally: 1)
2013-09-25 16:22:34,162 DEBUG [org.hibernate.jdbc.AbstractBatcher:418] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2013-09-25 16:22:34,163 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:271] checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,163 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,163 DEBUG [org.hibernate.jdbc.ConnectionManager:464] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2013-09-25 16:22:34,163 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,163 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,163 DEBUG [org.hibernate.engine.TwoPhaseLoad:130] resolving associations for [sii.hippoComp.server.domain.Competences#67]
2013-09-25 16:22:34,164 DEBUG [org.hibernate.loader.Loader:2022] loading entity: [sii.hippoComp.server.domain.Themes#14]
2013-09-25 16:22:34,165 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,165 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,165 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:554] acquire test -- pool is already maxed out. [managed: 10; max: 10]
2013-09-25 16:22:34,166 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1291] awaitAvailable(): com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb
2013-09-25 16:22:34,166 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,165 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,166 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,166 DEBUG [org.hibernate.SQL:111] select themes0_.ID as ID11_1_, themes0_.CATEGORIE_ID as CATEGORIE6_11_1_, themes0_.DATECREATION as DATECREA2_11_1_, themes0_.DATEMODIFICATION as DATEMODI3_11_1_, themes0_.NOM as NOM11_1_, themes0_.VERSION as VERSION11_1_, categories1_.ID as ID0_0_, categories1_.DATECREATION as DATECREA2_0_0_, categories1_.DATEMODIFICATION as DATEMODI3_0_0_, categories1_.NOM as NOM0_0_, categories1_.VERSION as VERSION0_0_ from Themes themes0_ inner join Categories categories1_ on themes0_.CATEGORIE_ID=categories1_.ID where themes0_.ID=?
2013-09-25 16:22:34,167 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:179] com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache ----> CACHE HIT
2013-09-25 16:22:34,167 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:196] checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 1; num connections: 7; num keys: 50
2013-09-25 16:22:34,169 DEBUG [org.hibernate.jdbc.AbstractBatcher:426] about to open ResultSet (open ResultSets: 0, globally: 0)
2013-09-25 16:22:34,170 DEBUG [org.hibernate.loader.Loader:1322] result row: EntityKey[sii.hippoComp.server.domain.Categories#4], EntityKey[sii.hippoComp.server.domain.Themes#14]
2013-09-25 16:22:34,170 DEBUG [org.hibernate.jdbc.AbstractBatcher:433] about to close ResultSet (open ResultSets: 1, globally: 1)
2013-09-25 16:22:34,170 DEBUG [org.hibernate.jdbc.AbstractBatcher:418] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2013-09-25 16:22:34,170 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:271] checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,170 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,171 DEBUG [org.hibernate.jdbc.ConnectionManager:464] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2013-09-25 16:22:34,171 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,171 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,171 DEBUG [org.hibernate.engine.TwoPhaseLoad:130] resolving associations for [sii.hippoComp.server.domain.Categories#4]
2013-09-25 16:22:34,171 DEBUG [org.hibernate.engine.TwoPhaseLoad:255] done materializing entity [sii.hippoComp.server.domain.Categories#4]
2013-09-25 16:22:34,172 DEBUG [org.hibernate.engine.TwoPhaseLoad:130] resolving associations for [sii.hippoComp.server.domain.Themes#14]
2013-09-25 16:22:34,172 DEBUG [org.hibernate.engine.TwoPhaseLoad:255] done materializing entity [sii.hippoComp.server.domain.Themes#14]
2013-09-25 16:22:34,172 DEBUG [org.hibernate.loader.Loader:2050] done entity load
2013-09-25 16:22:34,172 DEBUG [org.hibernate.engine.TwoPhaseLoad:255] done materializing entity [sii.hippoComp.server.domain.Competences#67]
2013-09-25 16:22:34,172 DEBUG [org.hibernate.engine.StatefulPersistenceContext:893] initializing non-lazy collections
2013-09-25 16:22:34,172 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,173 DEBUG [org.hibernate.impl.SessionImpl:265] opened session at timestamp: 13801189541
2013-09-25 16:22:34,173 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,173 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,173 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:554] acquire test -- pool is already maxed out. [managed: 10; max: 10]
2013-09-25 16:22:34,173 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1291] awaitAvailable(): com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb
2013-09-25 16:22:34,174 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,174 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,174 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,174 DEBUG [org.hibernate.SQL:111] select collaborat0_.ID as ID2_, collaborat0_.ADRESSEMAIL as ADRESSEM2_2_, collaborat0_.DATE as DATE2_, collaborat0_.DATECREATION as DATECREA4_2_, collaborat0_.DATEMODIFICATION as DATEMODI5_2_, collaborat0_.DATERELANCE as DATERELA6_2_, collaborat0_.IDENTIFIANT as IDENTIFI7_2_, collaborat0_.MOTDEPASSE as MOTDEPASSE2_, collaborat0_.NOM as NOM2_, collaborat0_.PATH as PATH2_, collaborat0_.PRENOM as PRENOM2_, collaborat0_.ROLE_ID as ROLE13_2_, collaborat0_.VERSION as VERSION2_ from Collaborateurs collaborat0_ where collaborat0_.ID=? limit ?
2013-09-25 16:22:34,174 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:179] com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache ----> CACHE HIT
2013-09-25 16:22:34,174 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:196] checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 1; num connections: 7; num keys: 50
2013-09-25 16:22:34,176 DEBUG [org.hibernate.jdbc.AbstractBatcher:426] about to open ResultSet (open ResultSets: 0, globally: 0)
2013-09-25 16:22:34,177 DEBUG [org.hibernate.loader.Loader:1322] result row: EntityKey[sii.hippoComp.server.domain.Collaborateurs#47]
2013-09-25 16:22:34,177 DEBUG [org.hibernate.jdbc.AbstractBatcher:433] about to close ResultSet (open ResultSets: 1, globally: 1)
2013-09-25 16:22:34,177 DEBUG [org.hibernate.jdbc.AbstractBatcher:418] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2013-09-25 16:22:34,177 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:271] checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,177 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,177 DEBUG [org.hibernate.jdbc.ConnectionManager:464] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2013-09-25 16:22:34,178 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,178 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,178 DEBUG [org.hibernate.engine.TwoPhaseLoad:130] resolving associations for [sii.hippoComp.server.domain.Collaborateurs#47]
2013-09-25 16:22:34,178 DEBUG [org.hibernate.loader.Loader:2022] loading entity: [sii.hippoComp.server.domain.Roles#2]
2013-09-25 16:22:34,178 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,180 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,180 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,180 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:554] acquire test -- pool is already maxed out. [managed: 10; max: 10]
2013-09-25 16:22:34,180 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1291] awaitAvailable(): com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb
2013-09-25 16:22:34,180 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,181 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,181 DEBUG [org.hibernate.SQL:111] select roles0_.ID as ID10_0_, roles0_.DATECREATION as DATECREA2_10_0_, roles0_.DATEMODIFICATION as DATEMODI3_10_0_, roles0_.NOM as NOM10_0_, roles0_.VERSION as VERSION10_0_ from Roles roles0_ where roles0_.ID=?
2013-09-25 16:22:34,181 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:179] com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache ----> CACHE HIT
2013-09-25 16:22:34,181 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:196] checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 1; num connections: 7; num keys: 50
2013-09-25 16:22:34,183 DEBUG [org.hibernate.jdbc.AbstractBatcher:426] about to open ResultSet (open ResultSets: 0, globally: 0)
2013-09-25 16:22:34,183 DEBUG [org.hibernate.loader.Loader:1322] result row: EntityKey[sii.hippoComp.server.domain.Roles#2]
2013-09-25 16:22:34,183 DEBUG [org.hibernate.jdbc.AbstractBatcher:433] about to close ResultSet (open ResultSets: 1, globally: 1)
2013-09-25 16:22:34,183 DEBUG [org.hibernate.jdbc.AbstractBatcher:418] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2013-09-25 16:22:34,184 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:271] checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,184 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,184 DEBUG [org.hibernate.jdbc.ConnectionManager:464] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2013-09-25 16:22:34,184 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,184 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,185 DEBUG [org.hibernate.engine.TwoPhaseLoad:130] resolving associations for [sii.hippoComp.server.domain.Roles#2]
2013-09-25 16:22:34,185 DEBUG [org.hibernate.engine.TwoPhaseLoad:255] done materializing entity [sii.hippoComp.server.domain.Roles#2]
2013-09-25 16:22:34,185 DEBUG [org.hibernate.loader.Loader:2050] done entity load
2013-09-25 16:22:34,185 DEBUG [org.hibernate.engine.TwoPhaseLoad:255] done materializing entity [sii.hippoComp.server.domain.Collaborateurs#47]
2013-09-25 16:22:34,185 DEBUG [org.hibernate.engine.StatefulPersistenceContext:893] initializing non-lazy collections
2013-09-25 16:22:34,185 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,186 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,186 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:914]  Note  	 | listHistNotes.DateDebut 	 | listHistNotes.DateFin  	 | listHistNotes.CompId  	 | listHistNotes.CollabId 
2013-09-25 16:22:34,186 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:914]  Note  	 | listHistNotes.DateDebut 	 | listHistNotes.DateFin  	 | listHistNotes.CompId  	 | listHistNotes.CollabId 
2013-09-25 16:22:34,186 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:919]   0	 | 2013-09-01 00:00:00 		 | null 			 | 67 				 | 47
2013-09-25 16:22:34,186 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:919]   0	 | 2013-09-01 00:00:00 		 | null 			 | 67 				 | 47
2013-09-25 16:22:34,186 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:914]  Note  	 | listHistNotes.DateDebut 	 | listHistNotes.DateFin  	 | listHistNotes.CompId  	 | listHistNotes.CollabId 
2013-09-25 16:22:34,186 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:914]  Note  	 | listHistNotes.DateDebut 	 | listHistNotes.DateFin  	 | listHistNotes.CompId  	 | listHistNotes.CollabId 
2013-09-25 16:22:34,186 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:919]   0	 | 2013-09-01 00:00:00 		 | null 			 | 67 				 | 47
2013-09-25 16:22:34,186 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:919]   0	 | 2013-09-01 00:00:00 		 | null 			 | 67 				 | 47
2013-09-25 16:22:34,186 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:558] Debut d'algorithme d'initialisation de la list des GROUPENOTE cas ListGN == Null et cas traitement 1 eme Collab
2013-09-25 16:22:34,186 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:558] Debut d'algorithme d'initialisation de la list des GROUPENOTE cas ListGN == Null et cas traitement 1 eme Collab
2013-09-25 16:22:34,186 DEBUG [org.hibernate.impl.SessionImpl:265] opened session at timestamp: 13801189541
2013-09-25 16:22:34,187 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,187 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,187 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,187 DEBUG [org.hibernate.SQL:111] select competence0_.ID as ID3_, competence0_.DATECREATION as DATECREA2_3_, competence0_.DATEMODIFICATION as DATEMODI3_3_, competence0_.NOM as NOM3_, competence0_.THEME_ID as THEME6_3_, competence0_.VERSION as VERSION3_ from Competences competence0_ where competence0_.ID=? limit ?
2013-09-25 16:22:34,187 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:179] com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache ----> CACHE HIT
2013-09-25 16:22:34,187 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:196] checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 1; num connections: 7; num keys: 50
2013-09-25 16:22:34,189 DEBUG [org.hibernate.jdbc.AbstractBatcher:426] about to open ResultSet (open ResultSets: 0, globally: 0)
2013-09-25 16:22:34,189 DEBUG [org.hibernate.loader.Loader:1322] result row: EntityKey[sii.hippoComp.server.domain.Competences#67]
2013-09-25 16:22:34,189 DEBUG [org.hibernate.jdbc.AbstractBatcher:433] about to close ResultSet (open ResultSets: 1, globally: 1)
2013-09-25 16:22:34,190 DEBUG [org.hibernate.jdbc.AbstractBatcher:418] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2013-09-25 16:22:34,190 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:271] checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,190 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,190 DEBUG [org.hibernate.jdbc.ConnectionManager:464] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2013-09-25 16:22:34,190 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,190 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,191 DEBUG [org.hibernate.engine.TwoPhaseLoad:130] resolving associations for [sii.hippoComp.server.domain.Competences#67]
2013-09-25 16:22:34,191 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,191 DEBUG [org.hibernate.loader.Loader:2022] loading entity: [sii.hippoComp.server.domain.Themes#14]
2013-09-25 16:22:34,191 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,191 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,192 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,192 DEBUG [org.hibernate.SQL:111] select themes0_.ID as ID11_1_, themes0_.CATEGORIE_ID as CATEGORIE6_11_1_, themes0_.DATECREATION as DATECREA2_11_1_, themes0_.DATEMODIFICATION as DATEMODI3_11_1_, themes0_.NOM as NOM11_1_, themes0_.VERSION as VERSION11_1_, categories1_.ID as ID0_0_, categories1_.DATECREATION as DATECREA2_0_0_, categories1_.DATEMODIFICATION as DATEMODI3_0_0_, categories1_.NOM as NOM0_0_, categories1_.VERSION as VERSION0_0_ from Themes themes0_ inner join Categories categories1_ on themes0_.CATEGORIE_ID=categories1_.ID where themes0_.ID=?
2013-09-25 16:22:34,193 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:179] com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache ----> CACHE HIT
2013-09-25 16:22:34,194 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:196] checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 1; num connections: 7; num keys: 50
2013-09-25 16:22:34,196 DEBUG [org.hibernate.jdbc.AbstractBatcher:426] about to open ResultSet (open ResultSets: 0, globally: 0)
2013-09-25 16:22:34,196 DEBUG [org.hibernate.loader.Loader:1322] result row: EntityKey[sii.hippoComp.server.domain.Categories#4], EntityKey[sii.hippoComp.server.domain.Themes#14]
2013-09-25 16:22:34,196 DEBUG [org.hibernate.jdbc.AbstractBatcher:433] about to close ResultSet (open ResultSets: 1, globally: 1)
2013-09-25 16:22:34,197 DEBUG [org.hibernate.jdbc.AbstractBatcher:418] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2013-09-25 16:22:34,197 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:271] checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,197 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,197 DEBUG [org.hibernate.jdbc.ConnectionManager:464] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2013-09-25 16:22:34,198 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,198 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,198 DEBUG [org.hibernate.engine.TwoPhaseLoad:130] resolving associations for [sii.hippoComp.server.domain.Categories#4]
2013-09-25 16:22:34,198 DEBUG [org.hibernate.engine.TwoPhaseLoad:255] done materializing entity [sii.hippoComp.server.domain.Categories#4]
2013-09-25 16:22:34,198 DEBUG [org.hibernate.engine.TwoPhaseLoad:130] resolving associations for [sii.hippoComp.server.domain.Themes#14]
2013-09-25 16:22:34,198 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:297] checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,199 DEBUG [org.hibernate.engine.TwoPhaseLoad:255] done materializing entity [sii.hippoComp.server.domain.Themes#14]
2013-09-25 16:22:34,199 DEBUG [org.hibernate.loader.Loader:2050] done entity load
2013-09-25 16:22:34,199 DEBUG [org.hibernate.engine.TwoPhaseLoad:255] done materializing entity [sii.hippoComp.server.domain.Competences#67]
2013-09-25 16:22:34,200 DEBUG [org.hibernate.engine.StatefulPersistenceContext:893] initializing non-lazy collections
2013-09-25 16:22:34,200 DEBUG [org.hibernate.jdbc.ConnectionManager:427] aggressively releasing JDBC connection
2013-09-25 16:22:34,200 DEBUG [org.hibernate.impl.SessionImpl:265] opened session at timestamp: 13801189542
2013-09-25 16:22:34,200 DEBUG [org.hibernate.transaction.JDBCTransaction:78] begin
2013-09-25 16:22:34,200 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,201 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)
2013-09-25 16:22:34,201 DEBUG [org.hibernate.transaction.JDBCTransaction:83] current autocommit status: true
2013-09-25 16:22:34,201 DEBUG [org.hibernate.transaction.JDBCTransaction:86] disabling autocommit
2013-09-25 16:22:34,202 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,202 DEBUG [org.hibernate.SQL:111] select groupescol0_.ID as ID4_, groupescol0_.DATECREATION as DATECREA2_4_, groupescol0_.DATEFIN as DATEFIN4_, groupescol0_.NOM as NOM4_, groupescol0_.VERSION as VERSION4_ from GroupesCollaborateurs groupescol0_ where groupescol0_.ID=? limit ?
2013-09-25 16:22:34,203 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:179] com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache ----> CACHE HIT
2013-09-25 16:22:34,203 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:196] checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 1; num connections: 7; num keys: 50
2013-09-25 16:22:34,204 DEBUG [org.hibernate.jdbc.AbstractBatcher:426] about to open ResultSet (open ResultSets: 0, globally: 0)
2013-09-25 16:22:34,205 DEBUG [org.hibernate.loader.Loader:1322] result row: EntityKey[sii.hippoComp.server.domain.GroupesCollaborateurs#19]
2013-09-25 16:22:34,205 DEBUG [org.hibernate.jdbc.AbstractBatcher:433] about to close ResultSet (open ResultSets: 1, globally: 1)
2013-09-25 16:22:34,205 DEBUG [org.hibernate.jdbc.AbstractBatcher:418] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2013-09-25 16:22:34,205 DEBUG [com.mchange.v2.c3p0.stmt.GooGooStatementCache:271] checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 7; num keys: 50
2013-09-25 16:22:34,205 DEBUG [org.hibernate.engine.TwoPhaseLoad:130] resolving associations for [sii.hippoComp.server.domain.GroupesCollaborateurs#19]
2013-09-25 16:22:34,205 DEBUG [org.hibernate.engine.TwoPhaseLoad:255] done materializing entity [sii.hippoComp.server.domain.GroupesCollaborateurs#19]
2013-09-25 16:22:34,206 DEBUG [org.hibernate.engine.StatefulPersistenceContext:893] initializing non-lazy collections
2013-09-25 16:22:34,206 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:890]  SOMMENOTE  	 | GroupesNotes.DateDebut 	 | GroupesNotes.DateFin  | GroupesNotes.NBCOLLAB 
2013-09-25 16:22:34,206 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:890]  SOMMENOTE  	 | GroupesNotes.DateDebut 	 | GroupesNotes.DateFin  | GroupesNotes.NBCOLLAB 
2013-09-25 16:22:34,206 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:895]   0		 | 2013-09-01 00:00:00 		 | null 		 | 1
2013-09-25 16:22:34,206 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:895]   0		 | 2013-09-01 00:00:00 		 | null 		 | 1
2013-09-25 16:22:34,206 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:318] *** - collaborateurDansGroupePourUneCompetence - ***
2013-09-25 16:22:34,206 DEBUG [sii.hippoComp.server.managerDao.GroupesNotesManager:318] *** - collaborateurDansGroupePourUneCompetence - ***
2013-09-25 16:22:34,206 DEBUG [org.hibernate.jdbc.AbstractBatcher:410] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2013-09-25 16:22:34,206 DEBUG [org.hibernate.jdbc.ConnectionManager:444] opening JDBC connection
2013-09-25 16:22:34,206 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:554] acquire test -- pool is already maxed out. [managed: 10; max: 10]
2013-09-25 16:22:34,207 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1291] awaitAvailable(): com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb
2013-09-25 16:22:34,207 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@92c979 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f590bb)

J'ai donc le sentiment que mon entityManager me donne une nouvelle transaction dans le DAO et que malgré le commit, il ne ferme pas celle qu'il vient d'ouvrir ...
Une idée ?

Fuite de connexions

JPA Java

Mode arborescent

Discussions similaires

Partager

Partager