org.h2.jdbc.JdbcSQLException: Numeric value out of range: "1470033680022"; SQL statement: delete from test where big_number < ? - small_number * 1000 [22003-192]

Google Groups | Vedran Pavić | 8 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

    Numeric value out of range error (22003) on DELETE with expression in WHERE clause

    Google Groups | 8 months ago | Vedran Pavić
    org.h2.jdbc.JdbcSQLException: Numeric value out of range: "1470033680022"; SQL statement: delete from test where big_number < ? - small_number * 1000 [22003-192]
  2. 0

    h2 database bit wise operation(&) invalid syntax MySql

    Stack Overflow | 3 years ago | SkorpEN
    org.h2.jdbc.JdbcSQLException: General error SQL statement: SELECT * FROM cars WHERE status &amp; 128 [50000-181]
  3. 0

    GitHub comment 1748#200566988

    GitHub | 1 year ago | camsaul
    org.h2.jdbc.JdbcSQLException: Table "DEPENDENCY" not found; SQL statement: SELECT "DEPENDENCY".* FROM "DEPENDENCY" [42102-191]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Can't create nations

    GitHub | 5 months ago | GershonR
    org.h2.jdbc.JdbcSQLException: printStackTrace:80]:
  6. 0

    Add test / example showing ... transaction.setPersistCascade(false) and transaction.commitAndContinue();

    GitHub | 8 months ago | rbygrave
    org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_MNY_B_MNY_C_MNY_C: PUBLIC.MNY_B_MNY_C FOREIGN KEY(MNY_C_ID) REFERENCES PUBLIC.MNY_C(ID) (9223372036854775807)"; SQL statement: insert into mny_b_mny_c (mny_b_id, mny_c_id) values (?, ?) [23506-192]

  1. andyglick 14 times, last 2 months ago
1 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

    Numeric value out of range: "1470033680022"; SQL statement: delete from test where big_number < ? - small_number * 1000 [22003-192]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    DbException.getJdbcSQLException
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    1 frame