Discussion :

[ijklm]

Salut, j'ai l'exception suivante que je ne compred pas du tout :

[com.clickoptions.web.action.newsanalysis.PerfsDBDAction] java.util.NoSuchElementException : null
2007/02/08 18:07:36.232 ERROR INTERNAL Exception java.util.NoSuchElementException
at java.util.AbstractList$Itr.next(Unknown Source)
at com.clickoptions.web.action.newsanalysis.PerfsDBDAction.execute(PerfsDBDAction.java:117)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.clickoptions.web.filter.TrackingFilter.doFilter(TrackingFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.clickoptions.web.filter.ResourceBundleFilter.doFilter(ResourceBundleFilter.java:223)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.clickoptions.web.filter.XSSFilter.doFilter(XSSFilter.java:114)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.clickoptions.web.filter.IPFilter.doFilter(IPFilter.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

Je poste le code quui permet de faire le select :

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
   connection = WebConnectionPool.getSQLConnection();
            statement = connection.createStatement();
            String sql = "SELECT CONVERT(CHAR(7), BUY_DATE, 111), COUNT(*), AVG(BUY_PRICE)";
            sql += " FROM PERFS_DBD_WEB WHERE ((BUY_DATE >= '"
                    + sd.format(startDateSelectedMonth) + "' AND BUY_DATE < '" +  sd.format(startDateFollowingSelectedMonth)
                    + "') OR BUY_DATE >= '" + sd.format(startDateCurrentMonth) 
                    + "') AND UNDER_ID !=0 GROUP BY CONVERT(CHAR(7), BUY_DATE, 111) ORDER BY CONVERT(CHAR(7), BUY_DATE, 111)";
 
            ResultSet rs = statement.executeQuery(sql);
 
            int rssize = 0;
 
 
            	if (rs.next()) {
            		rssize++;
            		monthResults2.setNbOperations(rs.getInt(2));
            		monthResults2.setAverageAcqPrice(rs.getDouble(3));
            	}
 
 
            if (rs.next()) {
                rssize++;
                monthResults1.setNbOperations(rs.getInt(2));
                monthResults1.setAverageAcqPrice(rs.getDouble(3));
            }

Quelqu'un voit d'ou vient l'erreur ?
Merci pour votre aide.

[the-gtm]

Regarde la ligne de code ou est lancé l'exception, ce n'est pas dans le code que tu as posté.
La doc de Iterator.next() :

E next()

Returns the next element in the iteration. Calling this method repeatedly until the hasNext() method returns false will return each element in the underlying collection exactly once.

Returns:
the next element in the iteration.
Throws:
NoSuchElementException - iteration has no more elements.