Exception No SuchElementException
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:
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.
