org.h2.jdbc.JdbcSQLException: Table "SALE_TRANSACTION" not found; SQL statement: insert into sale_transaction (tran_id, store_id, workstation, day, seq) values (1000, '001', '3', '2014-03-21', 100) [42102-176]

symmetricds | mike182764 | 2 months ago
  1. 1

    SymmetricDS 3.8 demo not working

    symmetricds | 2 months ago | mike182764
    org.h2.jdbc.JdbcSQLException: Table "SALE_TRANSACTION" not found; SQL statement: insert into sale_transaction (tran_id, store_id, workstation, day, seq) values (1000, '001', '3', '2014-03-21', 100) [42102-176]
  2. 0

    mvcc

    Google Groups | 6 years ago | Rami Ojares
    org.h2.jdbc.JdbcSQLException: Cannot change the setting "MVCC" when the database is already open; SQL statement: SET MVCC TRUE [90133-147]
  3. 0

    しばらく使っているとInternal Server Errorが出る

    GitHub | 2 years ago | yoshimov
    org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Transaction is closed [1.4.183/4]"; SQL statement: ROLLBACK [50000-183]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    H2 db: how to run a SQL script in the current directory

    Stack Overflow | 3 years ago | Micdev42
    org.h2.jdbc.JdbcSQLException: IO Exception: "java.io. FileNotFoundException: resource /DropSchemas.sql"; "classpath:/DropSchemas.sql"; SQL statement:</p> <pre><code>runscript from 'classpath:/DropSchemas.sql' [90031-172]
  6. 0

    H2: "data conversion error" in WHERE clause

    Stack Overflow | 4 years ago | Victor Nedioglo
    org.h2.jdbc.JdbcSQLException: Data conversion error converting "USA"; SQL statement: select * from table_country c where c.code&gt;0 AND 'USA' = c.name(+) [22018-170]

  1. andyglick 352 times, last 9 months ago
16 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 "SALE_TRANSACTION" not found; SQL statement: insert into sale_transaction (tran_id, store_id, workstation, day, seq) values (1000, '001', '3', '2014-03-21', 100) [42102-176]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    TcpServerThread.run
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
    2. org.h2.message.DbException.get(DbException.java:178)
    3. org.h2.message.DbException.get(DbException.java:154)
    4. org.h2.command.Parser.readTableOrView(Parser.java:5213)
    5. org.h2.command.Parser.readTableOrView(Parser.java:5190)
    6. org.h2.command.Parser.parseInsert(Parser.java:1024)
    7. org.h2.command.Parser.parsePrepared(Parser.java:402)
    8. org.h2.command.Parser.parse(Parser.java:306)
    9. org.h2.command.Parser.parse(Parser.java:278)
    10. org.h2.command.Parser.prepareCommand(Parser.java:243)
    11. org.h2.engine.Session.prepareLocal(Session.java:442)
    12. org.h2.server.TcpServerThread.process(TcpServerThread.java:265)
    13. org.h2.server.TcpServerThread.run(TcpServerThread.java:160)
    13 frames
  3. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame