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

hsqldb | blevinson | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 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\]
  2. 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\]

    Root Cause Analysis

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

      at org.hsqldb.util.TransferDb.execute()
    2. HSQLDB
      Transfer.actionPerformed
      1. org.hsqldb.util.TransferDb.execute(Unknown Source)
      2. org.hsqldb.util.TransferTable.transferStructure(Unknown Source)
      3. org.hsqldb.util.Transfer.transfer(Unknown Source)
      4. org.hsqldb.util.Transfer.actionPerformed(Unknown Source)
      4 frames
    3. Java RT
      EventDispatchThread.run
      1. java.awt.Button.processActionEvent(Button.java:381)
      2. java.awt.Button.processEvent(Button.java:350)
      3. java.awt.Component.dispatchEventImpl(Component.java:3526)
      4. java.awt.Component.dispatchEvent(Component.java:3367)
      5. java.awt.EventQueue.dispatchEvent(EventQueue.java:445)
      6. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:190)
      7. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:144)
      8. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
      9. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:130)
      10. java.awt.EventDispatchThread.run(EventDispatchThread.java:98)
      10 frames