java.sql.SQLException

error in script file line: 2 Unexpected token in statement \[CREATE TABLE KASSEKLADE(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,DATO DATE,BILAG VARCHAR(10),BILAGSTEKST VARCHAR(100),KONTONR VARCHAR(10),DEBIT DOUBLE,KREDIT DOUBLE,AFSTEMNINGSKONTO VARCHAR(10),FAKTURANR INTEGER(10))\]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web15146

  • error in script file line: 2 Unexpected token in statement \[CREATE TABLE KASSEKLADE(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,DATO DATE,BILAG VARCHAR(10),BILAGSTEKST VARCHAR(100),KONTONR VARCHAR(10),DEBIT DOUBLE,KREDIT DOUBLE,AFSTEMNINGSKONTO VARCHAR(10),FAKTURANR INTEGER(10))\]
  • via Google Groups by lookie, 11 months ago
    Unexpected token: YEAR in statement [CREATE TABLE "CROP_PLANS" ( id INTEGER IDENTITY, plan_name VARCHAR(256) year]
  • 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)\]
  • Stack trace

    • java.sql.SQLException: error in script file line: 2 Unexpected token in statement \[CREATE TABLE KASSEKLADE(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,DATO DATE,BILAG VARCHAR(10),BILAGSTEKST VARCHAR(100),KONTONR VARCHAR(10),DEBIT DOUBLE,KREDIT DOUBLE,AFSTEMNINGSKONTO VARCHAR(10),FAKTURANR INTEGER(10))\] at org.hsqldb.jdbcDriver.sqlException(Unknown Source) at org.hsqldb.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at kontoplan.funktion.ConnectDB.<init>(ConnectDB.java:19) at kontoplan.funktion.ConnectDB.getInstance(ConnectDB.java:38) at kontoplan.funktion.Util.getDB(Util.java:24) at SystemStart.<init>(SystemStart.java:77) at SystemStart.main(SystemStart.java:75)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago