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

Google Groups | lookie | 9 years ago
  1. 0

    SQL Error while build and run main project

    Google Groups | 9 years ago | lookie
    java.sql.SQLException: Unexpected token: YEAR in statement [CREATE TABLE "CROP_PLANS" ( id INTEGER IDENTITY, plan_name VARCHAR(256) year]
  2. 0

    Mapping a table called "group" in Hibernate for DB2 and HSQLDB

    Stack Overflow | 7 years ago | Juha Syrjälä
    java.sql.SQLException: Unexpected token: GROUP in statement [create table group]
  3. 0

    Java SQL-statement problems

    Stack Overflow | 3 years ago | iHank
    java.sql.SQLException: Column not found: HANK
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SimpleJdbcTestUtils.executeScript and multilines script

    Stack Overflow | 7 years ago | romaintaz
    java.sql.SQLException: Unexpected token: in statement [CREATE TABLE T_FOO (]
  6. 0

    HSQLDB Trigger Statement ERROR when using SimpleJdbcTestUtils.executeSqlScript()

    Stack Overflow | 5 years ago | JavaLady
    java.sql.SQLException: Unexpected end of command: REFERENCING in statement [CREATE TRIGGER t BEFORE UPDATE ON SUBJECTS REFERENCING]

    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

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

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcStatement.executeUpdate
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
      3 frames
    3. CPS.Core.DB
      HSQLDB.<init>
      1. CPS.Core.DB.HSQLDBCreator.createTables(HSQLDBCreator.java:54)
      2. CPS.Core.DB.HSQLConnect.connectToNew(HSQLConnect.java:152)
      3. CPS.Core.DB.HSQLConnect.createDB(HSQLConnect.java:49)
      4. CPS.Core.DB.HSQLDB.initAndUpdateDB(HSQLDB.java:81)
      5. CPS.Core.DB.HSQLDB.<init>(HSQLDB.java:72)
      5 frames
    4. Java RT
      Constructor.newInstance
      1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      4. java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      4 frames
    5. CPS
      CropPlanning.main
      1. CPS.ModuleManager.loadPlugin(ModuleManager.java:121)
      2. CPS.ModuleManager.loadPlugin(ModuleManager.java:84)
      3. CPS.ModuleManager.getDM(ModuleManager.java:56)
      4. CPS.CropPlanning.<init>(CropPlanning.java:57)
      5. CPS.CropPlanning.main(CropPlanning.java:38)
      5 frames