java.sql.SQLException

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

Solutions on the web6931

  • Unexpected token: 37000 Unexpected token: FOO in statemen t \[CREATE VIEW FOO\_VIEW AS  select foo() foo from dual\]
  • via Pentaho BI Platform Tracking by David Kincade, 1 year ago
    Table not found in statement [select foo from bar]
  • via Pentaho BI Platform Tracking by David Kincade, 1 year ago
    Table not found in statement [select foo from bar]
  • Stack trace

    • 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(Trace.java:226) at org.hsqldb.Log.runScript(Log.java:863) at org.hsqldb.Log.open(Log.java:306) at org.hsqldb.Database$Logger.openLog(Database.java:2596) at org.hsqldb.Database.<init>(Database.java:203) at org.hsqldb.Server.openDB(Server.java:178) at org.hsqldb.Server.run(Server.java:197) at org.hsqldb.Server.main(Server.java:147)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago