Configuration du fichier context.xml de Tomcat pour la connexion à la BDD

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
 
janv. 17, 2014 5:31:39 PM org.openxava.controller.ModuleManager manageRegularException
Grave: Transaction marked as rollbackOnly
javax.persistence.RollbackException: Transaction marked as rollbackOnly
	at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:73)
	at org.openxava.jpa.XPersistence.commit(XPersistence.java:136)
	at org.openxava.controller.ModuleManager.doCommit(ModuleManager.java:668)
	at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:517)
	at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:318)
	at org.openxava.controller.ModuleManager.execute(ModuleManager.java:278)
	at org.apache.jsp.xava.execute_jsp._jspService(execute_jsp.java:180)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
	at org.openxava.web.servlets.Servlets.getURIAsStream(Servlets.java:66)
	at org.openxava.web.dwr.Module.getURIAsStream(Module.java:204)
	at org.openxava.web.dwr.Module.request(Module.java:62)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
	at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
	at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
	at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
	at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
	at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
	at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:744)
 
janv. 17, 2014 5:31:39 PM org.openxava.controller.ModuleManager execute
PrÃ©cis: Execute Mode.detailAndFirst=11 ms
janv. 17, 2014 5:31:39 PM org.openxava.util.Labels get
Avertissement: Impossible to translate element with id dateachatvehicule
janv. 17, 2014 5:31:39 PM org.openxava.util.Labels get
Avertissement: Impossible to translate element with id dateamortissement
janv. 17, 2014 5:31:39 PM org.openxava.util.Labels get
Avertissement: Impossible to translate element with id nom
janv. 17, 2014 5:31:39 PM org.openxava.util.Labels get
Avertissement: Impossible to translate element with id modele1
janv. 17, 2014 5:31:39 PM org.openxava.util.Labels get
Avertissement: Impossible to translate element with id nom
janv. 17, 2014 5:31:39 PM org.openxava.util.Labels get
Avertissement: Impossible to translate element with id marque1
janv. 17, 2014 5:31:39 PM org.openxava.util.Labels get
Avertissement: Impossible to translate element with id modele1
janv. 17, 2014 5:31:39 PM org.openxava.util.Labels get
Avertissement: Impossible to translate element with id dateachatvehicule
janv. 17, 2014 5:31:39 PM org.openxava.util.Labels get
Avertissement: Impossible to translate element with id dateamortissement
janv. 17, 2014 5:31:39 PM org.openxava.util.Labels get
Avertissement: Impossible to translate element with id nom
janv. 17, 2014 5:31:39 PM org.openxava.util.Labels get
Avertissement: Impossible to translate element with id nom
janv. 17, 2014 5:31:39 PM org.openxava.tab.impl.JPATabProvider nextBlock
PrÃ©cis: [JPATabProvider.nextBlock] Executing SELECT e.idVehicule, e.immatriculation, e.dateachatvehicule, e.dateamortissement, e_modele1.nom, e.energie, e.coutvehicule, e.couleur, e_modele1_marque1.nom, e_utilite1.description from Vehicule e left join e.modele1 e_modele1 left join e_modele1.marque1 e_modele1_marque1 left join e.utilite1 e_utilite1 with arguments 
janv. 17, 2014 5:31:39 PM org.hibernate.util.JDBCExceptionReporter logExceptions
Avertissement: SQL Error: 1146, SQLState: 42S02
janv. 17, 2014 5:31:39 PM org.hibernate.util.JDBCExceptionReporter logExceptions
Grave: Table 'flotte.Vehicule' doesn't exist
janv. 17, 2014 5:31:39 PM org.openxava.tab.impl.JPATabProvider nextChunk
Grave: Fail executing SELECT e.idVehicule, e.immatriculation, e.dateachatvehicule, e.dateamortissement, e_modele1.nom, e.energie, e.coutvehicule, e.couleur, e_modele1_marque1.nom, e_utilite1.description from Vehicule e left join e.modele1 e_modele1 left join e_modele1.marque1 e_modele1_marque1 left join e.utilite1 e_utilite1
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1389)
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1317)
	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255)
	at org.openxava.tab.impl.JPATabProvider.nextBlock(JPATabProvider.java:170)
	at org.openxava.tab.impl.JPATabProvider.nextChunk(JPATabProvider.java:139)
	at org.openxava.tab.impl.EntityTabDataProvider.nextChunk(EntityTabDataProvider.java:32)
	at org.openxava.tab.impl.EntityTab.nextChunk(EntityTab.java:249)
	at org.openxava.tab.impl.TableModelBean.getRow(TableModelBean.java:121)
	at org.openxava.tab.impl.TableModelBean.getValueAt(TableModelBean.java:172)
	at org.openxava.tab.impl.XTableModelDecoratorBase.getValueAt(XTableModelDecoratorBase.java:63)
	at org.openxava.tab.impl.HiddenXTableModel.getValueAt(HiddenXTableModel.java:70)
	at org.openxava.tab.Tab.createTableModel(Tab.java:348)
	at org.openxava.tab.Tab.getTableModel(Tab.java:320)
	at org.apache.jsp.xava.editors.listEditor_jsp._jspService(listEditor_jsp.java:898)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
	at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
	at org.apache.jsp.xava.list_jsp._jspService(list_jsp.java:81)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
	at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
	at org.apache.jsp.xava.core_jsp._jspService(core_jsp.java:300)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
	at org.openxava.web.servlets.Servlets.getURIAsString(Servlets.java:120)
	at org.openxava.web.servlets.Servlets.getURIAsString(Servlets.java:99)
	at org.openxava.web.dwr.Module.getURIAsString(Module.java:210)
	at org.openxava.web.dwr.Module.fillResult(Module.java:232)
	at org.openxava.web.dwr.Module.request(Module.java:95)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
	at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
	at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
	at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
	at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
	at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
	at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:744)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2545)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246)
	... 89 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'flotte.Vehicule' doesn't exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
	at org.hibernate.loader.Loader.doQuery(Loader.java:802)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2542)
	... 97 more
 
janv. 17, 2014 5:31:39 PM org.openxava.tab.impl.EntityTabDataProvider nextChunk
Grave: Fail executing SELECT e.idVehicule, e.immatriculation, e.dateachatvehicule, e.dateamortissement, e_modele1.nom, e.energie, e.coutvehicule, e.couleur, e_modele1_marque1.nom, e_utilite1.description from Vehicule e left join e.modele1 e_modele1 left join e_modele1.marque1 e_modele1_marque1 left join e.utilite1 e_utilite1
java.rmi.RemoteException: Fail executing SELECT e.idVehicule, e.immatriculation, e.dateachatvehicule, e.dateamortissement, e_modele1.nom, e.energie, e.coutvehicule, e.couleur, e_modele1_marque1.nom, e_utilite1.description from Vehicule e left join e.modele1 e_modele1 left join e_modele1.marque1 e_modele1_marque1 left join e.utilite1 e_utilite1
	at org.openxava.tab.impl.JPATabProvider.nextChunk(JPATabProvider.java:146)
	at org.openxava.tab.impl.EntityTabDataProvider.nextChunk(EntityTabDataProvider.java:32)
	at org.openxava.tab.impl.EntityTab.nextChunk(EntityTab.java:249)
	at org.openxava.tab.impl.TableModelBean.getRow(TableModelBean.java:121)
	at org.openxava.tab.impl.TableModelBean.getValueAt(TableModelBean.java:172)
	at org.openxava.tab.impl.XTableModelDecoratorBase.getValueAt(XTableModelDecoratorBase.java:63)
	at org.openxava.tab.impl.HiddenXTableModel.getValueAt(HiddenXTableModel.java:70)
	at org.openxava.tab.Tab.createTableModel(Tab.java:348)
	at org.openxava.tab.Tab.getTableModel(Tab.java:320)
	at org.apache.jsp.xava.editors.listEditor_jsp._jspService(listEditor_jsp.java:898)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
	at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
	at org.apache.jsp.xava.list_jsp._jspService(list_jsp.java:81)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
	at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
	at org.apache.jsp.xava.core_jsp._jspService(core_jsp.java:300)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
	at org.openxava.web.servlets.Servlets.getURIAsString(Servlets.java:120)
	at org.openxava.web.servlets.Servlets.getURIAsString(Servlets.java:99)
	at org.openxava.web.dwr.Module.getURIAsString(Module.java:210)
	at org.openxava.web.dwr.Module.fillResult(Module.java:232)
	at org.openxava.web.dwr.Module.request(Module.java:95)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
	at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
	at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
	at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
	at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
	at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
	at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:744)

par contre je ne vois pas de fichier catanila.conf dans $CATALINA_HOME.
excusez moi mais je ne comprends pas ce que vous appellez mon repertoire de déploiement;je ne sais pas si c'est l'arborescence de mon projet ou alors autre chose??
merci de m'aider

A de nombreux endroits, tu as ce message, ou quelque chose de similaire:

Code:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'flotte.Vehicule' doesn't exist

Est-ce que les tables Vehicule et compagnie on bien été créées dans ta base de donnée mysql et estce que la database s'appelle bien "flotte" ??

Aussi, il n'est pas courant en mysql d'appeler une table par son nom complet. Il faudrait voir dans la configuration de ton application si il n'y a pas une option genre "database schema" ou autre qui a été remplie au lieu d'être laissée vide.

Citation:

Est-ce que les tables Vehicule et compagnie on bien été créées dans ta base de donnée mysql et estce que la database s'appelle bien "flotte" ??

Aussi, il n'est pas courant en mysql d'appeler une table par son nom complet. Il faudrait voir dans la configuration de ton application si il n'y a pas une option genre "database schema" ou autre qui a été remplie au lieu d'être laissée vide.

toutes ces tables existent dans la base de données flotte qui a été au préalable générée à partir des classes dans mon environnement de développement en local et puis exporté dans mysql de production.
voici le code du fichier build.xml qui permet de générer la base de données dans Mysql:
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 <?xml version="1.0"?> <project name="Fleet" basedir="." default="deployWar"> <property name="project" value="Fleet" /> <property name="ox3" value="true" /> <property file="../openxava.properties"/>  <target name="compile"> <ant antfile="../OpenXava/build.xml" target="compile"/> </target>  <target name="deployWar">  <ant antfile="../OpenXava/build.xml" target="deploy"/>  </target>  <target name="generatePortlets"> <ant antfile="../OpenXava/build.xml" target="generatePortlets"/> </target>  <target name="updateOX"> <ant antfile="../OpenXava/build.xml" target="updateOX"/> </target>  <target name="updateSchema"> <ant antfile="../OpenXava/build.xml" target="updateSchemaJPA"> <property name="persistence.unit" value="junit"/> <property name="schema.path" value="../Fleet/lib/mysql-connector-java-5.1.12-bin.jar"/> </ant> </target> <target name="createWar"> <ant antfile="../OpenXava/build.xml" target="createWar"/> </target> </project>

en tout cas, clairement, mysql te dit que la table n'existe pas. Donc soit elle n'existe pas, soit tu ne pointe pas vers la bonne database, soit la database ne s'appelle pas flotte.

Tu peux te connecter sur la DB de production et faire un select * from flotte.Vehicule ?

Citation:

Tu peux te connecter sur la DB de production et faire un select * from flotte.Vehicule ?

merci d'être si patient avec moi pour mon problème tchize_
mais j'ai fait un select dans la base de données de production et il fonctionne bien!!
Code:

1 2 3 4 Affichage des enregistrements 0 - 2 (~31 total, Traitement en 0.0002 sec.) SELECT * FROM flotte.vehicule LIMIT 0 , 30
je ne sais plus à quel niveau ça cloche vraiment!!!
mais merci pour votre disponibilité!!!
vous êtes très sympa tchize_!!!

Je suis perplexe.

Tu pourrais nous montrer ton mapping hibernate?

je vois que tu utilises ceci pour te connecter a la base de données:

Code:

url="jdbc:mysql://localhost:3306/parc"

est ce ok?

Eric

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
<?xml version="1.0" encoding="UTF-8"?>
 
 
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
             version="1.0">
 
    <!-- Tomcat + Hypersonic -->
    <persistence-unit name="default">
    	<provider>org.hibernate.ejb.HibernatePersistence</provider>
    	<non-jta-data-source>java:comp/env/jdbc/FleetDS</non-jta-data-source>
    	<class>org.openxava.session.GalleryImage</class>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
        </properties>
    </persistence-unit>    
 
    <!-- JBoss + Hypersonic 
    <persistence-unit name="default">
    	<provider>org.hibernate.ejb.HibernatePersistence</provider>
    	<non-jta-data-source>java:/FleetDS</non-jta-data-source>
    	<class>org.openxava.session.GalleryImage</class>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect"/>
        </properties>
    </persistence-unit>    
    -->
 
    <!-- WebSphere + AS/400 
    <persistence-unit name="default">
    	<provider>org.hibernate.ejb.HibernatePersistence</provider>
    	<non-jta-data-source>jdbc/FleetDS</non-jta-data-source>
    	<class>org.openxava.session.GalleryImage</class>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.DB2400Dialect"/>
            <property name="hibernate.show_sql" value="false"/>
        </properties>
    </persistence-unit>
    -->
 
    <!-- JUnit Hypersonic -->
       <persistence-unit name="junit">
    	<provider>org.hibernate.ejb.HibernatePersistence</provider>
        <properties>
			<property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
			<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
			<property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/flotte"/>
			<property name="hibernate.connection.username" value="name"/> 
            <property name="hibernate.connection.password" value="pass"/>
        </properties>
    </persistence-unit>   
 
 
</persistence>

tchize_ merci de me répondre!!
plus haut c'est mon fichier persistance.xml pour la mapping;
jeffray03 peut être c'est ça la source de mes problèmes!!!j'ai une autre base de données nommée parc en local!!!mais je ne vois pas à quel niveau j'ai mis

Code:

url="jdbc:mysql://localhost:3306/parc"

dans mes fichiers persistance.xml et context.xml j'ai mis

Code:

url="jdbc:mysql://localhost:3306/flotte"

Ok, c'est confus, et j'ai du mal à voir ce que tu fais.

Tout d'abord, tu as deux persistence units dans ton fichier de config => un appelé junit qui pointe sur flotte et un par défaut qui pointe sur java:comp/env/jdbc/FleetDS.

Il nous faut plus de code pour savoir lequel tu utilise. J'aurais besoin:

du mapping de ta classe Vehicule
que tu active le debug dans hibernate (<property name="show_sql">true</property>) afin qu'on voie les requetes SQL que fait hibernate
De la manière dont tu récupère ton peristence unit (qu'on sache lequel est utilisé)