ReadyAPI 3.62.0 - org.springframework.jdbc.BadSqlGrammarException
After upgrading from ReadyAPI 3.58.0 to ReadyAPI 3.62.0 all tests result in this error. ReadyAPI bug in ReadyAPI 3.62.0? Fri Sep 05 10:43:58 CEST 2025: ERROR: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select count(*) from testcase where model_item_id=?] org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select count(*) from testcase where model_item_id=?] at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:103) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:107) at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1556) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:677) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:723) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:748) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:804) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:252) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:269) at com.smartbear.ready.db.repository.jdbc.dashboard.JdbcTestCaseRepository.hasTestCase(JdbcTestCaseRepository.java:98) at com.smartbear.ready.db.repository.jdbc.dashboard.JdbcTestCaseRepository.addDistinct(JdbcTestCaseRepository.java:65) at com.eviware.soapui.impl.wsdl.history.TestRunResultDbCollector.a(TestRunResultDbCollector.java:330) at com.eviware.soapui.impl.wsdl.history.TestRunResultDbCollector.d(TestRunResultDbCollector.java:302) at com.eviware.soapui.impl.wsdl.history.TestRunResultDbCollector.afterRun(TestRunResultDbCollector.java:150) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.notifyAfterRun(AbstractTestCaseRunner.java:412) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalFinally(AbstractTestCaseRunner.java:232) at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.internalFinally(WsdlTestCaseRunner.java:108) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalFinally(AbstractTestCaseRunner.java:1) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:169) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:840) Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "TESTCASE" not found; SQL statement: select count(*) from testcase where model_item_id=? [42102-224] at org.h2.message.DbException.getJdbcSQLException(DbException.java:514) at org.h2.message.DbException.getJdbcSQLException(DbException.java:489) at org.h2.message.DbException.get(DbException.java:223) at org.h2.message.DbException.get(DbException.java:199) at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8064) at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8035) at org.h2.command.Parser.readTableOrView(Parser.java:8024) at org.h2.command.Parser.readTablePrimary(Parser.java:1788) at org.h2.command.Parser.readTableReference(Parser.java:2268) at org.h2.command.Parser.parseSelectFromPart(Parser.java:2718) at org.h2.command.Parser.parseSelect(Parser.java:2824) at org.h2.command.Parser.parseQueryPrimary(Parser.java:2708) at org.h2.command.Parser.parseQueryTerm(Parser.java:2564) at org.h2.command.Parser.parseQueryExpressionBody(Parser.java:2543) at org.h2.command.Parser.parseQueryExpressionBodyAndEndOfQuery(Parser.java:2536) at org.h2.command.Parser.parseQueryExpression(Parser.java:2529) at org.h2.command.Parser.parseQuery(Parser.java:2498) at org.h2.command.Parser.parsePrepared(Parser.java:627) at org.h2.command.Parser.parse(Parser.java:592) at org.h2.command.Parser.parse(Parser.java:564) at org.h2.command.Parser.prepareCommand(Parser.java:483) at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:639) at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:559) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1166) at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93) at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:316) at org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImpl.createPreparedStatement(PreparedStatementCreatorFactory.java:239) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:656) ... 20 more
ReadyAPI external certification
Im planning to take up ReadyAPI latest certification. Please help me with below questions. What is the latest certificate name? Is it paid? If yes, what is the fee of certification? Where can I go and take the certification? What is the certifications exams question's structure? Once I paid the fee, how many times I can take up the certification exam?
How to hit update service multiple time with different data set.
How to hit update service multiple time with different data set, Data set needs to be taken from the response of search API. (First I need to hit search API, response of search API contains multiple records. now I want to hit Update API for all the records, in update request I need to pass record ID and some other data from the response of search API)