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 | 4 months ago
  1. 0

    Multi-Threading issues

    Google Groups | 4 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 | 3 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 | 6 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]

    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