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))\]

hsqldb | nobody | 1 decade ago
  1. 0

    Get an exception with hsqldb_1_7_2_ALPHA_N

    hsqldb | 1 decade ago | nobody
    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))\]
  2. 0

    Disabling lock file

    hsqldb | 1 decade ago | nobody
    fr.auzou.dea.db.DatabaseException: java.sql.SQLException: The database is already in use by another process: org.hsqldb.NIOLockFile@c83d3564\[file =D:\data\dea\_db.lck, exists=false, locked=false, valid=false, fl =null\]: java.io.FileNotFoundException: data\dea\_db.lck (Accs refus)
  3. 0

    hsqldb bypass authentication: reset forgotten user and password

    Stack Overflow | 5 years ago | GreyCat
    java.sql.SQLException: User not found: SA
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDO - datanucleus - HSQL error

    Stack Overflow | 5 years ago | Aniruddha
    java.sql.SQLException: socket creation error

    5 unregistered visitors
    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

      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()
    2. HSQLDB
      jdbcDriver.connect
      1. org.hsqldb.jdbcDriver.sqlException(Unknown Source)
      2. org.hsqldb.jdbcConnection.<init>(Unknown Source)
      3. org.hsqldb.jdbcDriver.getConnection(Unknown Source)
      4. org.hsqldb.jdbcDriver.connect(Unknown Source)
      4 frames
    3. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:512)
      2. java.sql.DriverManager.getConnection(DriverManager.java:171)
      2 frames
    4. kontoplan.funktion
      Util.getDB
      1. kontoplan.funktion.ConnectDB.<init>(ConnectDB.java:19)
      2. kontoplan.funktion.ConnectDB.getInstance(ConnectDB.java:38)
      3. kontoplan.funktion.Util.getDB(Util.java:24)
      3 frames
    5. Unknown
      SystemStart.main
      1. SystemStart.<init>(SystemStart.java:77)
      2. SystemStart.main(SystemStart.java:75)
      2 frames