l'erreur que l'on m'affiche lors de l'execution de la requete :
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 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
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);
 
	}
la page jsp :
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>
l'erreur est due a quoi??
merci d'avance