org.hsqldb.util.DataAccessPointException: Unexpected token: PRIMARY in statement \[CREATE TABLE galaxia\_activities(activityId  INTEGER IDENTITY ,name VARCHAR,nor malized\_name VARCHAR,pId INTEGER DEFAULT 0 NOT NULL ,type CHAR(10),isAutoRouted CHAR(1),flowNum INTEGER,isInteractive CHAR(1),lastModif INTEGER,description LONG VARCHAR, CONSTRAINT PRIMARY\]

hsqldb | jimcaprioli | 1 decade ago
  1. 0

    transfer from MySQL ...

    hsqldb | 1 decade ago | jimcaprioli
    org.hsqldb.util.DataAccessPointException: Unexpected token: PRIMARY in statement \[CREATE TABLE galaxia\_activities(activityId  INTEGER IDENTITY ,name VARCHAR,nor malized\_name VARCHAR,pId INTEGER DEFAULT 0 NOT NULL ,type CHAR(10),isAutoRouted CHAR(1),flowNum INTEGER,isInteractive CHAR(1),lastModif INTEGER,description LONG VARCHAR, CONSTRAINT PRIMARY\]
  2. 0

    Getting error during transfer

    hsqldb | 1 decade ago | blevinson
    org.hsqldb.util.DataAccessPointException: Unexpected token: PRIMARY in statement \[CREATE TABLE dcicategory(dciId VARCHAR Default '' NOT NULL ,title VARCHAR,dciD escription LONGVARCHAR,showtext INTEGER Default 0,comment LONGVARCHAR,sortOrder INTEGER Default 0,categoryType INTEGER Default 0,submittedBy VARCHAR,Object\_Time stamp BIGINT, CONSTRAINT PRIMARY\]
  3. 0

    Getting error during transfer

    hsqldb | 1 decade ago | blevinson
    org.hsqldb.util.DataAccessPointException: Unexpected token: PRIMARY in statement \[CREATE TABLE dcicategory(dciId VARCHAR Default '' NOT NULL ,title VARCHAR,dciD escription LONGVARCHAR,showtext INTEGER Default 0,comment LONGVARCHAR,sortOrder INTEGER Default 0,categoryType INTEGER Default 0,submittedBy VARCHAR,Object\_Time stamp BIGINT, CONSTRAINT PRIMARY PRIMARY KEY (dciId) )\]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    transfer from MySQL ...

    hsqldb | 1 decade ago | jimcaprioli
    org.hsqldb.util.DataAccessPointException: Wrong data type: SERIAL in statement \[ CREATE TABLE galaxia\_activities(activityId SERIAL\]
  6. 0

    Getting error during transfer

    hsqldb | 1 decade ago | blevinson
    org.hsqldb.util.DataAccessPointException: Try to insert null into a non-nullable column: column: DATETIMEOFLASTMODIFICATION table: DCIRESOUR CE in statement \[INSERT INTO dciresource VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\]60136

    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. org.hsqldb.util.DataAccessPointException

      Unexpected token: PRIMARY in statement \[CREATE TABLE galaxia\_activities(activityId  INTEGER IDENTITY ,name VARCHAR,nor malized\_name VARCHAR,pId INTEGER DEFAULT 0 NOT NULL ,type CHAR(10),isAutoRouted CHAR(1),flowNum INTEGER,isInteractive CHAR(1),lastModif INTEGER,description LONG VARCHAR, CONSTRAINT PRIMARY\]

      at org.hsqldb.util.TransferDb.execute()
    2. HSQLDB
      Transfer.transfer
      1. org.hsqldb.util.TransferDb.execute(Unknown Source)
      2. org.hsqldb.util.TransferTable.transferStructure(Unknown Source)
      3. org.hsqldb.util.Transfer.transfer(Unknown Source)
      3 frames