You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATEPART (year, '2007-06-01')' at line 1
calls theList<TestService> list = service.getTests(date);
public List<TestService> getTests(String date) {
return testDAO.getTestsDetails(date);
}
public List<TestService> getTestsDetails(final String date) {
final List<TestService> details = (List<TestService>) find("from TestServiceTb t where t.modified= '?"
+ date+ "'");
return details== null ? new LinkedList<TestService>() : details;
}
) and here it breaks...i get a null pointer exception...don't get why ....public List<TestService> getTests(String date) {
return testDAO.getTestsDetails(date);
}
DEBUG HibernateSessionInterceptor(doFilter:52) - ---> cleaning-up session for request [27841632]
ERROR StandardWrapperValve(invoke:260) - Servlet.service() for servlet TestServlet threw exception
java.lang.NullPointerException
at fr.test.services.business.Test.getTestsDetails(TestServiceImpl.java:36)
at fr.test.web.TestServlet.createLastDayLog(TestServlet .java:439)
at dfr.test.web.TestServlet.showSomething(TestServlet .java:417)
at fr.test.web.TestServlet.doPost(TestServlet .java:228)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at fr.test.hibernate.HibernateSessionInterceptor.doFilter(HibernateSessionInterceptor.java:50)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)