l'erreur que l'on m'affiche lors de l'execution de la requete :
La procedure qui me retourne la liste des prestations dispo
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 org.apache.jasper.JasperException: could not execute query org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069) org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069) org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) cause mère org.hibernate.exception.SQLGrammarException: could not execute query org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) org.hibernate.loader.Loader.doList(Loader.java:1596) org.hibernate.loader.Loader.list(Loader.java:1577) org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:112) org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1414) org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:153) com.gh.service.PrestationService.listePrestationDispo(PrestationService.java:53) org.apache.jsp.clientPrestationSaisie_jsp._jspService(org.apache.jsp.clientPrestationSaisie_jsp:182) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069) org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069) org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
la page jsp :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9 public List listePrestationDispo(Date date_arrivee) { Session session=HibernateSessionFactory.currentSession(); List list = (List)session.createSQLQuery("SELECT code_prestation from Reservation" + " where DATE_ARRIVEE_PREVUE <= :uneDate").addScalar("code_prestation",Hibernate.INTEGER).setParameter("uneDate", "12/02/2010").list();// return (list); }
l'erreur est due a quoi??
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 <tr> <td class="row2"> <strong> Liste des prestations disponibles </strong></td> <% PrestationService ps=new PrestationService(); Iterator it=(ps.listePrestationDispo(new Date())).iterator(); %> <td class="row2"> <html:select property="code_prestation" > <%while(it.hasNext()) { %> <html:option value="<%= it.next().toString() %>" > </html:option> <%}%> </html:select> </td> </tr>
merci d'avance![]()
Partager