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 | 7 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Multi-Threading issues

    Google Groups | 7 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 | 8 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 | 3 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 1 month 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