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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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

    Trying to deploy Railo as war file | JBoss Developer

    jboss.org | 7 months ago
    java.sql.SQLException: Table already exists: JBM_DUAL in statement [CREATE TABLE JBM_DUAL]
  3. 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]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java SQL-statement problems

    Stack Overflow | 3 years ago | iHank
    java.sql.SQLException: Column not found: HANK
  6. 0

    SimpleJdbcTestUtils.executeScript and multilines script

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

    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