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]

Google Groups | Daniel Rosenbaum | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Multi-Threading issues

    Google Groups | 9 months ago | Daniel Rosenbaum
    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]
  2. 0

    Inserting data into a H2 Database Table

    Stack Overflow | 4 years ago | Oliver Muchai
    org.h2.jdbc.JdbcSQLException: Column "DATABASE" not found; SQL statement: INSERT INTO MYLOVELYSTUDENTS VALUES (123456789, 'Zara', 'Ali', 18, database) [42122-173]
  3. 0

    long not accepted as data type

    GitHub | 2 years ago | GoogleCodeExporter
    org.h2.jdbc.JdbcSQLException: Unknown data type: ); SQL statement: CREATE TABLE test (id LONG) [50004-113]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Mitglieder löschen - Fehlermeldung - JVerein

    jverein.de | 10 months ago
    org.h2.jdbc.JdbcSQLException: Referentielle Integrität verletzt: FKABRECHNUNG1: PUBLIC.ABRECHNUNG FOREIGN KEY(MITGLIED) REFERENCES PUBLIC.MITGLIED(ID) Referential integrity constraint violation: FKABRECHNUNG1: PUBLIC.ABRECHNUNG FOREIGN KEY(MITGLIED) REFERENCES PUBLIC.MITGLIED(ID); SQL statement: delete from MITGLIED where ID = 1760 [23003-117]
  6. 0

    I had org.h2.jdbc.JdbcSQLException on update 1.5 to 1.6

    GitHub | 4 years ago | teaplanet
    org.h2.jdbc.JdbcSQLException: テーブル "ACCOUNT" はすでに存在します Table "ACCOUNT" already exists; SQL statement: CREATE TABLE ACCOUNT( USER_NAME VARCHAR(100) NOT NULL, MAIL_ADDRESS VARCHAR(100) NOT NULL, ... [42101-171]

  1. andyglick 3 times, last 3 months ago
3 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. H2 Database Engine
    JdbcStatement.executeUpdate
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    2. org.h2.message.DbException.get(DbException.java:179)
    3. org.h2.message.DbException.get(DbException.java:155)
    4. org.h2.schema.Schema.getTableOrView(Schema.java:436)
    5. org.h2.command.Parser.readTableOrView(Parser.java:5371)
    6. org.h2.command.Parser.readTableFilter(Parser.java:1257)
    7. org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1896)
    8. org.h2.command.Parser.parseSelectSimple(Parser.java:2044)
    9. org.h2.command.Parser.parseSelectSub(Parser.java:1890)
    10. org.h2.command.Parser.parseSelectUnion(Parser.java:1711)
    11. org.h2.command.Parser.parseSelect(Parser.java:1699)
    12. org.h2.command.Parser.parseInsert(Parser.java:1058)
    13. org.h2.command.Parser.parsePrepared(Parser.java:413)
    14. org.h2.command.Parser.parse(Parser.java:317)
    15. org.h2.command.Parser.parse(Parser.java:289)
    16. org.h2.command.Parser.prepareCommand(Parser.java:254)
    17. org.h2.engine.Session.prepareLocal(Session.java:560)
    18. org.h2.engine.Session.prepareCommand(Session.java:501)
    19. org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1202)
    20. org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:126)
    21. org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:115)
    21 frames
  3. HikariCP-java6
    HikariProxyStatement.executeUpdate
    1. com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
    2. com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
    2 frames
  4. Spring Framework
    JdbcTemplate.update
    1. org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:523)
    2. org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:520)
    3. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404)
    4. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:534)
    4 frames