java.sql.SQLException: Attempt to define a second primary key: S0011 Attempt to define a second primary key in statement \[CREATE TEXT TABLE S\_DIVISAO(CODIGO VARCHAR(2),DESCRICAO VARCHAR(20), constraint divisao\_pk PRIMARY KEY(codigo))\]

hsqldb | nvolpini | 1 decade ago
  1. 0

    Constraints in Text Tables

    hsqldb | 1 decade ago | nvolpini
    java.sql.SQLException: Attempt to define a second primary key: S0011 Attempt to define a second primary key in statement \[CREATE TEXT TABLE S\_DIVISAO(CODIGO VARCHAR(2),DESCRICAO VARCHAR(20), constraint divisao\_pk PRIMARY KEY(codigo))\]
  2. 0

    View problem with user-defined function

    hsqldb | 1 decade ago | dmiller_va
    java.sql.SQLException: Unexpected token: 37000 Unexpected token: FOO in statemen t \[CREATE VIEW FOO\_VIEW ASĀ  select foo() foo from dual\]
  3. 0

    HSQLDB - User - Error of loading a database

    nabble.com | 1 year ago
    java.sql.SQLException: Unexpected token: Unexpected token: DATABASE in > >> statement [SET DATABASE UNIQUE NAME HSQLDB2AD6DE5067]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    'Re: [Hsqldb-user] Error of loading a database' - MARC

    marc.info | 1 year ago
    java.sql.SQLException: Unexpected token: Unexpected token: DATABASE in > >> >> statement [SET DATABASE UNIQUE NAME HSQLDB2AD6DE5067]
  6. 0

    JBoss Community / Mailing Lists

    sourceforge.net | 6 months ago
    java.sql.SQLException: File input/output error: File input/output error: reading: java.io.EOFException in statement [SET TABLE JMS_MESSAGES INDEX '19640 8']

    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

      Attempt to define a second primary key: S0011 Attempt to define a second primary key in statement \[CREATE TEXT TABLE S\_DIVISAO(CODIGO VARCHAR(2),DESCRICAO VARCHAR(20), constraint divisao\_pk PRIMARY KEY(codigo))\]

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      Server.main
      1. org.hsqldb.Trace.getError(Trace.java:226)
      2. org.hsqldb.Log.runScript(Log.java:863)
      3. org.hsqldb.Log.open(Log.java:306)
      4. org.hsqldb.Database$Logger.openLog(Database.java:2596)
      5. org.hsqldb.Database.<init>(Database.java:203)
      6. org.hsqldb.Server.openDB(Server.java:178)
      7. org.hsqldb.Server.run(Server.java:197)
      8. org.hsqldb.Server.main(Server.java:147)
      8 frames