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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via hsqldb by mattfair
, 1 year 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
via hsqldb by kobudo10
, 1 year ago
Wrong data type: String index out of range: 10 in statement \[Insert into FortisTable values (2003,1,3903-06-25,3903-06-25,'+600','EUR','Contrepartie OPeration','detaildetaildetail','000-0000000-00','')\]
via hsqldb by csplrj
, 1 year ago
Column already exists in statement \[CREATE TABLE UtilityRelationship (AId INTEGER,MasterTableId INTEGER,MasterTableId INTEGER,MasterColumn VARCHAR,ChildColumn VARCHAR,MasterColumnGetSet VARCHAR,ChildColumnGetSet VARCHAR,RelationshipTypeId INTEGER,ExtraFieldFieldName VARCHAR,ExtraFieldIndex INTEGER,TableListSingleRecord BOOLEAN,TableListWidth INTEGER)\]
via hsqldb by johansend
, 1 year ago
Wrong data type in statement \[INSERT INTO PERSON (PERSONID,PASSWORD,VITAL,ENABLED,DEFAULTTALLGROUPID,EXPIRATIONDATE) VALUES (1, 'frodo', 1, 1, 1, 90000000000)\]
via Google Groups by bjoern, 2 years ago
Unexpected token: TEXT in statement [CREATE TEXT TABLE pupils (barcode VARCHAR, klasse VARCHAR, name VARCHAR, vorname VARCHAR, Geburtsdat VARCHAR, fremdsprac VARCHAR )]
via hsqldb by nobody
, 1 year ago
File input/output error: saveSorted java.lang.ClassCastException: java.lang.Float in statement \[ALTER TABLE \_DSMS\_2ENCOURS DROP COLUMN ColumnName ;\]
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.(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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.