caused By:java.sql.SQLException:Parameter index out of range (1 > number of parameters, which is 0

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 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: Parameter index out of range (1 > number of parameters, which are 0). At Com.mysql.jdbc.SQLError.createSQLException (Sqler ror.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.PreparedStatement.checkBounds (preparedstatement.java:3805) at Com.mysql.jdbc.PreparedStatement.setInternal (preparedstatement.java:3787) at Com.mysql.jdbc.PreparedStatement.setString (preparedstatement.java:4608) at Org.apache.commons.dbcp.DelegatingPreparedStatement.setString (delegatingpreparedstatement.java:131) 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

3. Solutions

caused By:java.sql.SQLException:Parameter index out of range (1 > number of parameters, which is 0