Caused By:java.sql.SQLException:ResultSet is the from UPDATE. No Data.

1. Error description

Org.hibernate.exception.GenericJDBCException:error executing Workat Org.hibernate.exception.internal.StandardSQLExceptionConverter.convert (standardsqlexceptionconverter.java:54) At Org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert (sqlexceptionhelper.java:126) at Org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert (sqlexceptionhelper.java:112) at Org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork (jdbccoordinatorimpl.java:318) at Org.hibernate.internal.SessionImpl.doWork (sessionimpl.java:2059) at Org.hibernate.internal.SessionImpl.doReturningWork (sessionimpl.java:2055) at Com.skycloud.oa.base.dao.impl.BaseDaoImpl.executeQuery (basedaoimpl.java:137) at Com.skycloud.oa.task.dao.impl.TaskTimeDaoImpl.addTaskData (tasktimedaoimpl.java:59) at Com.skycloud.oa.test.task.dao.TaskTimeDaoTest.testAddTaskData (tasktimedaotest.java:71) at SUN.REFLECT.NATIVEMETHODACCESSORIMPL.INVOKE0 (Native Method) at Sun.reflect.NativeMethodAccessorImpl.invoke ( nativemethodaccessorimpl.java:57) at Sun. reflect. Delegatingmethodaccessorimpl.invoke (delegatingmethodaccessorimpl.java:43) at Java.lang.reflect.Method.invoke ( method.java:606) at Org.junit.runners.model.frameworkmethod$1.runreflectivecall (frameworkmethod.java:47) at Org.junit.internal.runners.model.ReflectiveCallable.run (Reflectivecallable.java:12) at Org.junit.runners.model.FrameworkMethod.invokeExplosively (frameworkmethod.java:44) at Org.junit.internal.runners.statements.InvokeMethod.evaluate (invokemethod.java:17) at Org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate ( runbeforetestmethodcallbacks.java:74) at Org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate ( runaftertestmethodcallbacks.java:83) at Org.springframework.test.context.junit4.statements.SpringRepeat.evaluate (springrepeat.java:72) at Org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild ( springjunit4classrunner.java:233) at Org.springframework.test.context.junit4.SpringJUnit4ClassRunNer.runchild (springjunit4classrunner.java:87) at Org.junit.runners.parentrunner$3.run (ParentRunner.java:238) at Org.junit.runners.parentrunner$1.schedule (parentrunner.java:63) at Org.junit.runners.ParentRunner.runChildren ( parentrunner.java:236) at org.junit.runners.parentrunner.access$000 (parentrunner.java:53) at Org.junit.runners.parentrunner$2.evaluate (parentrunner.java:229) at Org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate ( RUNBEFORETESTCLASSCALLBACKS.JAVA:61) at Org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate ( runaftertestclasscallbacks.java:71) at Org.junit.runners.ParentRunner.run (parentrunner.java:309) at Org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run (springjunit4classrunner.java:176) at Org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run (JUNIT4TESTREFERENCE.JAVA:50) at Org.eclipse.jdt.internal.junit.runner.TestExecution.run (testexecution.java:38) at Org.eclipse.jdt.internal.junit.rUnner. Remotetestrunner.runtests (remotetestrunner.java:459) at Org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests (remotetestrunner.java:675) at Org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run (remotetestrunner.java:382) at Org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main (remotetestrunner.java:192) caused by: Java.sql.SQLException:ResultSet is from UPDATE. No data.at com.mysql.jdbc.SQLError.createSQLException (sqlerror.java:1074) at Com.mysql.jdbc.SQLError.createSQLException (sqlerror.java:988) at Com.mysql.jdbc.SQLError.createSQLException ( sqlerror.java:974) at Com.mysql.jdbc.SQLError.createSQLException (sqlerror.java:919) at Com.mysql.jdbc.ResultSetImpl.next (resultsetimpl.java:6998) at Org.apache.commons.dbcp.DelegatingResultSet.next ( delegatingresultset.java:168) at Com.skycloud.oa.base.dao.impl.BaseDaoImpl.doMapResult (basedaoimpl.java:250) at Com.skycloud.oa.base.dao.impl.basedaoimpl.access$0 (basedaoimpl.java:233) at Com.skycloud.oa.base.dao.impl.basedaoimpl$2.execuTe (basedaoimpl.java:148) at Com.skycloud.oa.base.dao.impl.basedaoimpl$2.execute (basedaoimpl.java:1) at Org.hibernate.jdbc.WorkExecutor.executeReturningWork (workexecutor.java:72) at Org.hibernate.internal.SessionImpl $3.accept (sessionimpl.java:2052) at Org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork ( jdbccoordinatorimpl.java:313) ... More

2. Cause of error

In the write stored procedure, the input parameter has two, StartDate and EndDate, but in the stored procedure the query statement does not have the input parameter, causes the error

3. Solutions

Add where after the query statement in the stored procedure, plus the StartDate and EndDate parameters

Caused By:java.sql.SQLException:ResultSet is the from UPDATE. No Data.