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ć | 9 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

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

    Google Groups | 9 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 | 6 months ago | GershonR
    org.h2.jdbc.JdbcSQLException: printStackTrace:80]:
  6. 0

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

    GitHub | 9 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 3 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