org.h2.jdbc.JdbcSQLException

Table "NUMERATOR" not found; SQL statement: INSERT INTO application.NUMERATOR_DETAIL (SELECT t51.patient_id FROM application.NUMERATOR t51 INTERSECT ( SELECT t52.patient_id FROM application.PatientCharacteristicBirthdateBirthDate_precondition_77 t52 INTERSECT SELECT t53.patient_id FROM application.PatientCharacteristicBirthdateBirthDate_precondition_79 t53)) [42102-192]

Samebug tips1

Check if you're not creating unused SQL entities, as it might cause this exception.

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web1171

  • via Google Groups by Daniel Rosenbaum, 11 months ago
    Table "NUMERATOR" not found; SQL statement: INSERT INTO application.NUMERATOR_DETAIL (SELECT t51.patient_id FROM application.NUMERATOR t51 INTERSECT ( SELECT t52.patient_id FROM application.PatientCharacteristicBirthdateBirthDate_precondition_77
  • via Google Groups by Narahari 'n' Savitha, 1 year ago
    Table "TEST" not found; SQL statement: select * from test [42102-192]
  • Table "BOB" not found; SQL statement: SELECT * FROM bob [42102-192]
  • Stack trace

    • org.h2.jdbc.JdbcSQLException: Table "NUMERATOR" not found; SQL statement: INSERT INTO application.NUMERATOR_DETAIL (SELECT t51.patient_id FROM application.NUMERATOR t51 INTERSECT ( SELECT t52.patient_id FROM application.PatientCharacteristicBirthdateBirthDate_precondition_77 t52 INTERSECT SELECT t53.patient_id FROM application.PatientCharacteristicBirthdateBirthDate_precondition_79 t53)) [42102-192] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.schema.Schema.getTableOrView(Schema.java:436) at org.h2.command.Parser.readTableOrView(Parser.java:5371) at org.h2.command.Parser.readTableFilter(Parser.java:1257) at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1896) at org.h2.command.Parser.parseSelectSimple(Parser.java:2044) at org.h2.command.Parser.parseSelectSub(Parser.java:1890) at org.h2.command.Parser.parseSelectUnion(Parser.java:1711) at org.h2.command.Parser.parseSelect(Parser.java:1699) at org.h2.command.Parser.parseInsert(Parser.java:1058) at org.h2.command.Parser.parsePrepared(Parser.java:413) at org.h2.command.Parser.parse(Parser.java:317) at org.h2.command.Parser.parse(Parser.java:289) at org.h2.command.Parser.prepareCommand(Parser.java:254) at org.h2.engine.Session.prepareLocal(Session.java:560) at org.h2.engine.Session.prepareCommand(Session.java:501) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1202) at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:126) at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:115) at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120) at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java) at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:523) at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:520) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:534)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    2 times, 6 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Once, 1 week ago
    143 more bugmates