java.sql.SQLException: Wrong data type in statement \[INSERT INTO PERSON (PERSONID,PASSWORD,VITAL,ENABLED,DEFAULTTALLGROUPID,EXPIRATIONDATE) VALUES (1, 'frodo', 1, 1, 1, 90000000000)\]

hsqldb | johansend | 1 decade ago
  1. 0

    Integer size limit

    hsqldb | 1 decade ago | johansend
    java.sql.SQLException: Wrong data type in statement \[INSERT INTO PERSON (PERSONID,PASSWORD,VITAL,ENABLED,DEFAULTTALLGROUPID,EXPIRATIONDATE) VALUES (1, 'frodo', 1, 1, 1, 90000000000)\]
  2. 0

    Newbie: Problems with hsqldb

    Google Groups | 1 decade ago | bjoern
    java.sql.SQLException: Unexpected token: TEXT in statement [CREATE TEXT TABLE pupils (barcode VARCHAR, klasse VARCHAR, name VARCHAR, vorname VARCHAR, Geburtsdat VARCHAR, fremdsprac VARCHAR )]
  3. 0

    Exception when adding an index to a table

    hsqldb | 1 decade ago | nobody
    java.sql.SQLException: File input/output errorSaveRow java.io.IOException: Not enough storage is available to process this command in statement \[CREATE INDEX locs\_name\_idx ON locs (name)\]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error adding index to a table

    hsqldb | 1 decade ago | nobody
    java.sql.SQLException: File input/output errorSaveRow java.io.IOException: Not enough storage is available to process this command in statement \[CREATE INDEX locs\_name\_idx ON locs (name)\]
  6. 0

    Assert Failed inside of Hypersonic

    hsqldb | 1 decade ago | johansend
    java.sql.SQLException: Assert failed

    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. java.sql.SQLException

      Wrong data type in statement \[INSERT INTO PERSON (PERSONID,PASSWORD,VITAL,ENABLED,DEFAULTTALLGROUPID,EXPIRATIONDATE) VALUES (1, 'frodo', 1, 1, 1, 90000000000)\]

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcStatement.execute
      1. org.hsqldb.Trace.getError(Unknown Source)
      2. org.hsqldb.jdbcResultSet.<init>(Unknown Source)
      3. org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
      4. org.hsqldb.jdbcConnection.execute(Unknown Source)
      5. org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:1831)
      6. org.hsqldb.jdbcStatement.execute(jdbcStatement.java:756)
      6 frames
    3. com.tallgroup.util
      DataMain.executeThrowableInsert
      1. com.tallgroup.util.DataMain.executeThrowableInsert(DataMain.java:1037)
      1 frame