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)\]

Solutions on the web9091

  • via hsqldb by mattfair
    , 11 months ago
    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
  • invalid schema name: BIGNIBOU in statement [create table "BIGNIBOU"."DBMAINTAIN_SCRIPTS" ( FILE_NAME VARCHAR(150), VERSION VARCHAR(25), FILE_LAST_MODIFIED_AT BIGINT, CHECKSUM VARCHAR(50), EXECUTED_AT VARCHAR(20), SUCCEEDED BIGINT )]
  • java.lang.NumberFormatException: For input string: "11) BEGIN declare linstructorid int; declare ltemplateusername varchar(50); declare ltemplateinstructorid int; declare lpermtemplateusername varchar(50); declare lpermtemplateinstructorid int;
  • Stack trace

    • 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(Trace.java:180) at org.hsqldb.jdbcResultSet.<init>(jdbcResultSet.java:2645) at org.hsqldb.jdbcConnection.executeStandalone(jdbcConnection.java:994) at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:721) at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686) at org.hsqldb.jdbcStatement.execute(jdbcStatement.java:354) at org.opensimpx.client.HSQLProxy.execute(HSQLProxy.java:194) at org.opensimpx.client.HSQLProxy.importTable(HSQLProxy.java:223) at org.opensimpx.client.login.Login.startClient(Login.java:459) at org.opensimpx.client.login.Login.main(Login.java:335)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago