java.sql.SQLException: Wrong data type: BOOLEAN in statement \[create table apollo\_storeproducts(name varchar(50), id varchar(50), category varchar(50), type varchar(50), brand varchar(50), online boolean, shortdescription int, longdescription int, price double, tax varchar(50), template varchar(50), promotion varchar(50), thumbnail int, image int, featured boolean, created timestamp, availability varchar(50), instock boolean)\]

hsqldb | mattfair | 2 decades ago
  1. 0

    Wrong Data Type: Boolean

    hsqldb | 2 decades ago | mattfair
    java.sql.SQLException: Wrong data type: BOOLEAN in statement \[create table apollo\_storeproducts(name varchar(50), id varchar(50), category varchar(50), type varchar(50), brand varchar(50), online boolean, shortdescription int, longdescription int, price double, tax varchar(50), template varchar(50), promotion varchar(50), thumbnail int, image int, featured boolean, created timestamp, availability varchar(50), instock boolean)\]
  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: BOOLEAN in statement \[create table apollo\_storeproducts(name varchar(50), id varchar(50), category varchar(50), type varchar(50), brand varchar(50), online boolean, shortdescription int, longdescription int, price double, tax varchar(50), template varchar(50), promotion varchar(50), thumbnail int, image int, featured boolean, created timestamp, availability varchar(50), instock boolean)\]

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcStatement.execute
      1. org.hsqldb.Trace.getError(Trace.java:180)
      2. org.hsqldb.jdbcResultSet.<init>(jdbcResultSet.java:2645)
      3. org.hsqldb.jdbcConnection.executeStandalone(jdbcConnection.java:994)
      4. org.hsqldb.jdbcConnection.execute(jdbcConnection.java:721)
      5. org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)
      6. org.hsqldb.jdbcStatement.execute(jdbcStatement.java:354)
      6 frames
    3. org.opensimpx.client
      Login.main
      1. org.opensimpx.client.HSQLProxy.execute(HSQLProxy.java:194)
      2. org.opensimpx.client.HSQLProxy.importTable(HSQLProxy.java:223)
      3. org.opensimpx.client.login.Login.startClient(Login.java:459)
      4. org.opensimpx.client.login.Login.main(Login.java:335)
      4 frames