java.sql.SQLException: Unexpected token: 37000 Unexpected token: FOO in statemen t \[CREATE VIEW FOO\_VIEW AS  select foo() foo from dual\]

hsqldb | dmiller_va | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 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\]
  2. 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))\]
  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 | 9 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

      Unexpected token: 37000 Unexpected token: FOO in statemen t \[CREATE VIEW FOO\_VIEW AS  select foo() foo from dual\]

      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