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

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • transfer from MySQL ...
    via hsqldb by jimcaprioli
    ,
  • Getting error during transfer
    via hsqldb by blevinson
    ,
    • 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(Unknown Source) at org.hsqldb.util.TransferTable.transferStructure(Unknown Source) at org.hsqldb.util.Transfer.transfer(Unknown Source)
    No Bugmate found.