java.sql.SQLException: Unexpected token: GENERATED in statement \[create table MYTABLE (ID\_ bigint generated by default as identity (start with 1), primary key (ID\_))\]

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via hsqldb by tombaeyens
, 1 year ago
Unexpected token: GENERATED in statement \[create table MYTABLE (ID\_ bigint generated by default as identity (start with 1), primary key (ID\_))\]
via hsqldb by csplrj
, 1 year ago
Unexpected token: TEMPORARY in statement \[CREATE TEMPORARY TABLE UtilityRelationship (Id INTEGER,MasterTableId INTEGER,ChildTableId INTEGER,MasterColumn VARCHAR,ChildColumn VARCHAR,MasterColumnGetSet VARCHAR,ChildColumnGetSet VARCHAR,RelationshipTypeId INTEGER,ExtraFieldFieldName VARCHAR,ExtraFieldIndex INTEGER,TableListSingleRecord BIT,TableListWidth INTEGER)\]
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 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 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
java.sql.SQLException: Unexpected token: GENERATED in statement \[create table MYTABLE (ID\_ bigint generated by default as identity (start with 1), primary key (ID\_))\]
at org.hsqldb.Trace.getError(Trace.java:263)
at org.hsqldb.jdbcResultSet.(jdbcResultSet.java:6660)
at org.hsqldb.jdbcConnection.executeStandalone(jdbcConnection.java:3001)
at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:2579)
at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:1804)
at org.hsqldb.jdbcStatement.execute(jdbcStatement.java:728)
at org.hsqldb.jdbcPreparedStatement.execute(jdbcPreparedStatement.java:1279)
at undefined.HsqldbTest.testHypersonic(HsqldbTest.java:16)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

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