Forum Discussion

d19price's avatar
d19price
Occasional Contributor
2 months ago
Solved

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

  • Resolved by moving contents of \.readyapi\data to the trash & re-starting ReadyAPI.

1 Reply

  • d19price's avatar
    d19price
    Occasional Contributor

    Resolved by moving contents of \.readyapi\data to the trash & re-starting ReadyAPI.