java.sql.SQLException: Unexpected token: YEAR in statement [CREATE TABLE "CROP_PLANS" ( id INTEGER IDENTITY, plan_name VARCHAR(256) year]

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 Google Groups by lookie, 1 year ago
Unexpected token: YEAR in statement [CREATE TABLE "CROP_PLANS" ( id INTEGER IDENTITY, plan_name VARCHAR(256) year]
via hsqldb by andream1977
, 1 year ago
Unexpected token: HEADER in statement \[HEADER\]
via empire-user by Joel Becker, 1 year ago
Primary or unique constraint required on main > table: VOTERS in statement [-- creating foreign key constraint > absentee_ballo_registrant_i_FK -- ALTER TABLE absentee_ballots ADD CONSTRAINT absentee_ballo_registrant_i_FK > FOREIGN KEY (registrant_id) REFERENCES voters (id)]
via empire-user by Rainer Döbele, 1 year ago
Primary or unique constraint required on main > table: > > VOTERS in statement [-- creating foreign key constraint > > absentee_ballo_registrant_i_FK -- ALTER TABLE absentee_ballots ADD CONSTRAINT > > absentee_ballo_registrant_i_FK FOREIGN KEY (registrant_id) REFERENCES > > voters (id)]
via empire-user by Francis De Brabandere, 1 year ago
Primary or unique constraint required on main table: > VOTERS in statement [-- creating foreign key constraint > absentee_ballo_registrant_i_FK -- ALTER TABLE absentee_ballots ADD CONSTRAINT absentee_ballo_registrant_i_FK > FOREIGN KEY (registrant_id) REFERENCES voters (id)]
via empire-user by Joel Becker, 1 year ago
Primary or unique constraint required on main > table: VOTERS in statement [-- creating foreign key constraint > absentee_ballo_registrant_i_FK -- ALTER TABLE absentee_ballots ADD CONSTRAINT absentee_ballo_registrant_i_FK > FOREIGN KEY (registrant_id) REFERENCES voters (id)]
java.sql.SQLException: Unexpected token: YEAR in statement [CREATE TABLE "CROP_PLANS" ( id INTEGER IDENTITY, plan_name VARCHAR(256) year]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at CPS.Core.DB.HSQLDBCreator.createTables(HSQLDBCreator.java:54)
at CPS.Core.DB.HSQLConnect.connectToNew(HSQLConnect.java:152)
at CPS.Core.DB.HSQLConnect.createDB(HSQLConnect.java:49)
at CPS.Core.DB.HSQLDB.initAndUpdateDB(HSQLDB.java:81)
at CPS.Core.DB.HSQLDB.(HSQLDB.java:72)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at CPS.ModuleManager.loadPlugin(ModuleManager.java:121)
at CPS.ModuleManager.loadPlugin(ModuleManager.java:84)
at CPS.ModuleManager.getDM(ModuleManager.java:56)
at CPS.CropPlanning.(CropPlanning.java:57)
at CPS.CropPlanning.main(CropPlanning.java:38)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
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.